SSRS

Category to include all posts related to SQL Server Reporting Services

Exporting SSRS Report with Excel Formulas Preserved

Ahh Microsoft Excel, the key tool of every financial analyst across the world. Where would we be without you? What application would receive all of the notoriety for analysts mistakenly leaving in sensitive data in a hidden column? How would an analyst store tons of data that is a pain to mine? As part of our conversion of some of our legacy Excel "systems" we have had to still produce Excel Reports. These reports have the strict requirement that when they are exported to Excel, they should still...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Steps to Resolve SSRS Timeout Issues

Been awhile since I had posted anything and what better way to restart this blog than with some Timeout Issues. Now this list is designed for SSRS 2005, but you can put a few of these tips to use in 2008. Consider these steps in the below order. 1) Set the HttpRuntime ExecutionTimeout value to a greater value (ie 3 hours) on the Report Server How do you do this? Simple! a. Open the ReportServer’s Web.config file by going to Start -> Administrative Tools -> Internet Information Services. b....
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati

Handling Multi-Value Parameter with a Stored Procedure

In my experience with SSRS, I have noticed that there are two types of report developers: 1) SQL Developer that naturally flowed into SSRS, uses Stored Procedures for database development and has a very solid background for development. 2) Developers from other categories that somehow fell into SSRS. I come from the second school but I have an endless desire for learning about technology and have been fortunate enough to work with some really intelligent developers. Which brings me to one of the...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati