Changes

__FORCETOC__{{TOC right}} ==Creating a Basic Report iReport Template Using the Wizard==__NOEDITSECTION__{{IMSMANG}} provides an There is a wizard in iReport Wizard to help in the process of creating new iReport templates. To create an iReport template using the Wizard:

<li>From In the '''File''' menu, select &rarr; '''Report WizardNew...'''. </li>:The iReport Wizard window displays. <li>From Select the '''Connection/Data Sources''' list, select the item for which template you would like to create a use for your report.Blank A4 or an IMSMA specific template are preferrable</li>

 [[Image:iRep01{{note|At iReport startup, it can take several seconds to load the window with the templates.png|center|500px|The next time you click on '''Figure 1New. iReport Wizard – Step 1..''']]however, the templates appear instantaneously.}}

[[Image:iReport Wizard1.png|center|500px|''Figure iReport Wizard – Step 1. '']]''iReport Wizard – Step 1''

<li>Click the '''NextLaunch Report Wizard''' button.</li>:The window to select the attributes to include in the report displays.

<div align="center">[[Image:iRep02iReport Wizard2.png|center|500px|''Figure 2. iReport Wizard - Step 2'']]<div>''Figure 2. iReport Wizard - Step 2''

<li>From the Step 2. select fields screen:</li><ol type="a"><li>Select the attributes that you would like to include in desired Data Source for the report. and choose '''Error! Reference source not found.Next''' describes the available buttons.</li>

| align="center" colspan="2" | '''Table 2. iReport Wizard – Buttons for selecting fields'''

| align="center" | [[Image:iRepLA.png]] || Removes Deletes the selected field from the report.

| align="center" | [[Image:iRepDLA.png]] || Indicates a tip for using IMSMADeletes all fields from the report.

</centerdiv>

