Changes

Jump to: navigation, search

Summarize iReport Template Data

8,374 bytes removed, 14:04, 13 November 2015
no edit summary
__FORCETOC__
{{TOC right}}
{{HowTo's
|[[Start and Configure i-Report|Start and Configure i-Report]]
|[[Create a Basic i-Report Template|Create a Basic i-Report Template]]
|[[Modify an iReport Template|Modify an iReport Template]]
|[[Format an iReport Template|Format an iReport Template]]
|[[Create i-Report Templates with Subreports|Create i-Report Templates with Subreports]]
|[[Summarize i-Report Template Data|Summarize i-Report Template Data]]
}}
==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.
===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.
</ol>
[[Image:iRep22.png|center|500px|''Figure 22. REPORT_COUNT element in summary section'']]
<div align="center">
''Figure 22. REPORT_COUNT element in summary section''
</div>
{{note|If the REPORT_COUNT element is dragged to a section of the report other than the summary, the value returned by the REPORT_COUNT variable will be determined by where it is placed. For example, if the REPORT_COUNT is placed in the pageFooter section, the value returned will be the number of records displayed so far.}}
<olstart="4">
<li>To display the number of records in each group, drag the <GroupName>_COUNT variable to the <''GroupName''>Footer section.</li>
</ol>
{{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, click drag the static text element [[Image:iRepText.png]] iconfrom the '''Palette''' pane. }}
===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]]).
To create a custom variable:
# Follow the steps to [[Modify an iReport Template#Adding a Variable to an iReport Template| add a variable to an iReport]].
# From the '''Calculation Type''' list in the '''Properties''' pane, select the calculation that you would like to perform.
{| class="wikitable" width="600"
|-
| align="center" colspan="2" | '''Table 4. Calculation types'''
|-
| width="150pt" | '''Calculation type'''
|-
| System || No calculation is made. Instead the last value is stored.
|-
| First || No calculation is made. Instead the first value is stored.
|}
</center>
{| class="wikitable" width="600"
|-
| align="center" colspan="2" | '''Table 5. Reset Types'''
|-
| width="150pt" | '''Reset Type'''
<ol start="5">
<li>The '''Variable Expression''' field specifies the expression that will be provided to the variable. Typically, this will be the value of a field in the report. To specify a field in the report:</li><ol type="a"><li>Edit the edit the '''Variable Expression''' field.</li>[[Image:The Expression editor window displaysIReport VariableAdd5.<li>From the Objects and expressions tab, select png|center|500px|'''FieldsVariable Expression Editor''' from the left pane.]]</li><lidiv align="center">From the middle pane at the bottom of the Expression editor window, double-click the name of the field that you would like to use in the calculation.</li><li>Click the '''Apply''' button.</li>:The Expression editor window closes. The Add/modify variable window displays the selected field in the Variable Expression field. <li>Click the '''OKEditor''' button.</lidiv>:The Add/modify variable window closes and the variable that you just added is listed as a variable in the Library pane.</olli>
</ol>
In addition to the summary functions available on the variable, specific expressions can be used in the Expression Editor to define values. For example:{| class="wikitable" width=Crosstabs="600" align="center"???|-| align="center" colspan=Charts"2" | '''Expression Operations'''|-| width="150pt" | '''Operation'''| width="450pt" | '''Expression'''|-| Division || $F{areaSize}/$V{REPORT_COUNT}|-Charts provide a visual representation of the report data| Addition || $F{areaSize} + 500. Before you add a chart to your report, you should ensure that your report contains the following:0|-| Subtraction || $F{areaSize} - $P{ClearedArea}|-| Multiplication || $F{areaSize} *At least one grouping. The report groupings are used by iReport to determine what fields may be plotted.$V{REPORT_COUNT}*At least one variable that contains a calculation. This calculation may be a count, total, or other custom calculation. These calculated variables define the size of the chart segment. |-| Concatenation (string only)|| $F{localId} + $P{LocationName}===Pie Chart===__NOEDITSECTION__|}
{{note|The sample report ''Pie Chart Sample==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.jrxm lAs with other summary variables Crosstabs are generally used in the ''in the <'Summary Band'iReport Installation Directory''>\iReports_IMSMA\IMSMA reports directory provides an example of in a report that includes a pie chart.}}
To add create a pie chart Crosstab:# In the '''Palette''' pane, drag a '''Crosstab''' item to the Summary Band of the report:.<ol># The Crosstab wizard displays#: [[Image:IReport Crosstab1.png|center|500px|''Crosstab wizard'']]<lidiv align="center">Create a report which groups the results by the attribute on which you would like to base your chart.''Crosstab wizard''</lidiv><li>After creating # Select the report, you should add a footer for the attribute on which the results will be grouped. This footer will be used '''Field''' to display use in the total for the group that will subsequently be used in '''Row''' of the pie chartCrosstab grid. To add a group footer#: [[Image:IReport Crosstab2.png|center|500px|''Crosstab wizard'']]</li><ol typediv align="acenter">''Crosstab wizard''<li/div>From # Select the '''ViewField''' menu, select to use in the '''BandsColumn'''of the Crosstab grid.</li>#:The [[Image:IReport Crosstab3.png|center|500px|''Crosstab wizard'']]<FileNamediv align="center"> bands… window displays. ''Crosstab wizard''<li/div># Select <the '''Field'''GroupAttributeor ''>Footer from the left pane where 'Variable'GroupAttribute'' is to use to represent the name of data in the attribute on which the results will be groupedgrid. Typically this is a numeric field (e.g. For example, areaSize) or if you are creating a report on land and group count of the results by the priorityrecords is desired, the name of the band would be ''priorityFooterREPORT_COUNT''variable.</li><li>In the right pane, enter a numeric value in the Band Height field. You may adjust the height of the summary#: [[Image:IReport Crosstab4.png|center|500px|''Crosstab wizard'']]</li><lidiv align="center">Click the ''Crosstab wizard'Apply''' button.</li></oldiv><li>Add a summary section to # Finalise the reportCrosstab display.</li><li>Click the #: [[Image:iRepBarChartIReport Crosstab5.png|center|500px|''Crosstab wizard'']] icon.</lidiv align="center"><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.''Crosstab wizard''</lidiv>:A window of the various chart options # The Crosstab displays.<li>Select one of the pie chart options#: [[Image:IReport Crosstab6.png|center|500px|''Crosstab wizard'']]</lidiv align="center">''Crosstab wizard''</oldiv>
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.[[Image:iRep26IReport Crosstab7.png|center|500px|''Figure 26. Pie chart optionsCrosstab Preview'']]<div align="center">''Figure 26. Pie chart optionsExample Crosstab Preview''</div>
<ol start="7"><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>The Section Value tab should be selected by default. If it is not, select it.</li><li>The '''Key Expression''' defines the various slices of the pie chart. This will typically be each unique value for an attribute. For example, if the chart were to contain the total area size of land with a particular priority, the Key Expression would return the unique values for priority (e.g., Low, Medium, or High). To enter the key expression value:</li><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 attribute that contains the data that you would like to include in the chart.</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 name of the attribute that you selected in step b above.</li> :$F{''attribute''} '''!Charts= null ? $F{''attribute''} : "Unknown"'''<li>Click the '''Apply''' button.</li></ol><li>The '''Value Expression''' field contains the expression that returns the numeric value for the key. For example, it may be the total land size of high priority land.</li><ol type="a"><li>Click the [[Image:iRepEditor.png]] icon that is displayed beside the Value Expression field.</li>:The Expression editor window displays.<li>From the Objects and expressions tab, select '''Variables''' from the left pane.</li><li>From the middle pane at the bottom of the Expression editor window, double-click the name of the variable that was created to store the total.</li><li>Click the '''Apply''' button.</li></ol><li>The '''Label Expression''' field contains the expression that is used to determine the label for the segment of the pie chart. Because this expression will most likely be the same as the one used in the '''Key Expression''', you can copy the expression from the Key Expression field and paste it into the '''Label Expression''' field.</li><li>The following figure is an example of the Chart Properties window for a report that contains a pie chart which graphs the total area size of land based on their priority.</li>__NOEDITSECTION__
</ol>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:#At least one grouping. The report groupings are used by iReport to determine what fields may be plotted. See [[Modify an iReport Template|Modify an iReport Template]] for more information on [[Modify an iReport Template#Grouping|grouping]].#At least one variable that contains a calculation. This calculation may be a count, total, or other custom calculation. These calculated variables define the size of the chart segment. The '''Reset type''' of this calculation should be set to '''Group''' and use the report grouping defined in #1. See [[Modify_an_iReport_Template|Modify an iReport Template]] for more information on [[Modify_an_iReport_Template#To_add_a_variable_manually|adding variables]].
[[Image:iRep27.png|center|500px|''Figure 27. ===Pie Chart Properties'']]<div align="center">''Figure 27. Chart Properties''</div>==__NOEDITSECTION__
====Add a Pie Chart====__NOEDITSECTION__To add a pie chart to the report:#Create a report which groups the results by the attribute on which you would like to base your chart (e.g. ''status'').#Ensure that the Summary Band is available on the iReport template canvas.#[[Modify_an_iReport_Template#Adding a Variable to an iReport Template|Create a Variable]] to contain the values to be displayed in the chart (e.g. ''SUM_areaSize_byStatus''). This variable should be based on a numeric field (e.g. ''areaSize'') and should have the '''Reset type''' set to '''Group''' and the group selected set to the field you wish to create the chart from'' (e.g. ''status'').#Select the '''Chart''' option from the '''Palette''' pane and drag it to the '''Summary Band''' of the report template to start the '''Chart Wizard'''.#Select one of the pie chart options.#:[[Image:iReport Charts1.png|center|500px|''Chart options'']]<ol startdiv align="17center">''Chart options''<li/div>Click the #Choose Main report dataset.#:[[Image:iReport Charts2.png|center|500px|''Chart options'']]<div align="center">'Close'Chart options'' button</lidiv>:# The Chart Properties window closesnext step is to provide the correct data for the chart to use. Pie Charts require a '''unique identifier''' and a '''numeric''' value where the unique identifier is the field to group the data by (i.e. the names of the wedges) and numeric value is the value to sum.#:[[Image:iReport Charts3.png|center|500px|''Chart options'']]<div align="center">''Chart options''<li/div>Save # To select the '''unique value''' choose the '''Expression editor''' button and '''choose the ''field'' the report is grouped by either clicking ''' (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 iconbolded text below.#: '''$F{status} == null ? "N/A" : $F{status}'''#:[[Image:iReport Charts5.png|center|500px|''Set Unique Value'']]<div align="center">''Set Unique Value''</div>#Next, or by selecting select the '''Savenumeric value''' that contains the desired numeric data for the chart. ''' option from Note: This should always be the variable created in step 3 above'''(e.g. 'File'SUM_areaSize_byStatus'' menu). #:[[Image:iReport Charts6.png|center|500px|''Select the desired numeric variable'']]<div align="center">''Select the desired numeric variable''</lidiv>#Choose '''Next'''.#:[[Image:iReport Charts7.png|center|500px|''Chart Wizard Completed'']]<div align="center">''Chart Wizard Completed''</oldiv># Choose '''Finish''' and the iReport template displays with the Chart.#:[[Image:iReport Charts8.png|center|500px|''iReport displays with Chart'']]<div align="center">''iReport displays with Chart''</div>Below # The report can now be previewed to ensure it is an example of functioning as expected.#:[[Image:iReport ChartsPreview.png|center|500px|''Preview with Chart'']]<div align="center">''Preview with chart''</div>====Modify a Pie Chart====__NOEDITSECTION__Once a report template that totals chart has been created in iReport Designer, its properties can be edited by selecting the '''Chart Data''' option on the right click menu and adjusting the area size of land by priorityvalues 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:iRep28IReport ChartData1.png|center|500px|''Figure 28. Sample report template with pie chartChart Data Properties'']]<div align="center">''Chart Data Properties''</div># To edit the main properties of the chart, select the '''Details tab'''Figure 28. Sample report template with pie Additionally, this screen can be used to edit the reset type of the chart which is relevant if the chartis 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="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.
The resulting report pages are shown below.
[[Image:iRep29.png|center|500px|''Figure 29. Sample report with pie chart'']]
<div align="center">
''Figure 29. Sample report with pie chart''
</div>
===Bar Charts===__NOEDITSECTION__
Bar charts, unlike Pie Charts, have a third variable option that can be included in the report. In addition to the category and value expressions, bar charts add the option of a '''''series'''''. The series choice adds an additional possibility of grouping data though is not required.
{{note|The sample report ''====Add a Bar Chart Sample.jrxm l''in the <iReport Installation Directory>\iReports_IMSMA\IMSMA reports directory provides an example of a report that includes a bar chart.}}====__NOEDITSECTION__
To add a bar chart to the report:
<ol><li>#Create a report which groups the results by the attribute on which you would like to base your chart(e.g.</li>''status'')<li>After creating #Ensure that the report, you should add a footer for the attribute Summary Band is available on which the results will be groupediReport template canvas. This footer will be used #[[Modify_an_iReport_Template#Adding a Variable to an iReport Template|Create a Variable]] to display contain the total for the group that will subsequently values to be used displayed in the pie chart(e.g. To add a group footer:</li><ol type="a"><li>From the ''SUM_areaSize_byStatus'View''' menu, select '). This variable should be based on a numeric field (e.g. ''BandsareaSize'') and should have the '.</li>:The <FileName> bands… window displays. <li>Select <''Reset type''GroupAttribute'set to ''>Footer from the left pane where 'Group'GroupAttribute'' is and the name of group selected set to the attribute on which field you wish to create the results 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 be chart from'' (e.g. ''priorityFooterstatus'').</li><li>In the right pane, enter a numeric value in the Band Height field. You may adjust the height of the summary</li><li>Click #Select the '''ApplyChart''' button.</li></ol><li>Add a summary section option from the '''Palette''' pane and drag it to the report.</li><li>Click the [[Image:iRepBarChart.png]] icon.</li><li>In the summary section '''Summary Band''' of the report, hold down template to start the mouse button and drag the cursor to form the rectangle which will contain the chart'''Chart Wizard'''.</li>:A window #Select one of the various bar chart options displays.<li>Select one of the bar chart options#:[[Image:IReport BarChart.</li><li>Click the png|center|500px|''Chart options'OK''' button.]]</li><lidiv align="center">Right-click anywhere on the chart.</li><li>Select the '''Chart Properties'options'' option.</lidiv><li>From the Chart Properties window, select the Chart Data tab#Choose Main report dataset.</li><li>From the Chart Data tab, select the Details tab#:[[Image:IReport BarChart_Step1.png|center|500px|''Chart options'']]</li><lidiv align="center">Click the '''Add'Chart options'' button.</lidiv>:The Chart Properties window displays. By default, the Data tab should be selected# Provide a '''Series Expression''' (''optional''). <li>The Series Expression allows you to define an added level of detail to your bar chart. To enter the series expression value:</li><ol type="a"><li>Click the [#:[[Image:iRepEditoriReport Chart Bar1.png|center|500px|''Series Expression'']] icon that is displayed beside the Key <div align="center">''Series Expression field.''</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 the name '''Series''' choose the '''Expression editor''' button and '''choose one of the attribute that contains ''fields'' the data report is grouped by''' (e.g. ''status''). Note that you would like to include charts in iReport will fail if the chart.</li>:The expression to represent the attribute displays in the top pane'''Series''' value is null.<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 ? "N/A" : $F{attributestatus} : "Unknown"'''<li>Click the #:[[Image:iReport Charts5.png|center|500px|''Set Series Value'Apply']]<div align="center">''Set Series Value'' button.</li></oldiv>#: The expression that you enter in the Series Expression field will vary based on how you want the horizontal axis to appear:#*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.</ol> #:[[Image:iRep30.png|center|500px|''Figure 30. Bar chart –Single attribute y-axis'']]<div align="center">''Figure 30. Bar chart –Single attribute y-axis''</div> <ol>#*If you would like the horizontal axis of the bar chart to reflect the values of an additional attribute, the Series Expression would be the expression for the secondary level of detail. In the example shown below, the x-axis reflects the land priorities (e.g., Low, Medium, or High). In addition to displaying the priority, the bars of the chart use a different colour to reflect those land which block water access (red) vs. those that do not block the water (blue). </ol> #:[[Image:iRep31.png|center|500px|''Figure 31. Bar chart with different series expression'']]<div align="center">''Figure 31. Bar chart with different series expressionExpression''</div>#* '''Finally, the Series value can be left blank if desired.'''<ol># The Chart Properties window next step is to provide the correct data for this bar the chart is shown belowto use. Notice that the series expression and Bar charts require a '''category expression differ.</ol> [[Image:iRep32.png|center|500px|''Figure 32. Chart Properties – Different series ' and category expressionsa '']]<div align="center">'value expression'Figure 32. Chart Properties – Different series and category expressions''</div> <ol>*If you selected one of the stacked bar chart options, the series where the value expression will be used is a field to determine group the segments of each bardata by (i.e. In the following figure, names of the series X axis) and value expression creates red and blue segments in each bar is the value to indicate whether or not water access is blockedsum.</ol> #:[[Image:iRep33iReport Chart Bar2.png|center|500px|''Figure 33. Stacked bar chartCategory and Values'']]<div align="center">''Figure 33. Stacked bar chartCategory and Values''</div> <ol start="14"><li>The Category Expression is the major grouping of the horizontal axis. To enter # To select the '''category expression:</li><ol type="a"><li>Click ''' choose the [[Image:iRepEditor.png]] icon that is displayed beside the Category expression field.</li>:The '''Expression editor window displays.<li>From the bottom pane, double-click the name ''' 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.</li>:The '''category expression to represent the attribute displays in the top pane''' is null.<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 field with the name of the attribute field that you selected in step b above.</li>#: '''$F{''attribute''status} '''!== null ? "N/A" : $F{attributestatus} : "Unknown"'''<li>Click the '''Apply'#:[[Image:iReport Charts5.png|center|500px|''Set Category Expression'' button.]]</li></oldiv align="center"><li>The '''Value Set Category Expression''</div>#Next, select the ''' field contains the value expression ''' that returns contains the desired numeric value data for the keychart.</li><ol type="a"><li>Click '''Note: This should always be one of the [[Image:iRepEditorvariables created in step 3 above''' (e.g.png]] icon that is displayed beside the Value Expression field''SUM_status_byAreaSize'').</li>#:The Expression editor window displays[[Image:iReport Charts6.<li>From the Objects and expressions tab, select png|center|500px|''Select the desired value expression'Variables']]<div align="center">'' from Select the left pane.desired value expression''</lidiv><li>From the middle pane at the bottom of the Expression editor window, double-click the name of the variable that was created to store the total.</li><li>Click the # Choose '''ApplyFinish''' button.</li></ol><li>Click and the iReport template displays with the '''OK''' buttonChart.</li>#:The [[Image:iReport Chart Properties window closesBar3.<li>Click the png|center|500px|''iReport displays with Chart'Close']]<div align="center">'' button.<iReport displays with Chart''</lidiv>:# The Chart Properties window closesreport can now be previewed to ensure it is functioning as expected.<li>Save the report by either clicking the #:[[Image:iRepSaveiReport Chart BarPreview.png]] icon, or by selecting the |center|500px|''Preview with Chart'Save']]<div align="center">'' option from the '''File'Preview with chart'' menu.</lidiv></ol> ===Grouped Bar Chart===__NOEDITSECTION__The horizontal axis of the bar charts discussed in the previous section compared the values of 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 a single variable'']]<div align="center">''Figure 34. Bar chart comparing values of a single variable''</div> In this section, you will learn how to create a grouped bar chart. A grouped bar chart compares the values of a single variable in one group to the same variables in another group. In the example below, the grouped bar chart still compares the number of activity types. However, the chart also compares the number of activity types between the districts. The number of activity types (clearance, impact survey, technical survey, and road clearance) are represented by the different bar colours as indicated in the legend. The coloured bars are clustered together based on their district. The first cluster of bars shows the number of activity in the Bolikon district. The second cluster of bars shows the number of activities in the Waltern district. [[Image:iRep35.png|center|500px|''Figure 35. Grouped bar chart comparing values of a single variable'']]<div align="center">''Figure 35. Grouped bar chart comparing values of a single variable''</div> The two main differences between adding a bar chart and a grouped bar chart are:*The grouped bar chart requires that you specify at least two groupings for the report. *The key expression and the category expression will differ; whereas, for a bar chart, the value for these expressions is the same.  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 grouped 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 the '''View''' menu, select '''Bands'''.</li>:The <FileName> bands… window displays. <li>Select <''GroupFieldName''>Footer from the left pane where ''GroupFieldNameis'' the name of the field on which the results 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 be ''priorityFooter''.</li><li>In the right pane, enter a numeric value in the Band Height field. You may adjust the height of the summary.</li><li>Click the '''Apply''' 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></ol> [[Image:iRep38.png|center|500px|''Figure 38. Bar chart category expression'']]<div align="center">''Figure 38. Bar chart category expression''</div> To enter the category expression:<ol start="16"><ol type="a"><li>Click the [[Image:iRepEditor.png]] icon that is displayed beside the Category 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 '''Value Expression''' field contains the variable that returns the numeric value that will be represented on the chart.</li> <ol type="a"><li>Click the [[Image:iRepEditor.png]] icon that is displayed beside the Value Expression field.</li>:The Expression editor window displays.<li>From the Objects and expressions tab, select '''Variables''' from the left pane.</li><li>From the middle pane at the bottom of the Expression editor window, double-click the name of the variable that you would like to represent on the chart.</li><li>Click the '''Apply''' button.</li></ol><li>Click the '''OK''' button.</li>:The Chart Properties window closes.<li>Click the '''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> {{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 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:iRep39.png|center|500px|''Figure 39. Stacked bar chart'']]<div align="center">''Figure 39. Stacked bar chart''</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">===Modify a Bar Chart====__NOEDITSECTION__<li>Add any variables that you may need to calculate the value that you would like to show on the Once a bar chart.</li><li>If you would like to display the calculated variable for each grouphas been created in iReport Designer, you should add the footer for the field on which the results will its properties can be grouped. This footer will be used to display the variable for the group that will subsequently be used in edited by selecting the chart. To add a group footer:</li><ol type="a"><li>From the '''View''' menu, select '''Bands'''.</li>:The <FileName> bands… window displays. <li>Select <''GroupFieldName''>Footer from the left pane where 'Chart Data'GroupFieldName'' is the name of the field option on which the results will be grouped. For example, if you are creating a report on land right click menu and group adjusting the results by the priority, the name of the band would be ''priorityFooter''.</li> <li>In the right pane, enter a numeric value in the '''Band Height''' 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 values 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 stacked bar chart optionsproperties.</li></ol>
[[Image:iRep40.png|center|500px|''Figure 40. Stacked To modify a bar chart options'']]:<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 in iReport Designer and select '''Chart PropertiesData''' optionfrom the menu.</li><li>From the Chart Properties window, select the # The Chart Data tabproperties display.</li><li>From # To edit the main properties of the Chart Data tabchart, select the Details tab.</li.<li>Click the '''AddDetails tab''' button.</li>:The Chart Properties window displays. By defaultAdditionally, the Data tab should this screen can be selected. <li>For a stacked bar chart, used to edit the series expression contains reset type of the fields whose distinct value.</li> <li>For a grouped bar chart, the series expression contains the field whose distinct values you would like to show via different colours on which is relevant if the bar chart. To enter the series expression:</li><ol type="a"><li>Click the [[Image:iRepEditor.png]] icon that is displayed beside on a band other than the Key Expression fieldsummary band.:# 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 field displays in the top pane.<li>Click the '''ApplyChart Details''' button.</li>window displays</ol><li>The Category Expression is the field by which the series expression is grouped together. To enter the category expression#:</li><ol type="a"><li>Click the [[Image:iRepEditorIReport Chart Bar ChartData1.png|center|500px|''Chart Data Properties'']] icon that is displayed beside the Category expression field.</vlidiv align="center">: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.''Chart Data Properties''</lidiv>The expression to represent the field displays in # For Bar Charts this presents the top pane.<li>Click the Apply button.</li></ol><li>The '''Value ExpressionCategory Series''' field contains the variable that returns the numeric value that chooser. Typically there will be represented on only one or two series to choose from here though more can be added at this point. Select the chartseries to modify and choose '''Modify'''.</li><ol type="a"># The Chart Data properties window will display<li>Click the #: [[Image:iRepEditorIReport Chart Bar ChartData2.png|center|500px|''Chart Data Properties'']] icon that is displayed beside the Value Expression field.</lidiv align="center">:The Expression editor window displays.<li>From the Objects and expressions tab, select ''Chart Data Properties'Variables''' from the left pane.</lidiv><li>From the middle pane at the bottom of the Expression editor # In this window, double-click the name basic properties of the variable bar chart that you would like to represent on were established in the chartChart Wizard can be edited.</li>These include:<li>Click the #*'''ApplySeries Expression''' button: the field used to first group data for charting purposes.</li></ol><li>Click To change the field, simply select another field. '''OKNote:''' buttonwhile this field is required it can be made blank or fixed by being set to a constant such as: "" or "Blank".</li>#*'''Category Expression''':The Chart Properties window closesthe field used to group data for charting purposes.<li>Click To change the field, simply select another field. '''CloseNote:''' button.</li>:The Chart Properties window closes.<li>Save field must be used in the creation of the report by either clicking variable used in the [[Image:iRepSave.png]] icon, value expression or by selecting the results will be incorrect.#* '''SaveValue Expression''' option from : 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.#* '''FileLabel Expression''' menu.</li> <li>Click : the [[Image:iRepCompile.png]] button area used to compile define the labels for the reportchart.</li><li>Click the Any valid expression can be used here. See [[Image:iRepRun.pngSummarize iReport Template Data#Variable Expressions|Variable Expressions]] button to execute the reportfor more details.</li></ol>
{{NavBox HowTo use iReportStandardizing Data Analysis and Information Reporting}}[[Category:VIE]]
4,913
edits

Navigation menu