Multi-Select Parameters for Reporting Services

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Adriaan Davel » Multi-Select Parameters for Reporting...

24 posts, Page 3 of 3

«««1 2 3

Multi-Select Parameters for Reporting Services

Rate Topic

Display Mode

Topic Options

Author

Message

Jim Parzych

Posted Monday, August 20, 2007 5:51 AM

Forum 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

Jaishree

Posted Monday, October 22, 2007 11:44 AM

SSC 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

cerayg

Posted Friday, March 19, 2010 4:34 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:03 PM
Points: 1, Visits: 115

Beautiful...it worked great!

Post #886779

vze47pt5

Posted Friday, September 17, 2010 11:54 AM

Forum 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 »

24 posts, Page 3 of 3

«««1 2 3

Permissions