{{note|If you would like It is recommended to organise the report results by country structure areas, you should always include the country structure level by which you would like to group the results as one of the fields. Be aware that including the country structure level field in the report will return a string that contains all country structure levels above the selected level.}} <ol start="5"><ol type="a" start="2"><li>Click the '''Next''' button.</li>:A window displays the selected fields. </ol> <li>Click the '''Next'guid'' button.</li> The window to group the report data displays. The group by step allows you to list item records that have the same value for the selected group by field together in the report. The below figure illustrates an example of when designing a report that groups its results by gazetteer. For more information on grouping, refer to Grouping.</ol> [[Image:iRep03.png|center|500px|''Figure 3. Group by example'']]}}

<li>Click the '''Next''' button.The [[Modify an iReport Template#Sorting_and_Grouping|group by]] step allows you to list item records that have the same value for the selected group by field together in the report. If you would like to group the report data, select the attribute on which you would like to group the data from the Group list.</li>

[[Image:iReport Wizard5.png|center|500px|''Figure 4. Columnar layoutiReport Wizard - Step 5''</div>]]

<p>The tabular layout option displays the field names across the top of the page. The corresponding report results are displayed below each field name.</p> [[Image:iRep05.png|center|500px|''Figure iReport Wizard - Step 5. Tabular layout'']]<div align="center">''Figure 5. Tabular layout''

<li>From the window to select a layout:</li><ol type="a"><li>Select the layout option.</li><li>Click the '''Next''' button.</li>:The window displays a message stating that you have successfully created a new report.</ol><li>Click the and then '''Finish''' button.</li>:The Wizard is complete and the iReport template for designer window is open. Depending on your selections your report displays. <li>Ensure that the data source selected matches the item of template will look different from the reportexample below.</li>

[[Image:iReportHome1.png|center|500px|''Land grouped by locationiReport Wizard - Final Step'']]''iReport Wizard - Final Step''

==iReport Designer Orientation==Adding __NOEDITSECTION__Once your initial iReport template has been created you can begin adding data elements to the template, modifying the layout and formatting, and other aspects of [[Modify an iReport Template|modifying an iReport Template]]. Below is a Group brief orientation to an Existing Report====__NOEDITSECTION__the panes and functions available in the iReport Designer. If any of the panes or windows are unavailable they can be added back by selecting the relevant item from the '''Window''' menu.

{{note|===Report Inspector === __NOEDITSECTION__The field on which you would like Report Inspector pane displays a hierarchical structure of the iReport template and provides access to group your the available fields, parameters, and variables as well as all formatting elements of the report results must . Each node can be included expanded for more details about the elements contained in the reportit.}}

To add a group to an existing report:<ol><li>From the '''View''' menu, select '''===Report Groups'''.</li><li>A window displays the groups for the report.</li><li>Click the '''New''' button.</li>Canvas ===__NOEDITSECTION__:The Add/modify group window displays. <li>Enter an identifier for the group. This should be a meaningful name that allows you to easily identify the contents middle area of the group such as the field on which the results are grouped.</li><li>Click the [[Image:iRepExpress.png]] icon.</li>:The Expression editor window iReport Designer displays.<li>Ensure that the Objects and expressions tab is selected.</li><li>Click '''Fields'''.</li><li>Double-click the name of the field on which you would like to add a grouping.</li>:The Expression editor window shows $F{FieldName} where FieldName is the name graphical representation of the field iReport template that you selected previously. <li>Click the '''Apply''' button.</li>:The Add/modify group window displays corresponds to the expression hierarchical structure in the Group Expression fieldReport Inspector. <li>Click In this pane you move elements around on the '''OK''' buttoncanvas as well as select individual elements for editing.</li>:The Add/modify group window closes. </ol>

{{note|You may also enter ===Properties Pane ===__NOEDITSECTION__This pane will display all of the expression properties of items selected in the Group Expression field if you know the exact spelling of the field name on which you would like to group the resultsReport Inspector or Report Canvas. The syntax is $F{''FieldName''}Properties Pane displays a context-senstive list of properties for any selected item for editing.}}

===Adding FieldsPalette===__NOEDITSECTION__<p>If you need to include a field that was not selected while using the Report Wizard, you will need to know the name of the field that The Palette is used by the data source. Find a list of available field names by using the Report Wizard.</p> <p>To add a field to your report:</p><ol><li>From the '''View''' menu, select the '''Fields''' option.</li>:A window displays three tabs (Fields, Variables, area where individual graphic elements can be selected and Parameters).<li>From the Fields tab, click the '''New''' button.</li>:The Add/modify field window displays.<li>In dragged onto the '''Field Name''' field, enter the name of the field that you would like to includecanvas.</li><li>Click the '''OK''' button.</li>:The field is included on the Fields tab.<li>Close the window that displays the Fields, Variables, This includes subreports and Parameters tabs.</li><li>Reposition the fields on your report as needed to accommodate the new field.</li><li>Click the [[Image:iRepF.png]] icon.</li><li>Click the detail section of the report.</li><li>While holding down the mouse button, drag the cursor to form the rectangle which will contain the new field.</li><li>Release the mouse button.</li>:A placeholder for the field is displayed in the design section of the reportcrosstab elements. <li>Double-click the placeholder that was added for the field.</li><li>Change the placeholder text so that the field that you added is between the brackets.</li></ol>

===Sorting Report ResultsFormatting Tools ===__NOEDITSECTION__It may be helpful The Formatting Tools pane provides access to sort the report results using the value in one or more of the fields. Sorting the results makes it easier various formatting functions designed to review manage the results size and locate any records that you may be searching for. To sort report results:<ol start="13"><li>Create space between elements on the report.</li><li>From the '''Data''' menu, select the '''Report Query''' option.</li>:The Report query window displays.<li>Click the '''Sort options''' button that is located at the bottom of the Report query window.</li>:The Sorting Options window displays. <li>Click the '''Add Field''' button.</li>:The Sort Field window displays. The Sort by list displays all the fields that you have selected for the report. <li>From the '''Sort by''' list, select the field by which you would like to sort the report results.</li></ol>

{{note|When sorting data in ===iReport Output ===__NOEDITSECTION__This pane displays any problems or output from the reports that contain groups, ensure the “Group by” fields appear first in the sort order.}}

<ol start="18">=XML and Preview Views==__NOEDITSECTION__<li>From In addition to the '''Sort Type''' listDesigner View, iReport Designer provides 2 additional views, select either the ''Ascending'' or ''Descending'' sort orderXML View and the Preview.</li><li>Click Using the XML View you can get an editable version of the '''OK''' button.</li>:The selected field displays in the Sorting Options windowjrxml file created by iReport Designer. <li>Repeat steps 4-7 This is useful for troubleshooting specific problems with a report but is generally only for each field on which you would like to sort the resultsadvanced users.</lidiv align="center"><li>After you have completed adding the fields on which you would like to sort the results, click the [[Image:iReportXMLView.png|center|500px|''XML View'Close''' button.</li>:The Sorting Options window closes. ]]<li>From the Report query window, click the ''XML View'OK''' button.</li>:The Report query window closes.</oldiv> <p>You will need to compile and execute the report for the sort options to take effect.</p>

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