August 8, 2012 at 1:16 pm
In Reporting Services 2005, I have a paramter In (@agency). The parameter values has its own dataset which has multiple values like T215, T216, F312.....I have it where the user can select multiple values and everything works great. How can I combine some of the values to be 1 value. Right now there are 2,000 values to choose from and the user may want all the values that start with F% or A%. I tried to achieve this by using a case statement but it did not like it because of the In (@agency). Any advise...
August 8, 2012 at 2:04 pm
This is a sin in terms of query optimization but you could use
WHERE LEFT(Agency,1) IN (Your 1 character values here)
You could also do this with an additional query in your dataset where you take the left character values and produce a list of the full values that can then be used in the where clause of your dataset output query.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply