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:
• 
• 
• 

In the SSRS Reporting Environment, you may never encounter this error and you live a happy and easy life. We all know an SSRS report can easily ping your server to 100% CPU if you decide to export a 120 page report, to PDF, with charts, etc. etc. You may get a complaint that performance suffers in another application while running the reports and you want to fix it, but do not know how. Then one day you or someone at your firm has decided to do your SQL Server a favor and separate out SSRS from the...

• Share This Post:
• 
• 
• 

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:
• 
• 
•