Monday, March 26, 2012

Reporting Services 2005 and Stored Procedures

I am a complete Newbie with RS2005 and had some questions if anyone would be kind enough to answer:
Can I use Stored Procedures in my report? I have a lot of calculated fields that need to go on the reportWould it also be easy enough to display graphs along with the data from the results obtained from the stored procedures?

Hello, in response to your questions...

Yes, you can use stored procedures, and it's highly recommended. When you create a DataSet, you simply set the command type to 'Stored Procedure', and then put the stored procedure's name in as the query string.

And yes again, charts are an integrated part of RS 2005. If you are developing your reports in Visual Studio, you can drag and drop a chart control form the toolbox, and then drag and drop the data fields you wish to use onto the appropriate sections of your chart from your DataSets window.

Hope this helps - Dan

No comments:

Post a Comment