Changes

==Summarizing Summarising Report Data==__NOEDITSECTION__In addition to displaying report details in an iReport template, the iReport Designer allows you create creating summaries or calculations of data returned in the report. These can take the form of totals, sums, and counts (stored in Variablesvariables), or more complicated data summaries such as Crosstabs crosstabs or Chartscharts. Because summarizing data necessarily depends on multiple records, data summaries must exist in bands ''after'' the Detail band such as the Summary band, Footer badband, or Group Footer bands.

[[Image:iRep22.png|center|500px|''Figure 22. REPORT_COUNT element in summary section'']]

''Figure 22. REPORT_COUNT element in summary section''

{{note|It may be helpful to add a text label beside any counts that you add to the report to identify the value. To add a text label, drag the static text field element [[Image:iRepText.png]] from the '''Palette''' pane. }}

# Follow the steps to [[Modify an iReport Template#Adding a Variable to an iReport Template| add a variable to an iReport]].

| align="center" colspan="2" | '''Table 5. Reset Types'''

==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 be 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.

# Finalize Finalise the Crosstab display.

==Charts==__NOEDITSECTION__

#Create a report which groups the results by the attribute on which you would like to base your chart (e.g. ''status'').

# To select the '''unique value''' choose the '''Expression editor''' button and '''choose the ''field'' the report is grouped by''' (e.g. ''status''). Note that charts in iReport will fail if the '''unique value''' is null. In order to account for null values, you will need to modify the expression so that null values are grouped into their own group. The expression should be modified to include the bolded text below. You should replace attribute with the name of the attribute that you selected in step b above.

#Next, select the '''numeric value''' that contains the desired numeric data for the chart. '''Note: This should always be the variable created in step 3 above''' (e.g. ''SUM_status_byAreaSizeSUM_areaSize_byStatus'').

====Modify a Pie Chart====__NOEDITSECTION__To modify Once a pie charthas been created in iReport Designer, its properties can be edited by selecting the '''Chart Data''' option on the right click menu and adjusting the values and properties.

To modify a chart:# Right click on the chart in iReport Designer and select '''Chart Data''' from the menu.# The Chart details window displays.#: [[Image:IReport ChartData1.png|center|500px|''Chart Data Properties'']]<div align="center">''Chart Data Properties''</div># To edit the main properties of the chart, select the '''Details tab'''. Additionally, this screen can be used to edit the reset type of the chart which is relevant if the chart is displayed on a band other than the summary band.# The '''Chart Details''' window displays.#: [[Image:IReport ChartData2.png|center|500px|''Chart Data Properties'']]<div align==Bar Charts==="center">''Chart Data Properties''</div># In this window, the basic properties of the chart that were established in the Chart Wizard can be edited. These include:#* '''Key Expression''': the field used to group data for charting purposes. To change the field, simply select another field. '''Note:''' The field must be used in the creation of the variable used in the value expression or the results will be incorrect.#* '''Value Expression''': the variable used to store the data to be displayed in the chart. If changes are made this value it is recommended to edit the variable properties as well.#* '''Label Expression''': the area used to define the labels for the chart. Any valid expression can be used here. See [[Summarize iReport Template Data#Variable Expressions|Variable Expressions]] for more details.

[[Image:iRep30===Bar Charts===__NOEDITSECTION__Bar charts, unlike Pie Charts, have a third variable option that can be included in the report.png|center|500px|In addition to the category and value expressions, bar charts add the option of a ''''Figure 30. Bar chart –Single attribute y-axis'series']]<div align="center">''Figure 30. Bar chart –Single attribute y-axis''</div>. The series choice adds an additional possibility of grouping data though is not required.

<ol>====Add a Bar Chart====__NOEDITSECTION__*If you would like To add a bar chart to the horizontal axis of report:#Create a report which groups the bar chart to reflect results by the values of an additional attribute, the Series Expression on which you would be the expression for the secondary level of detail. In the example shown below, the x-axis reflects the land priorities like to base your chart (e.g., Low, Medium, or High''status''). In addition to displaying #Ensure that the priority, Summary Band is available on the bars of iReport template canvas.#[[Modify_an_iReport_Template#Adding a Variable to an iReport Template|Create a Variable]] to contain the chart use a different colour values to reflect those land which block water access be displayed in the chart (red) vse.g. those that do not block the water (blue''SUM_areaSize_byStatus''). </ol> [[Image:iRep31This variable should be based on a numeric field (e.g.png|center|500px|''Figure 31. Bar chart with different series expressionareaSize'') and should have the ''']]<div align="center">Reset type''Figure 31. Bar ' set to '''Group''' and the group selected set to the field you wish to create the chart with different series expressionfrom''(e.g. ''status'').</div> <ol>The #Select the '''Chart Properties window for this bar chart is shown below. Notice that ''' option from the series expression '''Palette''' pane and category expression differ.</ol> [[Image:iRep32.png|center|500px|drag it to the '''Summary Band'Figure 32. Chart Properties – Different series and category expressions'']]<div align="center">of the report template to start the '''Figure 32. Chart Properties – Different series and category expressionsWizard'''.</div> <ol>*If you selected one of the stacked #Select one of the bar chart options, the series expression will be used to determine the segments of each bar. In the following figure, the series expression creates red and blue segments in each bar to indicate whether or not water access is blocked.</ol>  #:[[Image:iRep33IReport BarChart.png|center|500px|''Figure 33. Stacked bar chartChart options'']]<div align="center">''Figure 33. Stacked bar chartChart options''</div>#Choose Main report dataset.<ol start="14"><li#:[[Image:IReport BarChart_Step1.png|center|500px|''Chart options'']]<div align="center">The Category Expression is the major grouping of the horizontal axis. To enter the category expression:''Chart options''</lidiv><ol type="# Provide a"><li>Click the '''Series Expression''' (''optional''). #:[[Image:iRepEditoriReport Chart Bar1.png|center|500px|''Series Expression'']] icon that is displayed beside the Category expression field.<div align="center">''Series Expression''</lidiv>:# The Series Expression editor window displaysallows you to define an added level of detail to your bar chart (if desired).<li>From To select the bottom pane, double-click '''Series''' choose the name '''Expression editor''' button and '''choose one of the attribute that contains ''fields'' the data that you would like to include report is grouped by''' (e.g. ''status''). Note that charts in iReport will fail if the chart'''Series''' value is null.</li>:The expression to represent the attribute displays in the top pane.<li>In order to account for null values, you will need to modify the expression so that null values are grouped into their own group. The expression should be modified to include the bolded text below. You should replace attribute with the field the name of the attribute field that you selected in step b above.</li>#: '''$F{''attribute''status} '''!== null ? $F{attribute} : "UnknownN/A": $F{status}'''<li>Click the #:[[Image:iReport Charts5.png|center|500px|''Set Series Value'Apply']]<div align="center">''Set Series Value'' button.</lidiv></ol><li>#: The '''Value Expression''' field contains the expression that returns you enter in the numeric value for Series Expression field will vary based on how you want the key.</li>horizontal axis to appear:<ol type="a"><li>Click #*If you would like the horizontal axis of the [[bar chart to reflect a single attribute such as the chart displayed below, the Series Expression will be the same as the Category expression.#:[[Image:iRepEditoriRep30.png|center|500px|''Bar chart –Single attribute y-axis'']]] icon that is displayed beside the Value Expression field.</li>:The Expression editor window displays.<lidiv align="center">From the Objects and expressions tab, select ''Bar chart –Single attribute y-axis'Variables''' from the left pane.</li</div><li>From #*If you would like the middle pane at the bottom horizontal axis of the Expression editor window, double-click bar chart to reflect the name values of an additional attribute, the Series Expression would be the variable that was created to store expression for the totalsecondary level of detail.</li><li>Click In the '''Apply''' buttonexample shown below, the x-axis reflects the land priorities (e.</li></ol><li>Click the '''OK''' buttong.</li>:The Chart Properties window closes, Low, Medium, or High).<li>Click In addition to displaying the priority, the bars of the '''Close''' button.</li>chart use a different colour to reflect those land which block water access (red) vs. those that do not block the water (blue). #:The Chart Properties window closes.<li>Save the report by either clicking the [[Image:iRepSaveiRep31.png]] icon, or by selecting the |center|500px|''Bar chart with different series expression'Save']]<div align="center">'' option from the Bar chart with different series Expression'''File''' menu.</li></oldiv>#* '''Finally, the Series value can be left blank if desired.'''===Grouped Bar Chart===__NOEDITSECTION__# The horizontal axis of next step is to provide the correct data for the bar chart to use. Bar charts discussed in the previous section compared the values of require a single variable. For example, the bar chart below compares the number of different activity types.  [[Image:iRep34.png|center|500px|''Figure 34. Bar chart comparing values of 'category expression''' and a single variable'']]<div align="center">'value expression'''Figure 34. Bar chart comparing values of where the value expression is a single variable''</div> In this section, you will learn how field to create a grouped bar chartgroup the data by (i.e. A grouped bar chart compares the values names of a single variable in one group to the same variables in another group. In X axis) and value expression is the example below, the grouped bar chart still compares the number of activity typesvalue to sum. However, the chart also compares the number of activity types between the districts#:[[Image:iReport Chart Bar2. The number of activity types (clearance, impact survey, technical survey, png|center|500px|''Category and road clearance) are represented by the different bar colours as indicated in Values'']]<div align="center">''Category and Values''</div># To select the legend. The coloured bars are clustered together based on their district. The first cluster of bars shows '''category expression''' choose the number of activity in the Bolikon district. The second cluster of bars shows the number '''Expression editor''' button and '''choose one of activities in the Waltern district. [[Image:iRep35.png|center|500px|''Figure 35. Grouped bar chart comparing values of a single variablefields''the report is grouped by']]<div align="center">''Figure 35(e. Grouped bar chart comparing values of a single variableg. ''status''</div> The two main differences between adding a bar chart and a grouped bar chart are:*The grouped bar chart requires that ). Note that charts in iReport will fail if the '''category expression''' is null. In order to account for null values, you specify at least two groupings for will need to modify the reportexpression so that null values are grouped into their own group. *The key expression and should be modified to include the category expression will differ; whereas, for a bar chart, bolded text below. You should replace field with the value for these expressions is the samefield that you selected above.  To add a grouped bar chart to the report#:<ol><li>Create a report which groups the results by the fields that will be represented on the horizontal axis of the chart'''$F{status} == null ? "N/A" : $F{status}'''#:[[Image:iReport Charts5.</li></ol> {{notepng|center|500px|For a grouped bar chart, you will need to specify at least two groupings.}} <ol start''Set Category Expression'']]<div align="2center">''Set Category Expression''<li/div>Add any variables that you may need to calculate #Next, select the '''value expression''' that you would like to show on contains the desired numeric data for the chart.</li><li>If you would like to display '''Note: This should always be one of the calculated variable for each group, you should add the footer for the field on which the results will be groupedvariables created in step 3 above''' (e. This footer will be used to display the variable for the group that will subsequently be used in the chartg. To add a group footer:</li><ol type="a"><li>From the ''SUM_status_byAreaSize''View''' menu, select ). #:[[Image:iReport Charts6.png|center|500px|''Select the desired value expression'Bands']]<div align="center">''Select the desired value expression''.</lidiv>:The <FileName> bands… window displays. <li>Select <# Choose ''GroupFieldName'Finish'>Footer from the left pane where ''GroupFieldNameis'' and the name of iReport template displays with the field on which the results will be groupedChart. For example, if you are creating a report on land and group the results by the priority, the name of the band would be #:[[Image:iReport Chart Bar3.png|center|500px|''priorityFooteriReport displays with Chart'']]<div align="center">''iReport displays with Chart''.</lidiv><li>In the right pane, enter a numeric value in the Band Height field# The report can now be previewed to ensure it is functioning as expected. You may adjust the height of the summary.</li><li>Click the #:[[Image:iReport Chart BarPreview.png|center|500px|''Preview with Chart'Apply']]<div align="center">''Preview with chart'' button.</li><li>Add a summary section to the report.</li></ol><li>Click the [[Image:iRepBarChart.png]] icon.</li><li>In the summary section of the report, hold down the mouse button and drag the cursor to form the rectangle which will contain the chart.</li>:A window of the various chart options displays.<li>Select one of the bar chart options.</li></ol> [[Image:iRep36.png|center|500px|''Figure 36. Bar chart options'']]<div align="center">''Figure 36. Bar chart options''</div> <ol start="8"><li>Click the '''OK''' button.</li><li>Right-click anywhere on the chart.</li><li>select the '''Chart Properties''' option.</li><li>From the Chart Properties window, select the Chart Data tab.</li><li>From the Chart Data tab, select the Details tab.</li><li>Click the '''Add''' button.</li>:The Chart Properties window displays. By default, the Data tab should be selected. <li>For a grouped bar chart, the series expression contains the field whose distinct values you would like to show via different colours on the bar chart.</li></ol> [[Image:iRep37.png|center|500px|''Figure 37. Bar chart series expression'']]<div align="center">''Figure 37. Bar chart series expression''</div> To enter the series expression:<ol start="15"><ol type="a"><li>Click the [[Image:iRepEditor.png]] icon that is displayed beside the Key Expression field.</li>:The Expression editor window displays.<li>From the bottom pane, double-click the name of the field that contains the data that you would like to include in the chart.</li>:The expression to represent the field displays in the top pane.<li>Click the '''Apply''' button.</li></ol><li>The Category Expression is the field by which the series expression is grouped together.</li></oldiv>

[[Image:iRep38.png|center|500px|''Figure 38. ====Modify a Bar Chart====__NOEDITSECTION__Once a bar chart category expressionhas been created in iReport Designer, its properties can be edited by selecting the '']]<div align="center">'Chart Data'Figure 38. Bar chart category expression''</div>option on the right click menu and adjusting the values and properties.

To enter the category expression:<ol start="16"><ol type="modify a"><li>Click the [[Imagebar chart:iRepEditor.png]] icon that is displayed beside the Category expression field.</li>:The Expression editor window displays.<li>From the bottom pane, double-# Right click the name of the field that contains the data that you would like to include in on the chart.</li>:The expression to represent the field displays in the top pane.<li>Click the iReport Designer and select '''ApplyChart Data''' buttonfrom the menu.</li></ol><li># The '''Value Expression''' field contains the variable that returns the numeric value that will be represented on the chartChart Data properties display.</li> <ol type="a"><li>Click # To edit the [[Image:iRepEditor.png]] icon that is displayed beside main properties of the Value Expression field.</li>:The Expression editor window displays.<li>From the Objects and expressions tabchart, select the '''VariablesDetails tab''' from the left pane.</li><li>From the middle pane at the bottom of the Expression editor windowAdditionally, double-click this screen can be used to edit the name reset type of the variable that you would like to represent on chart which is relevant if the chart.</li><li>Click is displayed on a band other than the '''Apply''' buttonsummary band.</li></ol><li>Click the ''# The 'OK''' button.</li>:The Chart Properties window closes.<li>Click the Details'''Close''' button.</li>:The Chart Properties window closes.<li>Save the report by either clicking the [[Image:iRepSave.png]] icon, or by selecting the Save option from the '''File''' menu.</li></ol>displays{{note|iReport requires you to save the report after adding or changing a chart.}} <ol start="20"><li>Click the [[Image#:iRepCompile.png]] button to compile the report.</li><li>Click the [[Image:iRepRun.png]] button to execute the report.</li></ol> ===Stacked IReport Chart Bar Chart===__NOEDITSECTION__A stacked bar chart is similar to a grouped bar in that it allows you to represent two different fields on the chart. The key difference is that the stacked bar chart layers the values of the series expression (the field represented in the legend) allowing you to easily compare the categories to one another.  [[Image:iRep39ChartData1.png|center|500px|''Figure 39. Stacked bar chartChart Data Properties'']]<div align="center">''Figure 39. Stacked bar chartChart Data Properties''</div> To add a grouped bar chart to the report:<ol><li>Create a report which groups the results by the fields that will be represented on the horizontal axis of the chart.</li></ol> {{note|# For a stacked bar chart, you will need to specify at least two groupings.}} <ol start="2"><li>Add any variables that you may need to calculate the value that you would like to show on the chart.</li><li>If you would like to display the calculated variable for each group, you should add the footer for the field on which the results will be grouped. This footer will be used to display the variable for the group that will subsequently be used in the chart. To add a group footer:</li><ol type="a"><li>From Bar Charts this presents the '''View''' menu, select '''BandsCategory Series'''chooser.</li>:The <FileName> bands… window displays. <li>Select <''GroupFieldName''>Footer from the left pane where ''GroupFieldName'' is the name of the field on which the results Typically there will be grouped. For example, if you are creating a report on land and group the results by the priority, the name of the band would only one or two series to choose from here though more can be ''priorityFooter''added at this point.</li> <li>In the right pane, enter a numeric value in Select the series to modify and choose '''Band HeightModify''' field. You may adjust the height of the summary</li><li>Click the '''Apply''' button.</li></ol><li>Add a summary section to the report.</li><li>Click the [[Image:iRepBarChart.png]] icon.</li><li>In the summary section of the report, hold down the mouse button and drag the cursor to form the rectangle which # The Chart Data properties window will contain the chart.</li>display#:A window of the various chart options displays.<li>Select one of the stacked bar chart options.</li></ol> [[Image:iRep40IReport Chart Bar ChartData2.png|center|500px|''Figure 40. Stacked bar chart optionsChart Data Properties'']]<div align="center">''Figure 40. Stacked bar chart options''</div> <ol start="8"><li>Click the '''OK''' button.</li><li>Right-click anywhere on the chart.</li><li>Select the '''Chart Data Properties''' option.</lidiv><li>From the Chart Properties # In this window, select the Chart Data tab.</li><li>From basic properties of the bar chart that were established in the Chart Data tab, select the Details tab.</liWizard can be edited.These include:<li>Click the #*'''AddSeries Expression''' button.</li>:The Chart Properties window displays. By default, the Data tab should be selected. <li>For a stacked bar chart, the series expression contains the fields whose distinct value.</li> <li>For a grouped bar chart, the series expression contains the field whose distinct values you would like used to show via different colours on the bar chartfirst group data for charting purposes. To enter the series expression:</li><ol type="a"><li>Click the [[Image:iRepEditor.png]] icon that is displayed beside change the Key Expression field.:The Expression editor window displays.</li><li>From the bottom pane, double-click the name of the field that contains the data that you would like to include in the chart.</li>:The expression to represent the simply select another field displays in the top pane.<li>Click the '''ApplyNote:''' button.</li></ol><li>The Category Expression while this field is the field required it can be made blank or fixed by which the series expression is grouped together. To enter the category expressionbeing set to a constant such as:</li><ol type="a">or "Blank".<li>Click the [[Image:iRepEditor.png]] icon that is displayed beside the #*'''Category expression field.</vli>Expression''':The Expression editor window displays.<li>From the bottom pane, double-click the name of the field that contains the used to group data that you would like to include in the chartfor charting purposes.</li>The expression to represent To change the field displays in the top pane.<li>Click the Apply button, simply select another field.</li></ol><li>The '''Value ExpressionNote:''' The field contains must be used in the creation of the variable that returns used in the numeric value that expression or the results will be represented on the chart.</li><ol type="a"><li>Click the [[Image:iRepEditor.png]] icon that is displayed beside the Value Expression fieldincorrect.</li>:The Expression editor window displays.<li>From the Objects and expressions tab, select #* '''VariablesValue Expression''' from : the left pane.</li><li>From variable used to store the middle pane at the bottom of the Expression editor window, double-click the name of the variable that you would like data to represent on be displayed in the chart.</li><li>Click If changes are made this value it is recommended to edit the '''Apply''' buttonvariable properties as well.</li></ol><li>Click the #* '''OKLabel Expression''' button.</li>:The Chart Properties window closes.<li>Click the '''Close''' button.</li>:The Chart Properties window closes.<li>Save area used to define the report by either clicking labels for the [[Image:iRepSavechart.png]] icon, or by selecting the '''Save''' option from the '''File''' menuAny valid expression can be used here.</li> <li>Click the See [[Image:iRepCompile.pngSummarize iReport Template Data#Variable Expressions|Variable Expressions]] button to compile the report.</li><li>Click the [[Image:iRepRunfor more details.png]] button to execute the report.</li></ol>

{{NavBox HowTo use iReportStandardizing Data Analysis and Information Reporting}}[[Category:VIE]]