SQL Reporting Services

Started using SQL Reporting Services recently and found it very useful. I used it to create a Reporting module on our current project with graphs and charts. It came out pretty good. With all the flexibility and the ease with which you can create Reports using Reporting Services, you are sure to like it once you use it.

Using SQL Reports is Fun. I have been having fun using it recently. It’s pretty cool. 
Wanted to figure out how to disable the Export Options in the SQL Reports when it is displayed to the user in Report Viewer. To be more specific I wanted to disable exporting in .pdf format. After looking around for it found  out it can be done in the rsreportserver.config file. 

The SuperFlow interactive content model provides a structured and interactive interface for viewing documentation. Each SuperFlow includes comprehensive information about a specific dataflow, workflow, or process. Depending on the focus of the SuperFlow, you will find overview information, steps that include detailed information, procedures, sample log entries, best practices, real-world scenarios, troubleshooting information, security information, animations, or other information.

Error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'xxx'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors Solution: If you happen to get the above Error while using Reporting Services, do the following to get a more detailed Error Description. Note: Option 1 and 2 works for both SQL server 2005 and 2008, but option 3 is only for SQL Server 2008 Option 1: Make changes to the ConfigurationInfo Table