< Blog

How to Insert a Report Description into a ConfigMgr Report

By Garth Jones

Oftentimes I get my best ideas for blog post topics from you! This time is no exception. In this blog post I’ll walk you through the process of how to create a report description. Before getting started, though, I’ll show you what I’m talking about.

How to Insert a Report Description into a ConfigMgr Report-Closed Description Box

In the above screenshot, notice how the description box is closed?

How to Insert a Report Description into a ConfigMgr Report-Open Description Box

Simply by clicking on the word, “Description,” I am able to reveal a short summary about this report. You probably already knew that, but now I’ll show you how to create a report description yourself!

How to Insert a Report Description into a ConfigMgr Report-Green Arrow

I’ll start by adding this feature to one of the Enhansoft reports. I’m going to add the report’s description just above the line (green arrow) within the report.

How to Insert a Report Description into a ConfigMgr Report-Table

First, after opening the report in SQL Server Data Tools (SSDT), I will move the line and the pie chart down a few spots on the report canvas. Next, I’ll drag a table to the report canvas. Notice the Header and Data rows within this new table? You will use these details in the next step.

How to Insert a Report Description into a ConfigMgr Report-Row Group

Select the Data row (as shown highlighted above) and then right-click on it. Point to Row Group and then select Delete Group.

How to Insert a Report Description into a ConfigMgr Report-Delete Group 

Select Delete group and related rows and columns and then click OK.

How to Insert a Report Description into a ConfigMgr Report-No Header Row 

Notice that the header row is now gone from the table.

How to Insert a Report Description into a ConfigMgr Report-Format Table 

There’s no trick to this part, simply format the table as you want to see it when it is expanded. In this case I made the first cell 1-inch wide and the second cell 7-inches wide. I highlighted the cell in the above screenshot to make it more visible.

How to Insert a Report Description into a ConfigMgr Report-Textbox31

Next select the description cell. This cell will be your toggle item for the full text report description cell. Make note of the name of the text box listed under the Properties window. In my case it is Textbox31.

How to Insert a Report Description into a ConfigMgr Report-Properties

Next select the full text report description cell. In the Properties box on the right, scroll down until you find the Visibility section.

How to Insert a Report Description into a ConfigMgr Report-Visibility

Change Hidden to True and InitialToggleState to True. Finally set the ToggleItem to your text box. That’s the one you located in the previous step. In my case it’s Textbox31.

How to Insert a Report Description into a ConfigMgr Report-Preview Report 

Now if you preview the report, you will see that you can click on the Description box and the report’s description will be displayed.

How to Insert a Report Description into a ConfigMgr Report-Report Description 

With that last step you are done! Sure you might want to adjust the borders, etc., but that’s essentially it.

By the way, the idea for this blog post came from two customers who use the Enhansoft reports for the, “hard stuff,” but also create their own, “easy,” reports. Remember, if you want some great reporting tips and advice check out my book, System Center Configuration Manager Reporting Unleashed!

If you have any questions, please feel free to contact me @GarthMJ.