Encrypt SQL Server Connections

How to create and configure a self-signed certificate for use in testing SSL encrypted connections to SQL Server Continue reading

Matrix in a Matrix

How you can use a tablix within a tablix to create a contact list report that is clean and flexible. Continue reading

Why Won’t my Toolbar Customizations Stick in SSMS 2012?

After upgrading SQL Server Management Studio to 2012 my toolbar customizations would not stick. Argh. Turns out the fix is simple… 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

Subreport with Shared Dataset

BIDS throws an exception when you preview a report that uses subreports that uses shared datasets. 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