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

How Do You Add the Total Number of Computers in a SSRS Table?

Today, I’m going to show you how to add the total number of computers in a SSRS table. This is a slightly different take on what my colleague Leonard showed you in last week’s post, How to Add the Total Number of Rows in a SSRS Table. Before starting, I must tell you...

How to Deploy SSRS Reports from Visual Studio to the SSRS Server

Normally, I work on SQL Server Reporting Services (SSRS) reports in Visual Studio until they are done, so I don’t need to deploy SSRS reports directly to the SSRS server. I say, “normally,” because recently I ran into an issue which meant enabling the publishing...

How to Add Repeating Header Rows Within a SSRS Matrix

I am working a lot with matrices these days for a new SQL Server Reporting Services (SSRS) report in Enhansoft Reporting. The more I use a matrix the more things I discover that are different between matrices and tables, so here I will show you how to add repeating...

How to Enable Interactive Sorting in a SSRS Matrix

Interactive sorting is one of my favorite features and I think it is under-used. I add it to all of my reports, but the other day I made a discovery. Enabling interactive sorting in a SSRS matrix is a bit different from the steps you would take in a SSRS table. In...

Finishing Touches: Adding a Row Count to Your Report

Over the last six months or so, I published a number of blog posts about many different types of finishing touches you can add to your reports and this post is no exception. Have you ever looked at a report, especially one with multiple pages, and wondered, “How many...