Tips & Tricks
Chrome Browser and SSRS Reports
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
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
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 0x1 as a integer...
Problem Steps Recorder (PSR) Stored Screen Captures
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
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
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...
Accessing MECM Data and Who Should Have Access to It.
This is one of the blogs that I saved from the Blog Clean Up! I’m sure people are asking why save, fix up and republish a blog from March 2007 about SMS 2003? The funny thing is that Rod said back then is still true today! Accessing MECM Data and Who Should Have...
Accessing MECM Data and Who Should Have Access to It.
This is one of the blogs that I saved from the Blog Clean Up! I’m sure people are asking why save, fix up and republish a blog from March 2007 about SMS 2003? The funny thing is that Rod said back then is still true today! Accessing MECM Data and Who Should Have...
How to Create a Power BI Date Range Slicer
Hi Everyone! This blog post is about how to create and use a date range slicer. I am also going to tell you about the different date range slicer options and each one’s purpose, but first let me share with you why I wrote this post. Earlier this year, I created a date...
How to Create a Date Prompt in SSRS
There is a long story behind why I needed to create a date prompt, but the short story involves some feedback from a customer. The customer wanted to see how often computers check their warranty status with Enhansoft’s Warranty Status API. Now, this blog post is not...