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