Report Wizard - Summary

Report Wizard allows you to quickly create a basic design of the report.  JReport prompts you to define what tables, fields, summaries, and other options are used in a very rough report design.  In this way Report Wizard saves your time in the basic organization and layout of data from the database.

The Summary tab in Report Wizard allows you to generate a count, average, sum, standard deviation and other features for your data.  The Summary functions are based upon how you grouped your data from the Group tab.


How to generate a summary
The Working Set contains the fields you selected in the Data tab.  Select a field you want to be summarized.  Next, select a Function you would like to use to generate a value for your data.  Click here for a definition of what each function does.

What is a Break Field?
A Break Field is how JReport separates and groups the fields for a specific field and function. 

For example, let say we wanted a Sum of a field, called annual sales, in a region and city.  If we choose region in Break Field, JReport will generate a total sum of the sales in the region.  If we chose city in the Break Field, we would get the total sum of the sales in a city.   
    

What is Grand Total?
Grand Total is the over all value for a specific field and function in a report.  It is shown at the end in the Report Footer.

For example, if we had a total 20 fields in our report, JReport would calculated the total value of all 20 fields at the end of the Report Footer.