October 13, 2017 at 7:51 am
Hi MASTERS, I was asked to build some SSRS reports but for the first time against an ORACLE DB. All good up to the point where I need to be able to ALLOW MULTIPLE VALUES. How do I get around this challenge?
SELECT * FROM TABLE WHERE City IN :p_city
In the parameter value of the parameters dataset tab, I tried to =JOIN(Parameters.p_city.Value, ",") but no luck.
Thanks in advance
October 13, 2017 at 8:19 am
d_martins - Friday, October 13, 2017 7:51 AMHi MASTERS, I was asked to build some SSRS reports but for the first time against an ORACLE DB. All good up to the point where I need to be able to ALLOW MULTIPLE VALUES. How do I get around this challenge?
SELECT * FROM TABLE WHERE City IN :p_city
In the parameter value of the parameters dataset tab, I tried to =JOIN(Parameters.p_city.Value, ",") but no luck.
Thanks in advance
Check this article - the approach is a little bit different than the expression =JOIN(Parameters....etc. to pass in the values:
SQL Server Reporting Services, Oracle, and Multivalued Parameters
Sue
October 13, 2017 at 9:20 am
WORKS!
Thanks Sue_H
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply