I love using SQL Reporting Services because of all of the built-in report capabilities such as paging and viewing the report in a variety of formats like PDF and Excel. The one thing I haven’t liked is the fact that I have so much more flexibility when I build reports using .NET. I can get creative with my HTML format and layout.
I have discovered a nice trick in SSRS. You can configure your expressions to render using HTML formatting. This allows you to add HTML tags directly in your expressions, such as line breaks and bolding.
In this example I have several address-related fields and am using an expression to build the address. My expression looks like this:
With the default configuration, my expression renders the HTML tags as text:
To modify the rendering property of your expression, first select the expression, and then right-click with your mouse and select “Placeholder Properties…”.
Under Markup Type, select “HTML – Interpret HTML tags as styles”.
The same expression will now render like this:
The same concept applies for adding bold, italics, underlines, hyperlinks, etc.