Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Answer / Gaurav Kumar Singh
Yes, you can use a stored procedure to provide data to an SQL Server Reporting Services (SSRS) report. To do this, create the stored procedure in your database and then add a dataset to the report that calls the stored procedure as its data source.
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between Sql server reporting services and Crystal reports?
what are the different types of SSRS reports?
How to add the custom code in Report?
What are the different types of data sources in ssrs?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What new data source types were added in ssrs 2014?
How would you go about developing a ssrs report?
What are drilldown reports?
What are drillthrough reports?
What are the new features of sql server 2012 reporting service?
What are the three different part of rdl file explain them?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?