Stored Procedure as Data Source with SSRS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Stored Procedure as Data Source with SSRS

Stored Procedure as Data Source with SSRS

Rate Topic

Display Mode

Topic Options

Author

Message

var05

Posted Wednesday, January 30, 2013 8:00 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, April 16, 2013 9:13 AM
Points: 83, Visits: 362

Hi All,
I have a stored procedure with multiple paramaters like

Start Date- custom calendar
End Date-custom calendar
Status - they contain multiple values
Group namethey contain multiple values

Can a stored procedure can be used as a data source for SSRS reports that contain multiple values??

How is that possible?? Perfomance point of view its better to replace the query in data sets with SP... could any one please let me know how is this possible

Thanks!

Post #1413647

Scott Murray-240410

Posted Thursday, January 31, 2013 5:49 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 5:49 AM
Points: 159, Visits: 2,202

Yes it can... Please take a look at this MSSQL Tip from a few weeks back>
http://www.mssqltips.com/sqlservertip/2866/sql-server-reporting-services-using-multivalue-parameters/

Post #1414034

« Prev Topic | Next Topic »

Permissions