Interactive Reporting provides a computable field and predefined fields to assist you constructing and producing reports (see Table 104, Report Section Fields ). You can drag and drop these fields anywhere within the report page, body, report group header, report header/footer, and page header and footer. You can also customize how numbers, dates, time, and text fonts are displayed in your report. For numbers, you can use commas, decimals place, dollar signs or percentage symbols. For text items, you can select fonts styles and sizes. For Query and Result filters, you can select specific filters.
Table 104. Report Section Fields
Field Name | Description |
|---|
Field | Inserts a computed field. |
Query Filter | Inserts a selected query filter. |
Result Filter | Inserts a selected result filter. |
Query SQL | Inserts the last SQL sent to the database when you process a query. |
Page Number | Inserts a page number. |
Number of Pages | Inserts the total number of pages. |
Page X of Y | Note: All column data types default to string unless they are manually changed. Note the following behavior of this field when the section is deployed in EPM Workspace: If you intend to use this field in a report deployed in EPM Workspace, any Report section which is more than one page shows as 'Page 1 of y'. It continues to show the pages as such (with an unknown 'y' value) until the end user navigates to the last page of the section. If an end user navigates to the last page using the “SHIFT+toolbar button" combination, all pages are generated and the page # toolbar icon tool tip shows the correct page position and total page value. Subsequent navigation continue to show correctly the current and total page numbers. These values persist for the entire user session. If the Report sections has fields in the section which show 'Page x of y', the fields match the page # toolbar icon tool tip. All pages are generated if the Report section is exported to XLS or PDF formats. If the Interactive Reporting document is saved without Results which the Report section references, processing the Interactive Reporting document causes a generation of the first page only.
|
Last Saved | Inserts date on which the report was last saved in MM/DD/YYYY format. |
Last Printed | Inserts date on which the report was last printed in MM/DD/YYYY format. |
Date | Inserts and stamps the current date in MM/DD/YYYY format. |
Time | Inserts and stamps current time in HH:MM:SS format. |
Date & Time | Inserts and stamps date and time in MM/DDYYYY and HH:MM:SS format. |
Date Now | Inserts the current date in MM/DD/YYYY format. |
Time Now | Inserts the current time in HH:MM:SS format. |
Date & Time Now | Inserts the current date and time in MM/DDYYYY and HH:MM:SS format. |
File Name | Inserts an Interactive Reporting document (BQY) name. |
Path Name | Inserts the full path name of the document. |
Report Name | Inserts the report name. |
Working with Computed Fields
A computed field contain a single value based on a calculation. You can create customized JavaScript expressions or modify JavaScript syntax for an existing report element. A computed field is repeated based on the report component in which it is inserted.
To create a computed field:
Select Report, then Insert Field.
The cursor changes to a crosshair.
Left-click and hold your left mouse button to position your cursor in the report component where you want to insert the field, and then drag to create the table.
A field labeled Empty Field is inserted.
Click the empty field to select it, and then enter JavaScript syntax in the Expression line.
You can copy and paste JavaScript syntax from existing report items into the Expression line to build the expression. To do this, select an existing item and copy the syntax in the Expression line. Then select the new field and paste the syntax into the Expression line.
When you have defined the equation, click the check icon.
The field displays the computed value.
A computed field repeats itself based on the band, header, or footer in which you insert it as shown below:
You can select and show filters applied in the Query and Results sections to aid in the visual construction and production of the report.
To use a filter value in a report:
Select Report, then Insert Predefined Field, then Query Filter or optionally select Result Filter.
The cursor changes to a crosshair.
Left-click and hold your left mouse button to position your cursor in the report component where you want to insert the filter field, and then drag to create the field.
The Insert Filter Values dialog box is displayed.
In the Query or Result Sections list, select the section that contains the filters that you want to show.
A list of applied filters populates the Filter Names list.
Select the Filter Name that you want to use from the Filter Names list.
To show the operator used in the expression, select the Include Filter Operator check box.
Click OK.