Ask Garth
  • Home Page
  • Books
  • Blog
  • NewsLetter
  • Which Right Click Tool are you?
  • Blame Garth
Select Page
Importance of Page Sizing in SSRS Report When Designing

Importance of Page Sizing in SSRS Report When Designing

by Garth Jones | Nov 19, 2015 | ConfigMgr, How-To, SQL Server Reporting Services, Tips

I review a lot of SQL Server Reporting Services (SSRS) reports and one of the most common problems I encounter is Page Sizing in SSRS Report. What does this mean? Well in short it means when when a report is export or save, it will become all chopped up. To solve this...
Why is My Prompt in SSRS Not Working?

Why is My Prompt in SSRS Not Working?

by Garth Jones | Mar 17, 2015 | How-To, SQL Server Reporting Services, Tips

I found the oddest problem while trying to troubleshoot why an SSRS report was not working. Basically, the problem centered on a prompt in SSRS; in some cases the prompt worked and in others it didn’t. I asked myself, “What gives?” Take the following report as an...
Chrome Browser and SSRS Reports

Chrome Browser and SSRS Reports

by Garth Jones | Jun 12, 2014 | ConfigMgr, How-To, SQL Server Reporting Services

I was recently talking to a client about our Enhanced Web Reporting (EWR) SSRS reports and one of his questions was, “Does Enhanced Web Reporting work with Google Chrome?” At the time I had never tried the Chrome browser with SSRS reports, so I told him that if there...
Adding Operating System Names Into SSRS Reports

Adding Operating System Names Into SSRS Reports

by Garth Jones | May 27, 2014 | ConfigMgr, How-To, SQL Server Reporting Services

In the forums I see a lot of people asking questions about how to query for OS names. Simply taking the Operating System Names for the v_R_System SQL view in an SQL Server Reporting Services (SSRS) report will not distinguish between different OS versions such as...
Hexadecimal Values in SSRS Reports

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...
BIDS Error – Passing Variables to Stored Procedures, Part II

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...
« 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}
5249