Ask Garth
  • Home Page
  • Books
  • Blog
  • NewsLetter
  • Which Right Click Tool are you?
  • Blame Garth
Select Page
BIDS Error – Passing Variables to Stored Procedures, Part I

BIDS Error – Passing Variables to Stored Procedures, Part I

by Garth Jones | Feb 25, 2014 | How-To, SQL Server Reporting Services

Every so often I run across BIDS Error involving passing variables to stored procedures when I’m using Business Intelligence Development Studio (BIDS). We use stored procedures for all of our SQL Server Reporting Services (SSRS) reports, so I’m more likely than most...
Enabling the Interactive Sorting Feature in SSRS Reports

Enabling the Interactive Sorting Feature in SSRS Reports

by Garth Jones | Nov 13, 2013 | ConfigMgr, How-To, SQL Server Reporting Services

As promised in yesterday’s blog post, today I will show you how to Enabling the Interactive Sorting feature in a SQL Server Reporting Services (SSRS) report. Remember that Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) reports, which is...
SrsResources is Not Declared: Wrong DLL

SrsResources is Not Declared: Wrong DLL

by Garth Jones | Oct 29, 2013 | ConfigMgr, How-To, SQL Server Reporting Services

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...
SrsResources is Not Declared: Missing DLL

SrsResources is Not Declared: Missing DLL

by Garth Jones | Oct 28, 2013 | ConfigMgr, SQL Server Reporting Services

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...
Test Your Role-Based Administration (RBA) Queries in SSMS

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

by Garth Jones | Oct 24, 2013 | ConfigMgr, How-To, SQL Server Reporting Services

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...
How-To Preview SCCM SSRS Reports in BIDS

How-To Preview SCCM SSRS Reports in BIDS

by Garth Jones | Oct 23, 2013 | ConfigMgr, How-To, SQL Server Reporting Services

Taking only 5 minutes to set-up, you can Preview SCCM SSRS Reports in SQL Server Business Intelligence Development Studio (BIDS) instead of uploading reports to the SCCM 2012 R2 SSRS site to preview and test each time. Doing this now will save you all those extra time...
« Older Entries
Next Entries »
  • Privacy Policy
  • Facebook
  • X
  • RSS
Copyright Garth Jones 2003 - 2025
Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behaviour or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}
624