Scarab allows you to build reports to provide snapshot status reviews of issue activity. You can tailor the reports to fit your specific needs by defining which data types are included and selecting the output format. The report data types can include attributes and options, users, and dates. The report can be formatted for the web browser, Excel (.xls), or as a tab separated list (.txt). You can define reports to include a single or multiple issue types in a single or multiple modules.
To access Scarab reports:
The Scarab report build consists of three tabs: Report information, Row content, Column content.
The Report information tab allows you to define the scope of the report and enter summary information. The summary information is for saving reports. There are two sections on this tab: Artifact types selected for this report, and Summary.
Selecting issue types
The issue type included in the report defaults to the currently selected issue type. If you wish to define a report for a different or multiple issue types/modules, click the Edit list button. This will take you to the Cross module/issue type list page. You can use this page to define a list of issues types within the current module or across multiple modules to be included in your report. It is highly recommended that the issue types for the report be chosen prior to working with the content tabs. Though it is possible to modify the list later, additions that conflict with already entered data on the other tabs will not be allowed.
On the Cross module/issue type list page, you can perform the following tasks:
Entering Summary information
The Summary section of the Report information tab allows you to enter information for saving your report. This information is optional and can be added at any point report creation process. You can provide the following information:
When you have entered all of the desired information, click the Update button to add this information to your report.
The Row content and Column content tabs allow you to define and organize the data included in your report. These tabs contain identical information and options; however, you can select different data types on each tab. This allows you to create unique, in depth reports. Once both the row and column content have been defined, you can generate the report.
The Row/Column criteria section allows you to select the type of data presented in the rows or columns of your report. The available selections are:
The option selected in the Select content type field determines the data available in the rest of the sections of these tabs. Only one content type can be used for each heading. If you choose Date(s) as a content type on either the Row content or Column content tab, it must be the only heading on that axis. However, you can define user criteria for one or more heading levels and option attributes for other headings on the same axis. Changing the content type to Date(s) after defining a set of user or attribute/option criteria for either the row or column content tabs will discard the previously entered data for that tab.
When generating reports containing attribute options and user attributes, the organization of the data can mean the difference between a useful analysis tool and an unreadable mass of numbers. To help you organize your data, Scarab allows you to arrange report data into headings which are combined in the final report to allow multiple criteria per cell.
Headings are defined solely by the data they contain. To create headings within your report:
You can edit a previously defined heading by clicking on the radio button next to the heading and clicking the Edit selected heading button. You can delete previously defined heading by clicking on the radio button next to the heading and clicking the Remove selected heading button.
Scarab allows you to further organize reports data by grouping the attributes and options within your headings. For example, if options P1, P2, P3, and P4 for the Priority attribute have all been selected, you could group P1 and P2 as "high priority" and P3 and P4 as "low priority".
You must have defined at least one heading containing Attribute/option(s) in your report before you can define groups. To group options within headings:
Reporting on user attributes allows you to determine how the workload in your module is distributed. You can use the Users (by attribute) data type to create reports that indicate how issues are assigned or otherwise associated with users.
To define Users (by attribute) reporting criteria:
To include multiple user attributes for a single user, you must add the user again with the additional attribute selected. For instance, if you wanted to generate a report to indicate which users have ownership and quality assurance responsibility for the issues in your module, you would need to select each user twice--first with the Assigned to user attribute, then with the QA contact user attribute.
To help you determine how your module is progressing, Scarab allows you generate reports based on dates/times. Date/time reports provide a snapshot of issue activity at a single point in time. You can design reports to include several date/times to show the progress over a specific period of time.
To create date/time reports:
You can include future dates in your report. A row or column with a future date will appear blank in the generated report; however, the row or column will populate when the report is regenerated after the date has passed. This can be used to create progress reports which are generated repeatedly. By adding dates well into the future and saving the report, you can minimize the amount of time spent defining frequently generated reports.
Once you have defined both row and column content, the Generate report button will appear. Clicking this button will create the report in the format you have selected on the Report information tab.
When viewing the report in the Web format, you can perform the following tasks: