Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Multi-Select Parameters for Reporting Services Expand / Collapse
Author
Message
Posted Monday, August 20, 2007 5:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 25, 2012 8:14 AM
Points: 6, Visits: 91
This is only for reports that run occasionally. most users select 1 to 3 clients, so it is not high on our list at this time to optimize this


Post #392002
Posted Monday, October 22, 2007 11:44 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 11, 2010 5:39 AM
Points: 45, Visits: 16
how can we write a query and pass multi value parameters to stored procedure in the report? To exec a procedure we simply write
Exec MyStoredProcedure

to exec a stored procedure we need to pass parameters. I can do Exec MyStoredProcedure IN (@ParamList)

I have gone through this thread conversations however, I am not able to make out when to use Split function and how to use.

In dataset, which query I need to write to exec a stored procedure with multi value parameters.



Post #413510
Posted Friday, March 19, 2010 4:34 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 4:23 PM
Points: 1, Visits: 133
Beautiful...it worked great!
Post #886779
Posted Friday, September 17, 2010 11:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 25, 2012 7:43 AM
Points: 1, Visits: 31
I'm running against Oracle. My query works fine with these small chages to Oracle syntax:

WHERE (:CommaDelimtedList || ',' LIKE '%' || TableColumnToCompareTo || ',%' OR @CommaDelimtedList = '')

However when I run the query in Reporting Services 2005 Sp2, if I choos more than one item in the multiselect, I get the error
"ORA-00920 Invalid relational operator"
Any idea what is happening?
Post #988471
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse