When you previewed a report in SQL Server Business Intelligence Development Studio (BIDS) after following the instructions on How-To Preview SCCM SSRS Reports in BIDS did you receive an error similar to SrsResources is Not Declared: Missing DLL? Well this article will show you how to solve this problem.
Not surprisingly, this is one of those task that a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) will need to get better at. Reporting. Which is really SQL Server Reporting Services (SSRS) or Power BI Report Server (PBRS). This is particularly true if you want to use Role Base Administrator (RBA) and reporting. RBA was introduced in ConfigMgr 2012 R2. To learn more please see Role-Based Administration (RBA) Reporting Feature in SCCM 2012 R2. In a nutshell, it allow ConfigMgr admin to control who can see want and there. This included Reporting within SSRs.
SrsResources is Not Declared: Missing DLL
An error occurred during the local report processing.
The definition of the report ‘/PC Warranty Information’ is invalid.
The Value expression for the report parameter ‘UserTokenSIDs’ contains an error: [BC30451] Name ‘SrsResources’ is not declared.
When you previewed a report in SQL Server Business Intelligence Development Studio (BIDS) after following the instructions on how to preview Role-Based Administration (RBA) reports for CM12 R2 SSRS did you receive an error similar to the one above?
The error message means that the DLL wasn’t referenced in the report and thankfully there is a simple solution to this problem. In a nutshell there are two steps:
- Make sure that you copy the SrsResources.dll to the PrivateAssemblies directory.
- Make sure that you add the DLL into the Assembly name section within the References tab for the report.
Now you should be able to preview your report in BIDS.
Finally, don’t forget that you can subscribe to my RRS feed to stay on top of the latest trips and tricks. Additionally, If you have any questions, please feel free to touch base @Garthmj.