About Garth Jones

Hexadecimal Values in SSRS Reports

by Garth Jones | Mar 13, 2014 | How-To, SQL Server Reporting Services

I ran across this error when I tried passing a hexadecimal values (0x1) from one SSRS report to another SSRS report. And this was seriously frustrating as we all “know” the 0x01 is hex for 1. So why doesn’t SQL Server Report Services (SSRS) see that...

Problem Steps Recorder (PSR) Stored Screen Captures

by Garth Jones | Mar 5, 2014 | How-To

The other day I was working with a client to help them setup their System Center 2012 Configuration Manager (CM12) server. As part of the project we wanted to document every step we did, so we used PSR.exe (Problem Steps Recorder). We installed SQL and set the...

BIDS Error – Passing Variables to Stored Procedures, Part II

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

Additionally, as promised in yesterday’s blog post, here are a couple more SQL Server Business Intelligence Development Studio (BIDS) error messages that I come across from time-to-time with quick ways to fix them. As a Microsoft Endpoint Configuration Manager (MEMCM...

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

BIDS Error

by Garth Jones | Jan 29, 2014 | How-To

As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM ) admin, I create a lot of report. As you know SCCM user SQL Server Reporting Services (SSRS) for it’s reporting. In order to create custom reports for SCCM. I use Business Intelligence...