Managing Reports › Example Ad Hoc Reports › Example: View All Open Requests that Do Not Include a Status of Work In Progress

Example: View All Open Requests that Do Not Include a Status of Work In Progress

In this example, you specify the Count reporting function to return the total number of open requests.

Example: View all open requests that do not have a status of work in progress

1. Click New, Web Intelligence Document from the menu bar.

   The New Web Intelligence Document page appears.

2. Select the CA SDM universe in the Universe column.

   The Web Intelligence document appears along with the universe information in the left pane.

   Note: To improve navigation, close the Attached Service Type folder in the left pane.

3. Locate and then expand the Request, Request Detail folders in the left pane. (Use the scroll bar to navigate folders.)
4. Select each of the following objects, then drag and drop them from the left pane to the top right pane under Results Objects.
   • Status Symbol
   • Ref Num
   • Summary
5. Select the Status Symbol object, then drag and drop it to the bottom right panel under Query Filters. Close the Request Detail folder.
6. Expand the Request Filters folder, then drag and drop the Active filter to the bottom right panel under Query Filters.
7. In the Query Filters pane, click the In list arrow on the Status Symbol object, and select the Not Equal to operator.
8. Select Work in Progress from the Operand Type menu.
9. Click Edit Report on the main toolbar.

   The Report Viewer opens.

10. In the report, select the Ref Num column. This action enables the Insert Sum command on the Reporting toolbar.
11. Click the Insert Sum command, then select Count from the menu.
12. In the report, right-click the =[Status Symbol] cell, then select Set as Section from the context menu.
13. Click Refresh Data on the main toolbar to run the report.
14. Click Save.

    The report displays the total number (count) of requests that do not have a status of Work in Progress.