Creating a Job Activity crosstab report with filters

The following example demonstrates how to create a Job Activity crosstab report that lists the number of job runs for different job types on target operating systems.

To create a crosstab report

1. Launch Report Studio from the BMC Decision Support for Server Automation portal.
2. Select a package (for example, BladeLogic) from the list of available packages.
3. In the Welcome window, click Create a new report or template.
4. Select the Crosstab report type and click OK.
5. If the Insertable Objects pane does not display the domain folders, right-click in the pane and select Refresh. The following figure shows the Crosstab report template:
   
6. In the Insertable Objects pane, open the Job Activity folder, and expand the folders to locate, select, and drag data items into the report as follows. Use the following figure as a reference.
   • Drag Job Runs/Server/Server Name to the Rows section.
   • Drag Job/Job Type to the Columns section.
   • Drag Job Run Date/Month Full Name to the Columns section, above the Job Type section.
   • Drag Job Run Date/Year to the Columns section, above the Month Full Name section.
   • Drag Job Activity Calculations/# Servers Attempted to the Measures cell.
     
7. Add filters to the report for the Year and Month Full Namedata items. When you run the report, you are prompted for the year and month for which you want to create a report.
   1. On the toolbar, click Filters to open the Filters dialog box.
   2. Click the Add button to open the Detail Filter Expression dialog box.
   3. Drag the Job Activity/Job Run Date/Year query item to Expression Definition.
   4. Add the following expression: =?promptYear?
   5. Click OK.
   6. Click the Add button to open the Detail Filter Expression dialog box.
   7. Drag the Job Activity/Job Run Date/Month Full Name data item to Expression Definition.
   8. Add the following expression: =?promptMonth?
   9. Click OK.
      The Filters dialog box shows expression definitions, as shown in the following figure:
      
8. Change the title of the report as required.
9. To run the report, click Run Report on the toolbar.
10. Save the report.
    The following figure shows a sample report, which is created by using the preceding steps:
    

Related topic

Creating reports with Report Studio