Post reply

Using Date Parameter in SSRS

  • November 2, 2009 at 3:12 am

    #212747

    Hi

    I have a report in wich i hav parameters :

    1. Date Range (From date and To date)

    2. Status..

    There is a possibility of using one parameter at a time or can use both parameters at same time.

    Now i hav to use both the parameters to get the report.

    How can i make my parameters optional..??

  • November 2, 2009 at 3:19 am

    #1073740

    if you go to properties of the report, u can specify default parameters.

    optionally u can set todate= startdate+5

  • November 2, 2009 at 3:33 am

    #1073744

    hey...

    thanx for the reply...

    But i don wan to give any date...it should be on the user to select the date or Status or both to get the data..

  • November 2, 2009 at 3:52 am

    #1073747

    sorry not sure what you are asking

  • November 8, 2009 at 1:45 pm

    #1076484

    from what i understand u might want to try

    something like

    startdate = isnull(@startdate,startdate)

    and status = isnull(@status,status)

    in the where clause of your dataset.

    But if you are more clear, i am sure someone can give u a solution.

    Thanks,

Viewing 5 posts - 1 through 4 (of 4 total)

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