Denial of Service Attack on SSRS?

SSRS 2014 limits the number of simultaneous connections from one user to prevent DDoS, and confuse me… Continue reading

Persistent Divide by Zero Error

SQL Server Reporting Services will always return a divide by zero error when using nested IIf functions in an expression even when you guard against it. Here’s a workaround… Continue reading

Reports with MultiSelect Parameters Not Working

Yesterday your reports were working, today they just display blank pages. Sometimes a security patch can break things, but they’re easily fixed… Continue reading

Fill Missing Dates without Loops

A common task Database Developers must perform is to create a query that returns data for a date range. All dates must be returned regardless of if there is data for a given date. This is a solution that is fast. Continue reading

Add a favicon to Reporting Services

Adding a favicon to your SQL Server Reporting Services 2008 R2 implementation is shockingly simple. 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