Friday, August 07, 2015

Can you use a stored procedure to provide data to an SSRS report?

Yes, you can use a stored procedure to provide data to an SSRS report by configuring the dataset to use a stored procedure command type. 
However, your stored procedure should return only a single result set. If it returns multiple result sets, only the first one is used for the report dataset.

No comments:

Post a Comment