SQL Reporting Services 2008
I have a parameter called 'activitytype' which can have a value of 'desktop', 'visit' or 'both'. If the user selects 'desktop' or 'visit' then I will filter on the field called 'activity' in my query equals the parameter called 'activitytype' which
I can do fine. However if the user selects 'both', then i want it to filter on 'activity' = 'visit' OR 'activity' = 'desktop'. I can't see how to add this to the where clause in my query, and i don't want to have to create a stored procedure for evey report
i write as most of the parameters we use are similar to this.
If I was doing this in a stored procedure I would just create a string variable and add the select statement with the correct where clause to it and then do an EXEC on it, but I can't seem to do that in the query in reporting services.
Is there a way to do this filter in SQL Reporting Services itself?
View Complete Post