Data-pull query creation for simple charts
BIRT Reports include palette components that support charting. The configuration of chart
components is simplified when the result set includes numeric data. The HCL Compass Client now supports enabling the
Count
aggregate function.
In the display-field editor, the (Count) field
is listed as the first display field. If you include the (Count) field
when you design a query, the generated query includes a Count
(dbid) aggregate. See the CountBy State-Severity-Priority.qry included
with the report samples for an example.
Note: If you create a query
with (Count) as a display field, the result
set does not return individual records. The result set is a count
of all rows that match the settings of the provided display fields,
and attempting to open an individual record from the result set causes
an error.