Maintaining hundreds of reports in SQL Server Reporting Services (SSRS) can be daunting!

Centralizing items such as background colors, font colors, and logos can make a big difference. Let us demonstrate how to create a custom SQL table to hold these kinds of formatting items, and how to reference them in your SSRS reports. Making a change in the table will then automatically transfer to all reports using that stylized formatting. Imagine how pleased you will be when your hospital changes its name, logo, address, or favorite colors, and you can simply update hundreds of reports with a few dictionary edits instead of opening and modifying each one.

We will also cover tips and tricks in SSRS to WOW your end users and improve report readability — including but not limited to repeating column headers on each page, expression placeholders, html font formatting in text boxes, and dynamic date range parameters.