Use summary fields in a paginated report
Use summary fields in a paginated report
Technologies > Business Process Owner Views > Paginated Reports > Report with Summary Parent Group Band
Technologies > Business Process Owner Views > Paginated Reports > Report with Two Summary Parent Group Bands
This parent data band's grouping data source contains a summary field. The data is grouped according to room standard and the total room standard area is given for each grouping:
<dataSource id="ds_abExRmxrmstdSumRpt_owner" type="grouping">
<table name="rmstd" role="main" />
<field table="rmstd" name="rm_std" groupBy="true" />
<field name="sum_std_area" formula="sum"
baseField="rmstd.std_area" dataType="number" decimals="0">
</field>
</dataSource>
File:
schema/ab-products/solutions/parts/pagereports/ab-ex-rmxrmstd-sum-rpt.axvw
By placing the summary value in a parent data band, the example above puts the totals for each group of data conveniently at the top of the data. If you make the first parent data group a summary group, the view will also generate an overall total for all data in the report.
Summary values may also be used in the child data band, as the same example demonstrates. This child data band gives the room count and total room area for each grouping:
<dataSource type="grouping" id="ds_abExRmxrmstdSumRpt_data">
...
<field name="count_area" formula="count" baseField="rm.area"
dataType="number" decimals="0">
<title translatable="true">Count</title>
</field>
<field name="sum_area" formula="sum" baseField="rm.area"
dataType="number" decimals="0">
<title translatable="true">Total Room Area</title>
</field>
For a non-grouping data source, Display totals and counts in paginated reports
Load report: http://localhost:8080/archibus/pagereports/ab-ex-rmxrmstd-sum-rpt.axvw
Load report : http://localhost:8080/archibus/pagereports/ab-ex-rmxdpxdv-sum-rpt.axvw