Display totals and counts in paginated reports
Display totals and counts in paginated reports
Technologies > Business Process Owner Views > Paginated Reports > Report with Totals
You can display the total count of records in a report. The total count includes all records that meet the report restriction, not only the records on the current page.
You can also display totals for any numeric field. You can enable or disable the totals for each numeric field separately.
You can only display totals if the report uses a non-grouping data source. For grouping data sources, Use summary fields in a paginated report
showTotals . To display totals for a numeric field, add the showTotals="true" attribute to the <field /> tag in the data source. If the field is defined in both the data source and the report panel, add the showTotals attribute in both places.
showCounts . To display the count of records, add the showCounts="true" attribute to the report panel.
<view version="2.0">
<report />
<title>Rooms</title>
<dataSource id="reportTotals_rooms_ds">
<table name="rm"/>
<field name="bl_id"/>
<field name="fl_id"/>
<field name="rm_id"/>
<field name="area" showTotals="true" />
<field name="count_em" showTotals="true" />
</dataSource>
<panel id="reportTotals_rooms_panel" type="paginatedReport" format="table"
role="data" dataSource="reportTotals_rooms_ds"
showCounts="true">
<title>Buildings</title>
</panel>
</view>