November 13, 2014 at 1:52 pm
Hello,
I created a parameter named @agency. For Available Values, I use OS as the label and agency code 559 as the value and also use IS as another label and agency code 660 as the value. It is working fine. However I want to use OS and IS (combine two as one) as the label and then set up agency codes 559 and 660 as the value. I think I need to use expression. I am unable to do that correctly. Please advise.
Thanks
Frank
November 13, 2014 at 5:50 pm
Definitely a case where some sample data would go a long way.
That said, I think you could use a UNION query to get what you want.
November 13, 2014 at 8:04 pm
fliu2265 (11/13/2014)
Hello,I created a parameter named @agency. For Available Values, I use OS as the label and agency code 559 as the value and also use IS as another label and agency code 660 as the value. It is working fine. However I want to use OS and IS (combine two as one) as the label and then set up agency codes 559 and 660 as the value. I think I need to use expression. I am unable to do that correctly. Please advise.
Thanks
Frank
Do you want to show them as a single value or to be able to select both of them ? The latter simply requires you to configure the parameter to allow multiple values. You datasets will also need to be able to handle multiple values (SSRS sends them to SQL as comma separated list of values).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply