Archives for category: SSRS
I ran into an interesting issue setting up SQL Reporting Services 2008 R2 using a host header, i.e. SSRS.MyCompany.com.
When I would attempt to access the SSRS Report Manager using http://ssrs.mycompany.com/reports, I would get a 401 Not Authorized Error.
I ended up having to make two registry changes in order to get it to load properly.
*** DISCLAIMER: I don’t recommend that you make any changes to your registry unless you are familiar with this tool and have a disaster plan in place to repair it in case you run into any issues. ***
Having said that, here’s what I did:
  1. Type RUN -> REGEDIT to get to the Registry Editor
  2. Traverse HKEY_LOCAL_MACHINE -> SYSTEM -> CurrentControlSet -> Control -> Lsa -> MSV1_0
  3. Right-click on MSV1_0 and choose NEW -> DWORD, call it DisableLoopbackCheck, and set its value to 1.
  1. Right-click on MSV1_0 and choose NEW -> Multi-String, call it BackConnectionHostNames, and set its value to your host header, which in my case is SSRS.MyCompany.com
Advertisements

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.