ssrs 2012 parameter selection

  • In an existing ssrs 2012 report, I want to basically add the following logic to a new dataset that will be used by a new parameter called 'Inventory'.

    SELECT DISTINCT Inv_number as value, Inv_name as label

    FROM s.dbo.fnUser( @endYear, 0, 0, 0)

    WHERE (@report is not null)

    order by label,value

    In this ssrs report, there are 15 reports that can automatically be generated. I basically want this new parameter called 'Inventory' to only be active

    when the 4th report is selected to be generated. Thus in the query I listed above, how can I change the query to only be active when the 4th report is selected?

    I tried to change the where clause to (@report(4) is not null), but that did not work. Thus can you show me the sql I can use to accomplish my goal?

  • If the parameter is a drop-down box with the data type set to Integer and the value is the Inventory number you're after, try

    WHERE (@report = 4)

    If you the parameter tick-box to allow multiple values is ticked:

    WHERE (4 in (@report))

    Does the above make sense to your situation?

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

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