Post reply

How to implement Multivalue in sql server reports 2005

  • March 21, 2006 at 9:51 pm

    #189914

    Hi Every body,

    I do have a problem with multivalue.

    Here is My query

    SELECT CLT.Client_Name,

    CCT.ProjectName,

    UST.User_Name,

    SUM(TST.Hours) Hours,

    CONVERT(VARCHAR(30),DBO.HOURS_SUMMARY(TST.WORKDATE),101) WEEKEND

    FROM dbo.Timesheet_TBL TST

    JOIN dbo.User_TBL UST

    ON UST.User_id=TST.User_id

    JOIN dbo.ChargeCode_TBL CCT

    ON CCT.ChargeCode_id=TST.ChargeCode_id

    JOIN dbo.Client_TBL CLT

    ON CLT.Client_id=CCT.Client_id

    WHERE CONVERT(VARCHAR(30), TST.Workdate,101)>= CONVERT(VARCHAR(30),@FROM_DATE,101) AND

    CONVERT(VARCHAR(30), TST.Workdate,101)<= CONVERT(VARCHAR(30),@TO_DATE,101) AND
    UST.Company_id IN (@COMPANY_NAME) AND
    TST.BILLABLE=@Billable

    GROUP BY CLT.Client_Name,
    CCT.ProjectName,UST.User_Name,
    CONVERT(VARCHAR(30),DBO.HOURS_SUMMARY(TST.WORKDATE),101)

    In this i need to impelement mutivalue for @billable parameter in the where clause, where it is showing Error in the preview if i give select all, Pls help me in modyfying the report . i gave Y and N as two nonqueried values in Report parameters, it will be either Y or N, How can i implement this report such that it should take both Y and N in the query
    Thank you
    Raj Deep.A

  • March 23, 2006 at 9:12 am

    #628383

    Raj,

    Change your WHERE clause to "WHERE .... AND TST.Billable IN ( @Billable ).  This only works if the query is embedded in the .rdl.  If your using a stored procedure pass @Billable ( which is a comma delimited string ) to the procedure, parse it into a table variable, and then JOIN that table variable to TST.Billable. 

    Hope this helps.

    Mike

  • March 25, 2006 at 1:58 am

    #628768

    Thank you Mike , Its working

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply