Add a favicon to Reporting Services

Adding a favicon to your SQL Server Reporting Services 2008 R2 implementation is shockingly simple. Continue reading

32-Bit ODBC Connections with 64-Bit SSIS

A few challenges encountered while creating an ETL process running in a 64-bit SSIS installation that required use of a 32-bit ODBC driver. Continue reading

Making Reports Pop with Pop-up Windows

Improving reporting performance and the user’s navigation experience using pop-up windows for your drill-through reports. Continue reading

Chart Axis Labels in SSRS – Expressions Do Not Work

The SSRS BIDS designer has a few bugs, I ran across one today and spent too much time trying to troubleshoot it. Continue reading

Report Parameter is Read-Only?

Running a parameterized report from a URL may throw a “parameter is read-only” exception. Continue reading

Report Parameter Behavior Change for SSRS 2008 R2

I looks Microsoft “Fixed the glitch” in SSRS 2008 R2. You may find report parameter behavior change after upgrading to SQL Server Reporting Services 2008 R2. Continue reading