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