Showing posts with label rs2005. Show all posts
Showing posts with label rs2005. Show all posts

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

Reporting Services 2005 & IE7 Beta

When trying to print an RS2005 report, I keep getting the error "Unable to
load client print control". This is because the RSClientPrint ActiveX
control is not loaded. I have noticed that in IE7 Beta is not automatically
prompting to download the control. Has anyone been successful in running
this under IE7? I am using 7.0.5112.0, Beta 1.
* "Enable download for the ActiveX client print control" is enabled on the
server.
* Report Server added to the Trusted Sites list
* Download Signed ActiveX Controls = Enable
* Script ActiveX Controls Marked Safe for Scripting = Enable
* Automatic Prompting for ActiveX Controls = Enable
Works fine under IE6.
Thanks,
-sYou may want to insure that it is enabled.
Tools->Internet Options->Programs->Manage Add-ons
If RSCleintPrint Class is enabled, you may want to delete it and allow
it to be reinstalled.
Hope you get it to working,
Lonsql