Stored Procedure as Data Source with SSRS

• var05

  Hall of Fame

  Points: 3011

  More actions

  January 30, 2013 at 8:00 am

  #270161

  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!

• Scott Murray-240410

  SSCarpal Tunnel

  Points: 4649

  More actions

  January 31, 2013 at 5:49 am

  #1582914

  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/%5B/url%5D