How to Create Cascading Prompts

Prompts are extremely useful because with a prompt you can limit what is displayed within a report. You can get even more granular results when you add a second or a third prompt. Adding additional prompts, however, can lead to some minor inconveniences and unintended...

Accessing ConfigMgr Reports – Browser or Console

A long time ago, I learned while troubleshooting SQL Server Reporting Services (SSRS) reports, that your first step is always to open the report in a browser. Why? If it doesn’t work there, then there is no point in trying to access it via the console because the...

Display a Date in a Text Box

The idea for this blog post was on my list of “things to do” for quite a while. Why? Again, and again, I saw comments such as, “My date is in the wrong format,” and, “I just want the short date, I don’t need the time.” There are numerous ways to solve these problems,...

How to Query a Tesla with PowerShell

As some of you might know, I needed to replace my car, so I replaced it with a Tesla Model 3 (base model). There is a long story about why I wanted to see what information I could query from my Tesla that I’m not going to get into. What I will tell you is that while...

Adding an All Option to Your Prompt

In my blog post, Turning Three Reports into One Report, I said that I would show you how to adjust your prompt to allow for an, “All Option.” Everything you need to do is within the SQL Server queries themselves. This blog post shows you how to edit BOTH the prompt...

Why Am I Getting Incorrect Results in Visual Studio?

When I first encountered this issue, some time ago, I checked all of my queries in SQL Server Management Studio (SSMS) and guess what? As I suspected, the queries were 100% correct! I was troubled because I couldn’t figure out why, if my queries were correct, I was...