Changing ConfigMgr Report Account Password, How do I do it?

Changing ConfigMgr Report Account Password, How do I do it?

This comes of fairly often within Reddit or other forums, Changing ConfigMgr Report Account Password, How do I do it? What people do is change the account password within Active Directory (AD). Then they change the dataset password and everything works great for 10...
Why are my SSRS Chart Sorting Z-A?

Why are my SSRS Chart Sorting Z-A?

As I write this blog, I’m working on a chart that has labels on it. I almost never add chart labels, instead I used an attached table with matching colors to show which values matches which line within the chart. But for this chart, it made sense to add labels to it....
Dude, Where Are My Prompts?

Dude, Where Are My Prompts?

In this blog post, I’m going to show you two tips involving prompts. I will start with the problem, “Where are my prompts?” And, then I’ll show you a trick that I love. Both tips are really the same thing, but let’s talk first about the problem in the title of this...
How to Enable Remote Errors

How to Enable Remote Errors

When you work a lot on reports in either Power BI Report Server (PBRS) or SQL Server Reporting Services (SSRS), at some point you are bound to get errors that basically say: go to the server to see the real error OR enable remote errors. It’s not a big deal to go to...
How to Create Cascading Prompts

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

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. Why because the...