Creating one ssrs report that can use one of multiple stored procedures?
Is there a way to develop a single, generic ssrs report, that can dynamically decide which stored procedure to access? I need to create a dozen different admin reports, all of which look exactly the same. The only difference being the data displayed. My boss suggested I create a single report, that accepts a parameter that informs the ssrs which report to run. So for example, if the url is "MyReports/GenericReport?rptName=OrdersReport", my ssrs will know "OrdersReport" means the "rpt_OrdersReport" stored procedure is what needs to be used. Does anyone know how to do this of know of any online tutorials? Thanks.
June 11th, 2012 10:00pm

Hi There You will be able to achieve this, please create a wrapper stored procedure for your report and in that wrapper stored procedure you can call multiple stored procedure(as many as you want) based on your parameter value. Please make sure that the columns name returned from all these stored procedure, you give them exactly same mask so that you can use one mask for all your values from different stored procedure If @Reporttorun= OrdersReport Exec dbo.GetOrdersReportvalues Else if @Reporttorun= inventoryReport Exec dbo.GetInventoryReportvalues else Exec dbo.GetStockReportvalues I hope this will help. If you have any questions please ask. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
June 11th, 2012 10:56pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics