Previous Topic
Summary Fields
A summary generates a count, average, sum, standard deviation or other transformation of a set of data values. A summary applies to a defined group of data or to the entire dataset.
Summary fields in a report can be used as the trigger object of links, and you can change their display types if you want.
Below is a list of the sections covered in this topic:
See an example: The SampleComponents catalog, included with Logi JReport Designer, contains reports that have examples of how each component type could be used in a report. For the summary field example, open <install_root>\Demo\Reports\SampleComponents\UsingSummaries.cls.
Inserting Summary Fields in a Report
Summary fields can be inserted in the report areas listed in Component Placement.
- For a business view based report
Select the aggregation in the Data panel and drag it to the destination. Create dynamic aggregations if the predefined aggregations in the specified business view cannot meet your requirement. - For a query based report
Select the summary from the Summaries node in the Data panel, then drag it to the destination. If the given summaries are not what you want, select the <Add Summary...> item to create one as required. You can also create a summary by applying aggregation on a DBField.
Notes:
- Dynamic summary fields can be inserted into the header/footer/detail panel and all group panels in both banded objects and tables. However, if you are using a static summary it can only be inserted at the group level specified.
- If you want to insert a summary field defined with a special function into a table or banded object, there must be a group with the same special function in the table or banded object.
- When you insert summary fields to a table or banded object, if the table or banded object is in another banded object and it inherits its parent's dataset, the summaries should take Up group level if they are dynamic summaries.
- If you insert a summary into the detail panel of a table or banded object, the name of the summary will automatically be inserted as a label into the corresponding header panel. Otherwise the summary and its name label will be placed in the same panel. If you do not want to insert the name label automatically, you can uncheck Insert field name label with field in the Options dialog (File > Options > Component > Insert field name label with field).
Adding Conditional Formats to Summary Fields
You can add conditional formats to summary fields in a report, then when a specified condition is fulfilled, the format defined on the condition will be applied to the field values automatically. This is very useful to highlight values that might need to be acted on by end users.
To add conditional format to a summary field, right-click it and select Conditional Formatting from the shortcut menu, then take the same procedure as described in Adding Conditional Formats to DBFields.