Show all
Note these additional capabilities available with report definition rules.
About the pxRetrieveReportData activity
Use the Rule-Obj-Report-Definition.pxRetrieveReportData activity to execute the retrieval and sorting operations, but not the formatting and display processing, of a report definition rule.
Parameters
Specify both key parts of a report definition rule.
Embed-QueryInputs page structure
<? xml version="1.0" ?>
<pageData>
<pxObjClass>Embed-QueryInputs </pxObjClass>
<pyListFields REPEATINGTYPE="PageList">
<rowdata REPEATINGINDEX="1">
<pxObjClass> Embed-ReportListFields </pxObjClass>
<pyFieldName>.pyLabel</pyFieldName>
<pyPrefix>PCO</pyPrefix> <pySortType>ASC</pySortType>
<pySortOrder> 1 </pySortOrder>
</rowdata>
</pyListFields>
<pyMaxRecords>Maximum no. of records to fetch</pyMaxRecords>
<pyPagingSettings>
<pxObjClass>Embed-PagingSettings</pxObjClass>
<pyPageIndex>Page Number</pyPageIndex>
<pyPageSize>Records per page</pyPageSize>
<pyPagingEnabled>True/False<pyPagingEnabled>
</pyPagingSettings>
</pagedata>
Results
The system uses rule resolution to find the report definition rule and
executes it, but does not produce any HTML output display. The selection
criteria of the report definition rule and the sorting requirements (recorded on
the Design tab) are converted to an SQL
query that is sent to the PegaRULES database.
The database results are organized into a results page of class
Code-Pega-List. The name of this page is the value you provided for the pyPageName
parameter.
Each embedded page contains the properties listed on the Design tab. If the Maximum Number of Rows to Retrieve field on the Data Access tab is not blank, the activity returns at most the
number of embedded pages specified in the Maximum Number of Rows to Retrieve
field. GATZH 3/31/2010
However, if report paging is
enabled on the User Interactions tab, only the rows for the first page are returned.GATZH 3/26/2010
Performance
This method can return thousands of database rows and create large
clipboard pages. Use care to retrieve only the rows (instances) and
columns (properties) you truly need.
Use a dedicated RuleSet for manager-created reports
Two other ways to execute reports
The pzOpenAndRunReport activity runs a report rule and displays the results in a separate window.
The <pega:chart>
JSP tag can be used to embed a chart created by a Report Definition rule in a section. GATZH changes 3/18/2010
How to display the results of a report definition in a Grid layout
You can display the results of a report definition rule in a Grid layout within a section. The section can be referenced in a flow action or harness.
To add the layout, either drag and drop a report definition from the Application Explorer onto a section, or create the layout in the section and specify the report definition as the data source in the grid's repeating area. In the Grid layout, use SmartPrompt to select Column Name values to define the grid's columns.
You can specify joins in the grid. The presentation is determined by the Grid layout settings (column widths, show/hide, sorting, and so on), not the report definition settings. Grid report rows are read-only and cannot be re-sorted. See Harness, Section, and Flow Action forms - Adding a Grid layout.pashm 7/25/10
About
Report Definition rules