This section contains instructions for creating a report and and an overview of basic Report Designer features. See Report Design Wizard to create a report in the using Report Designer quickly and easily.
...
The latest distribution for Report Designer is available on SourceForge at http://sourceforge.net/project/showfiles.php?group_id=140317. Download the Report Designer as part of the Pentaho Open BI Suite (pentaho_demo_hsqldb-1.6.0.GA.863.zip), if you plan to publish your reports using the BI Platform provided by Pentaho. To download the Report Designer as a standalone application, go to http://sourceforge.net/project/showfiles.php?group_id=140317&package_id=192362. To follow the instructions and tutorials included in the Report Designer documentation, you must install the Hypersonic distribution of the Sample Data (pentaho_sample_data-1.6.0.GA.863.zip).
...
After you start the report engine, a preview displays that looks like final report, but is limited to a certain number of data rows you can configure in the data source. The booting process is only done once, ; subsequent invocations of the preview are almost instantaneous. You can go Go back to the Design view by clicking Design.
...
Functions can be added through the Structure panel by selecting the Reporting Functions node. All available functions are listed in the Properties tool window with a short description in a tool tip.
You want to calculate the sum of all price items in the report so select the ItemSumFunction and click Add Function to Report.
First the function must be able to identify a field you specify for which to calculate the sum. You must also set the name of the function. This is very important, because the value of the sum is accessible through this name. Note that an error is displayed in the messages tool window until you set the name. You cannot preview a report as long as an error message displays in this tool window.
Set PRICE as the Field used to calculate the sum; use PRICE_SUM as the name of the function. Don't change the values of the Dependency Level and the Group.
Now you have to show display this value somewhere on the report. Add a Text Field to the report footer band and set the Field Name property of the Text Field to PRICE_SUM (the name of the function).
A preview of the report should look like the sample below:
The sum is printed after the last item is printed. You can adjust the report definition as needed.
...
Groups can be added in the Structure tool window by selecting the Groups node and selecting Add Group.
A group merges or groups all consecutive items with the same values in a group. Each time a new group starts, the group header band of this group is printed. Whenever a group ends, the group footer band is printed.
...