Tag Archives: Report Builder

Hide Duplicate Values in SQL Report Builder (SRSS)

Purpose: When you create bloated SQL queries, you might need to shape them further.

You understand your query, but there just seem to be so many things that must be taken into account. You know that they will not alter the context of your report in a way that could lead to missing information. Therefore you have decided to stop working on the bloated SQL query and use the Report Builder as a tool to shape the query as you see fit.

Continue Reading

Create Conditional Formatting in Report Builder

Purpose: When you create long reports, this makes them easier to read

When you are receiving hundreds or thousands rows of data – your report quickly becomes hard to read. If you are unfortunate and need to read the data yourself, help yourself out with a basic trick. Create a conditional formatting for your report. SQL Report Builder’s conditional formatting is a nice additional touch to your reports and it just might make the report readable for someone else too.

Continue Reading

Report with a Selectable Collection Parameter (SQL)

Purpose: Create a Report that allows a user to select the limiting Collection from a drop down list

When you are creating more complex reports with the Report Builder, you will begin to use different kind of parameters with queried values. One of the most common SCCM parameter is the Collection parameter. This guide is valid when you need create your report and let a user to limit it to a single collection.

Continue Reading

Using the SQL Server Report Builder on an External Workstation (Export/Import Certificate)

Purpose: Requirements to correctly use SQL Server Report Builder on an external workstation

Should you need to use the SQL Server Report Builder from an external workstation (not directly from the SQL Server where the Report Service Point is installed), you will need to add the SQL server certificate to the external workstation. This will allow the external workstation to function properly with all of the Report Builder actions.

Continue Reading