NoPublic, bureaucrat, administrator
4,913
edits
Changes
no edit summary
}}
==Summarizing Report Data==__NOEDITSECTION__
In addition to displaying report details in an iReport template, the iReport Designer allows you create summaries or calculations of data returned in the report. These can take the form of totals, sums, and counts (stored in Variables), or more complicated data summaries such as Crosstabs or Charts. Because summarizing data necessarily depends on multiple records, data summaries must exist in bands ''after'' the Detail band such as the Summary band, Footer bad, or Group Footer bands.
===Adding a Footer or Summary Section to the Report===__NOEDITSECTION__
Totals, averages, and other summary data are typically found at the end of a grouping or at the end of a report. If a desired band is not visible on the iReport Designer canvas:
# Select the desired band in the '''Report Inspector'''
# In the '''Properties''' pane, change the '''Band Height''' property to something more than 0 (e.g. 50).
===Displaying Counts===__NOEDITSECTION__
iReport has a built-in variable for calculating the number of records in a report and the number of records in each group if the report contains groups. The number of records in the report is stored in the REPORT_COUNT variable. The number of records in each group is stored in the <''GroupField''>_COUNT where GroupField is the name of the field on which the group is created.
{{note|It may be helpful to add a text label beside any counts that you add to report to identify the value. To add a text label, click the [[Image:iRepText.png]] icon. }}
===Displaying Totals===__NOEDITSECTION__
iReport allows you to display the total of a particular attribute in the report. This is done by creating a variable to store the total value (see [[Modify an iReport Template#Adding a Variable to an iReport Template| Adding a Variable to an iReport]]).
|}
==Crosstabs==__NOEDITSECTION__
In addition to summary variables, iReport provides the capability to build crosstab tables that display data in a grid for easy analysis and summary. Crosstabs allow you to choose data rows, columns, and the variable to measured and then automatically produce a grid of results for display in a chart. As with other summary variables Crosstabs are generally used in the '''Summary Band''' in a report.
The report can now be run or additional adjustments to the report can be made including resizing columns and rows, number formatting, or display adjustments.
==Charts==__NOEDITSECTION__
Charts provide a visual representation of the report data. Before you add a chart to your report, you should ensure that your report contains the following:
