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: List your custom application or configuration in Windows 7 (x64) Programs list
If you need to list your custom application or a setting in the Windows 7 operating system Programs list (Control Panel -> Programs), you need to add a registry key to the local machine registry. However, there is a catch. You need to add two registry values inside the key for it to appear in the Programs list. There are many more available for additional information, but two is required. This could be used if you are gathering the Programs list for a SCCM report and want that something you are deploying will be shown in this report as well.
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: Create a Central SQL Report Data Source (else you need one in every custom report)
Once you take upon the quest of creating reports using SQL Reporting Services, you will soon notice that you are doing the same task in every report that you create. Therefore you should create a centralized data source that your reports will be using. This will save you time and nerves (so you can create even more reports, yey!)