20 November 2014

SSRS: Report labels only IDs

The report labels do not display, or the report shows label IDs, like Labels!@SYS24426 instead of the label values:



Searching for this issue you will find the following technet solution:
http://technet.microsoft.com/en-us/library/gg731894.aspx

The SSRS Service Account password could be invalid.
  1. From the Start menu, point to All Programs, click the SQL Server folder, click the Configuration Tools folder, and then click Reporting Services Configuration Manager.
  2. In Reporting Services Configuration Manager click Connect and then click Service Account.
  3. Set the password and then click Apply. The account and password should be the same as the Microsoft Dynamics AX proxy account. For more information, see Before you install the Reporting Services extensions.
  4. Click the ServerName/MSSQLSERVER and then click Stop. Then click Start to restart the server. Always check with the SQL administrator and make sure no other users are connected to the server before you restart the server.
In my case this was not the issue. Instead it was a misconfiguration of the SSRS instance. In the RSReportServer.config there was a line missing in the <Service> element:
<service>
  ....
  <isrdceenabled>True</isrdceenabled>
</service>

After adding this part everything works fine again.

So keep in mind to also check the configuration of the SSRS installation. A missconfiguration could also lead to these label issues.

No comments: