Post reply

In SSRS 2005 in Preview tab, when I select some value on one input, corresponding valur for other input must be changed(See attach for more clearity)

  • October 31, 2014 at 4:59 am

    #312217

    working on on report where one input parameter value depends on selection of value of other input parameter before clicking on view Report button. Please see attach(SSRS question.png) reference

  • January 22, 2015 at 8:23 pm

    #1772470

    You may want to upload your image to an image sharing website - your attachments aren't opening.

    To chain report parameters, in your second parameter's query's WHERE clause, refer to @<first parameter's name>. If your first report parameter had a name of "YEAR", your second report parameter could have its "Available Values" setting set to "Get values from a query", and the data set query as:

    SELECT SALES.SALEDATE

    FROM SALES

    WHERE DATEPART(SALES.SALEDATE) = @YEAR

    If you selected 2015 as the "YEAR" parameter, the second parameter, hypothetical "Sales Date" would only show sales within 2015.

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

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