Export (0) Print
Expand All

How to Customize the List of SQL Reporting Services Reports in the Configuration Manager Console

Applies To: System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3

When you select a SQL Reporting Services report folder in the Configuration Manager console, a list of all reports contained in that folder are displayed. You can customize this display to add or remove information columns for the displayed reports, or you can display only reports that match a filter you specify. Use the following procedures to modify the report columns displayed in the list of reports and to filter the displayed reports matching the criteria you specify.

noteNote
The information in this topic applies only to Configuration Manager 2007 R2 and Configuration Manager 2007 R3.

To add or remove columns in a list of reports

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services / <Report Server Name>, and expand the node.

  2. Click a report folder to display the list of reports.

  3. Right-click the report folder, click View, and then click Add/Remove columns.

  4. In the Add/Remove Columns dialog box, specify which columns to display in the results pane. Select the column name from the Available columns list, and click Add to add the column to the Displayed Columns list. Select the column name from the Displayed Columns list, and click Remove to remove the column from the displayed columns. Click Restore Defaults to display the default columns.

  5. Click OK to save changes and exit the Add/Remove Columns dialog box.

To use Look for to filter the display of reports

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services / <Report Server Name>, and expand the node.

  2. Click a report folder to display the list of reports.

  3. In Look for, enter any part of a text string that helps to filter or identify the reports you need, select an item from the in the column for the search criteria (a specific column or All columns), and then click Find Now. The more specific your search string is, the more specific the results will be. For example, typing the letter I in the Look for field will return any item that has the letter I in any displayed column. Typing the word Report in the Look for field and selecting Name from the in drop-down list will return any reports that contain the word Report in the Name column.

    noteNote
    The Look for facility searches only in the currently selected report folder.

  4. Click Look for to select previous searches. Up to 10 previous searches can be stored.

  5. As a visual indicator that the display is filtered, the title bar will display Filtered view, display x items out of y, where x is the number of reports that match your filter and y is the total number of unfiltered reports. Click Clear when you want to return to displaying all reports.

See Also

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft