April 22, 2015 at 12:13 pm
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?
April 28, 2015 at 3:41 pm
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