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.
In the above screenshot, notice how the description box is closed?
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!
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.
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.
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.
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.
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.