Define a Grid Report
Grid Control 2.0
Define a Grid Report
Technologies > User Interface Add-Ins > Parts for Reports > Report with Grid Panel
Report views use the same
dataSource
definition as edit form views. By default, the report will display columns
for all fields listed in the
dataSource
element, using standard Archibus field formatting and titles as defined
for each field in the data schema.
The canonical report example is shown below. Note that all panel elements must define a unique
id
attribute:
<panel type="grid" id="gridReport" dataSource="gridReportDs">
<title translatable="true">Projects</title>
<field table="project" name="project_id"/>
<field table="project" name="requestor"/>
<field table="project" name="date_commence_work"/>
<field table="project" name="date_target_end"/>
</panel>
Sort Order
The sort field is specified in the grid panel:
<panel type="grid" ...>
<sortField name="fl_id" table="rm" ascending="true"/>
<sortField name="rm_id" table="rm" ascending="true"/>
...
</panel>
One or multiple sort fields may be specified. If the sort order direction is not specified, it defaults to
ascending="true"
.
Record Limits
Report views obey the record limits that are by default specified in the
recordLimits
element in the
\WEB-INF\config\context\compatibility\afm-config
.
xml
file. Specific report views
can override the default record limits, as shown in the second example view which creates a mini-console (Smart Search console).
<panel type="grid" id="rmReport" dataSource="rmReportDs" recordLimit="20">
Custom Field Titles
To customize field titles, see Override default column and field titles .
Example view 1: http://localhost:8080/archibus/schema/ab-products/solutions/parts/grid/ab-ex-report-grid-baseline.axvw
Example view 2: http://localhost:8080/archibus/schema/ab-products/solutions/parts/grid/ab-ex-miniconsole-custom-hdr-body-ftr.axvw