The following options are available in the Content area for Summary reports.
Report Item Type
Contains the primary table for the selected application and any auxiliary tables for which you have privileges. Select the table that contains the information for the report.
For reports based on primary tables, the project you select when creating a report determines which items are returned in your report. The project selection also determines where the report is stored and which users can access the report. For example, if you select Project A, only users who have privileges to run reports in Project A can run the report.
For details, refer to Selecting a Report Project.
- Select Columns to Display (Groups by Unique
Select and order the fields that determine how your results will be grouped. For example, you can select the Active/Inactive field, and you will get two groups returned, one with the number of active items and one with the number of inactive items.
When you select multiple fields, groupings are created based on the combinations of fields. For example, if you selected the Active/Inactive field and the State field (which has four available states), you would have eight groupings.
Only unique values appear on the report. Sorting for your report is based on fields selected in the Data Grouping box. Sorting is done only on the first four columns. All of the returned groupings are first sorted according to the first column, and then subdivided based on the second column, and so on. If you selected the Active/Inactive field for the first column, you will have all active groupings listed first, and then the inactive groupings. Note that the order which the values display, active then inactive, are set by your administrator.Most field types are available for data grouping; however, with these exceptions:
- For Text fields, only those that are set as fixed-length fields are available.
- Folder fields are not available.
- Depending on the type of database your system is using, Multi-Group, Multi-User, and Multi-Selection fields may not be available.
- Set Custom Field Widths
By default, the width of field columns is set automatically based on the size of your browser window and the number of fields displayed on the report. You can force the column for a selected field to be larger or smaller by specifying an absolute width in pixels.
To change the display width of a field, select a field in the left pane, and then click the Set Custom Field Widths link to specify a display with in pixels for the field. You can then move the field to the right pane.
Search filters enable you to narrow your search for items. Depending on your privileges, you can define basic conditions or Advanced SQL Conditions.
|Include Items From Sub-projects
|Select this check box to include items from sub-projects of the project selected from the Report Project list. This option is not available for reports created against auxiliary tables.
|Show Search Filter In Results
|Select this option to display your Search Filter settings in the output of the report. This option allows report viewers to see which filters are used in the report. It is also helpful when you select to print a report, since it displays which Query At Runtime parameters were selected.
|Limit selections using field dependencies and project selections
Select this check box to use the project's field dependency rules.
For example, in Project A, the Priority field has a dependency with the Severity field. The dependency states that when the Severity field is Critical, then the Priority field must be 1 or 2.
You create a report on Project A and add a Search Specification of Severity in Critical. Then, you add a Search Specification for the Priority field. The available Field Values for the Priority field will be limited to 1 and 2.
Changing this setting does not affect values that have already been selected.
Restriction: Dependencies are only honored for fields that have the Allow searching option selected in the field definition.
|Use Basic Conditions
|Allow you to define a search filter by making selections from the list of fields. For detailed information about using basic conditions, refer to Using Basic Conditions in SBM Reports.
|Use Advanced SQL Conditions
(on-premise customers only)
SQL (Structured Query Language) is an industry-standard language for selecting records from a database. For detailed information about using Advanced SQL conditions in SBM reports, refer to Using Advanced SQL Conditions in SBM Reports.
The following options are available in the Additional Options area of the Summary report form. These options can be considered "advanced" report options.
- Add Columns of Calculations
You can include single-field functions (SQL aggregate functions) in Summary reports. The SQL aggregate functions available are average, maximum, minimum, and sum. For details, refer to Single-Field Functions. You can perform the following functions:
AVG (Average) – Average all values in a field.
MAX (Maximum) – Return the maximum value in a field.
MIN (Minimum) – Return the minimum values in a field.
SUM (Sum) – Return the sum of all values in a field.
For example, to determine the last time an item was submitted into a particular project, specify the following parameters in the Calculated Fields to Display section of the report form: Last Item Submitted = MAX of Submit Date/Time. When you run the report, the date and time the last item was submitted into the queried project appears in the Last Item Submitted column.
To add a single-field function to a report:
In the Column box, type the name that will appear as the Column Header in the report.
In the first calculation box, select a field that will serve as the first operator from the drop-down list.
Select an operand from the next list.
In the second calculation box, select a field that will serve as the second operator from the drop-down list.
- Include Items
Select this option to show the individual items for each grouping.
Optionally, supply a footer for your report.Note: The footer renders some common HTML tags such as <i>, <b>, and <font>. However, this means that character entity references such as >, <, ", and & are not encoded in the footer. Therefore, in order to display <Some Text> in the footer, you must send the following encoded sequence: <Some Text>.
- Optional HTML
This drop-down list contains HTML templates for customizing the look of your report. Provided templates include excellist.htm, which improves the display of Listing report results when they are exported (by right-clicking the report output and then selecting Export to Microsoft Excel), and massselectlist.htm, which provides buttons at the top of the page, enabling you to select or clear the check boxes for all items in the results list. Your administrator can customize report templates, and the templates in the list may or may not apply to the type of report you are creating. Select the template from the drop-down list.If you change the HTML template in a report that is pinned to a menu or on a dashboard in Work Center, the change is not reflected in the affected report. You must re-pin or re-add the updated report after you save the template change.Note: This option is available for applicable report types in the SBM User Workspace and for Listing reports in SBM Work Center.
Drill-Down Display Options
- Drill-Down Display Options may not be available if your administrator has disabled Flash components or in browsers that do not support HTML5.
- You cannot drill down into a report when it is contained in a Drill Through report and used to drive another report. See Drill Through Reports for more information.
|Use Value Display Format
|Select this check box to use the default columns for the drill-down report. Clear the check box to enable the Select Columns to Display feature.
|Select Columns to Display
|Select the fields that you want to appear as columns in the drill-down reports. To select or deselect a field, move it to or from the right-hand box using the arrow buttons.
|Set Custom Field Widths
|Optionally, specify the width (in pixels) for the columns in the drill-down reports.
|Select the fields on which you want to sort the data in the drill-down reports.
The Summary report displays groups of items that share the same values in the fields that you selected to display. The groups can also be collapsed at the different rollup levels following the order of the fields. The field order depends on how they were selected, with any calculated fields showing up to the far right.
The Number of Items column provides a link that opens a Listing report of the items in that grouping. This list shows the number of items that fit the criteria across the selected fields. If you selected to display the items from a rollup level, it will include all of the items that meet the selection criteria for that rollup level.
For example, if your report contains a count of items in each project submitted by a specific set of users, each count of items owned by a user appears as a link. Click the Number of Items value to display a Listing report of those items. Also, you click the value on the project level to show all items in that project submitted by the set of users. To return to the original report after viewing the Listing report, click the Back to Results link.
You can expand and collapse the rollup level groupings by selecting the icons on the left.
|Show rows with at least
|Move the slider to filter the results for groups having equal or more items.
|Show rollup levels
|Move the slider to hide or display rollup levels. As you move to the right, each new layer of rollup levels is displayed. Moving the slider completely to the right displays all roll up levels. The rollup levels displayed appear above the slider.
|Show repeating values
|Select this option to display duplicate values at the rollup levels and at the low levels. If not selected, only the first occurrence of a value will appear.
|Select this option to display the individual items in the report. This option is only available if Include Items is enabled under Additional options in the report definition.