Tag Archives: Report

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

Show an application in the Programs list of Windows 7

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.

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

Create a new Data Source in SQL Reporting Services

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!)

Continue Reading