How to Enable the Collection of an Email Address in ConfigMgr

This request comes up many times in the forums: How do I add an email address to reports? Before you can add the email address to a report, you need to first collect the data. In this blog post, I’ll show you how to enable the collection of an email address in...

Enabling the Interactive Sorting Feature in SSRS Reports

As promised in yesterday’s blog post, today I will show you how to enable the interactive sorting feature in a SQL Server Reporting Services (SSRS) report. The objective will be to enable the interactive sorting feature in all of the columns in the above report....

SrsResources is Not Declared: Wrong DLL

I learned a lot while converting all of Enhansoft’s reports over to Role-Based Administration (RBA). One of the issues that I ran into early on was how to preview the SSRS reports within SQL Server Business Intelligence Development Studio (BIDS).  I received help from...

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...

Test Your Role-Based Administration (RBA) Queries in SSMS

I write a lot of queries for Configuration Manager 2012 (CM12) and Configuration Manager 2007 (CM07). I also use SQL Server Management Studio (SSMS) to test all of my queries before I create SSRS reports. Now that CM12 R2 is released, I still want to test all of my...