<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/EnterpriseStudio/onlinemanual/to_edit_reports" xml:lang="en" TopicType="Overview">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">To edit reports</Title>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>report</Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>Report Editor</Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>Report Layout</Level2>
		</Keyword>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>Report Script</Level2>
		</Keyword>
	</Header>
	<AimSection><List><ListIntro>This topic describes the following report editing operations:</ListIntro>
			<ListItem><Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/to_edit_reports#input_fields" role="manual">To edit report input fields</Link>
			</ListItem>
			<ListItem><Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/to_edit_reports#layouts" role="manual">To edit report layouts</Link>
			</ListItem>
			<ListItem><Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/to_edit_reports#report_script" role="manual">To edit a report script</Link>
			</ListItem>
		</List>
	</AimSection>
	<Important><SectionTitle>
                                 Important!
                              </SectionTitle>
		<Paragraph class="Default">The sections below describe the sessions that you must use to edit reports. However, they do not describe all details of these sessions. For detailed session information, refer to the Infor Web Help.</Paragraph>
	</Important>
	<GeneralSection ID="input_fields"><SectionTitle>To edit report input fields</SectionTitle>
		<Paragraph class="Default">In a report, you can create, edit and delete report input fields.</Paragraph>
		<Paragraph class="Default">A report input field defines the data that will appear on the report. You can use any value from the program script as a report input field.</Paragraph>
		<List><ListIntro>You can add a field as a report input field when:</ListIntro>
			<ListItem>The field is a table field and it is selected by the program script</ListItem>
			<ListItem>The field is a variable and it is defined in the program script (or library)</ListItem>
		</List>
		<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
			<Paragraph class="Default">You can define variables in a report script. Report script variables can be used in a print expression to output the variable value. However, you should not define a report script variable as a report input field.</Paragraph>
		</Note>
		<ProcedureList><ListIntro>To create a report input field:</ListIntro>
			<ListItem>In the <GUIRef href="" role="session">Reports (ttadv3530m000)</GUIRef> session, select the report you wish to edit.</ListItem>
			<ListItem>On the <GUIRef href="" role="menu">Specific</GUIRef> menu, click <GUIRef href="" role="command">Input Fields...</GUIRef>. The <GUIRef href="" role="session">Report Input Fields (ttadv3532m000)</GUIRef> overview session starts.</ListItem>
			<ListItem>If the report field does not exist for the report, click <GUIRef href="" role="manual">New</GUIRef> to add a report input field. The details session starts.</ListItem>
			<ListItem>Enter a report input field, or click the Zoom icon to display table fields. You may wish to enter the table id in the <GUIRef href="" role="manual">Field Name</GUIRef> field to quickly find the correct table field.</ListItem>
			<ListItem>Complete the dialog. Save the changes and close the dialogs.</ListItem>
		</ProcedureList>
		<Figure space-and-orientation="indented-estimated"><HTML:IMG height="462" width="657" SRC="../images/nt_screen_to_edit_reports1.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_to_edit_reports1.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_to_edit_reports1.gif" ID="IDATZ0AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Report Input Fields - overview session</FigCaption>
		</Figure>
		<Figure space-and-orientation="indented-estimated"><HTML:IMG height="344" width="660" SRC="../images/nt_screen_to_edit_reports2.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_to_edit_reports2.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_to_edit_reports2.gif" ID="IDAF00AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Report Input Fields - details session</FigCaption>
		</Figure>
	</GeneralSection>
	<GeneralSection ID="layouts"><SectionTitle>To edit report layouts</SectionTitle>
		<Paragraph class="Default">An ERP LN report usually contains multiple report layouts, such as Header, Before.field and Detail.</Paragraph>
		<Paragraph class="Default">Report layouts specify the report fields and the position of those fields on a report line. The report layouts execute depending on the data that is processed from the report input fields.</Paragraph>
		<Paragraph class="Default">For information on the types of layouts, refer to <Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/reports" role="manual">Reports</Link>.</Paragraph>
		<GeneralSection><SectionTitle>To view report layouts</SectionTitle>
			<Paragraph class="Default">A report can have multiple layouts. To view the report layouts, in the <GUIRef href="" role="session">Reports (ttadv3530m000)</GUIRef> session click <GUIRef href="" role="command">Layouts...</GUIRef>, or click the <GUIRef href="" role="command">Layouts...</GUIRef> command on the <GUIRef href="" role="menu">Specific</GUIRef> menu. The <GUIRef href="" role="session">Report Layouts (ttadv3531m000)</GUIRef> session starts. The layouts for the report are displayed.</Paragraph>
			<Figure space-and-orientation="indented-estimated"><HTML:IMG height="308" width="659" SRC="../images/nt_screen_to_edit_reports3.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_to_edit_reports3.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_to_edit_reports3.gif" ID="IDAO00AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Report Layouts</FigCaption>
			</Figure>
		</GeneralSection>
		<GeneralSection><SectionTitle>To edit all layouts</SectionTitle>
			<Paragraph class="Default">You edit the layouts to change the report contents and positions.</Paragraph>
			<Paragraph class="Default">To edit all the layouts, in the <GUIRef href="" role="session">Report Layouts (ttadv3531m000)</GUIRef> session, click the <GUIRef href="" role="command">Edit All Layouts...</GUIRef> command on the <GUIRef href="" role="menu">Specific</GUIRef> menu. The report layout editor starts.</Paragraph>
			<Figure space-and-orientation="indented-estimated"><HTML:IMG height="243" width="658" SRC="../images/nt_screen_to_edit_reports4.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_to_edit_reports4.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_to_edit_reports4.gif" ID="IDAX00AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Edit All Layouts</FigCaption>
			</Figure>
			<Paragraph class="Default">The layout editor contains many options. Not all the options are shown here. To view the help options, click <GUIRef href="" role="manual">Help</GUIRef> on the <GUIRef href="" role="manual">Help</GUIRef> menu.</Paragraph>
			<Paragraph class="Default">The major editing tasks are moving fields and labels, drawing boxes, and creating report fields.</Paragraph>
			<Paragraph class="Default"></Paragraph>
			<GeneralSection><SectionTitle>To move fields and labels</SectionTitle>
				<ProcedureList><ListIntro>You need to move fields and labels in order to align columns or make room for other data fields. To move a field or label:</ListIntro>
					<ListItem>Select the field or label (do not double-click).</ListItem>
					<ListItem>Holding your mouse button, drag the mouse or use the arrow keys to place the field in another location in the layout.</ListItem>
					<ListItem>Drop the field in the desired location. When using the arrow keys, you must press Esc.</ListItem>
				</ProcedureList>
				<Paragraph class="Default">In addition to moving labels, you may need to change the label length, or create new labels with shorter lengths in order for the label to fit in the column width.</Paragraph>
			</GeneralSection>
			<GeneralSection><SectionTitle>To create or edit a report field</SectionTitle>
				<Paragraph class="Default">A report field is denoted in the editor with the capital F’s (“FFF”).</Paragraph>
				<ProcedureList><ListIntro>To create a report field:</ListIntro>
					<ListItem>Place your cursor in the top left position where you want the new field.</ListItem>
					<ListItem>On the <GUIRef href="" role="manual">Edit</GUIRef> menu, click <GUIRef href="" role="manual">Form Field</GUIRef>. Alternatively, you can press CTRL + F simultaneously. The <GUIRef href="" role="session">Report Fields (ttadv3134s000)</GUIRef> session starts.</ListItem>
					<ListItem>Enter a print expression. A print expression can be: <List><ListItem>A report input field</ListItem>
							<ListItem>A report script variable</ListItem>
							<ListItem>A calculated expression from 1 or more other input fields (or report script variables)</ListItem>
						</List>
					</ListItem>
					<ListItem>Specify the remaining report field options in the <GUIRef href="" role="groupbox">Display</GUIRef>, <GUIRef href="" role="groupbox">Conditions</GUIRef> and <GUIRef href="" role="groupbox">Font</GUIRef> tabs.</ListItem>
				</ProcedureList>
				<Paragraph class="Default">To edit a report field: double-click on the field to start the <GUIRef href="" role="session">Report Fields (ttadv3134s000)</GUIRef> session, where you can modify the field's properties.</Paragraph>
			</GeneralSection>
			<GeneralSection><SectionTitle>To draw boxes and graphical characters</SectionTitle>
				<Paragraph class="Default">After adding report fields, the content is complete, and you may wish to align the data in columns. You align data into columns using the boxes, or graphical characters.</Paragraph>
				<ProcedureList><ListIntro>To draw a box:</ListIntro>
					<ListItem>Position the cursor in the top left position of the box.</ListItem>
					<ListItem>On the <GUIRef href="" role="manual">Edit</GUIRef> menu, click <GUIRef href="" role="manual">Draw Box</GUIRef>. The cursor changes to a plus (+) sign.</ListItem>
					<ListItem>Click the cursor on the bottom right corner of the box. The box is now complete.</ListItem>
				</ProcedureList>
				<Figure space-and-orientation="indented-estimated"><HTML:IMG height="97" width="354" SRC="../images/nt_screen_to_edit_reports6.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_to_edit_reports6.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_to_edit_reports6.gif" ID="IDAJ10AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Draw Box - cursor changes to plus (+) sign</FigCaption>
				</Figure>
				<Figure space-and-orientation="indented-estimated"><HTML:IMG height="79" width="341" SRC="../images/nt_screen_to_edit_reports7.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_to_edit_reports7.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_to_edit_reports7.gif" ID="IDAS10AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Draw Box Complete</FigCaption>
				</Figure>
				<Paragraph class="Default">A box will draw irrespective of any adjoining lines.</Paragraph>
				<Paragraph class="Default">You can join lines or boxes using graphical characters.</Paragraph>
				<ProcedureList><ListIntro>To insert a graphical character:</ListIntro>
					<ListItem>On the <GUIRef href="" role="manual">Mode</GUIRef> menu, click <GUIRef href="" role="manual">Toggle Graphics</GUIRef> to enter graphical mode.</ListItem>
					<ListItem>Use your numeric keypad to select the appropriate character. See the figure below. Use the pipe (|) key for vertical lines and the hyphen (-) for horizontal lines.</ListItem>
					<ListItem>On the <GUIRef href="" role="manual">Mode</GUIRef> menu, click <GUIRef href="" role="manual">Toggle Graphics</GUIRef> to exit graphical mode.</ListItem>
				</ProcedureList>
				<Figure space-and-orientation="indented-estimated"><HTML:IMG height="273" width="270" SRC="../images/nt_graph_to_edit_reports8.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_graph_to_edit_reports8.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_graph_to_edit_reports8.gif" ID="IDAC4ZAC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Numeric Keypad and Graphical Characters</FigCaption>
				</Figure>
			</GeneralSection>
		</GeneralSection>
		<GeneralSection><SectionTitle>To create a layout</SectionTitle>
			<List><ListIntro>Typical reasons for creating a layout are:</ListIntro>
				<ListItem>Before field layouts to create sub-headings</ListItem>
				<ListItem>After Field Layouts to calculate sub-totals using the aggregate functions</ListItem>
				<ListItem>After Report layout to create a grand total using the aggregate functions</ListItem>
				<ListItem>An additional Detail layout to print optional detail information on a new line</ListItem>
			</List>
			<ProcedureList><ListIntro>To create a layout:</ListIntro>
				<ListItem>In the <GUIRef href="" role="session">Report Layouts (ttadv3531m000)</GUIRef> session, click <GUIRef href="" role="manual">New</GUIRef>. The <GUIRef href="" role="session">Report Layouts (ttadv3131s000)</GUIRef> details session starts.</ListItem>
				<ListItem>Enter the layout information.</ListItem>
				<ListItem>Edit the layout in the report editor: place the desired fields and/or labels in the new layout.</ListItem>
			</ProcedureList>
			<Figure space-and-orientation="indented-estimated"><HTML:IMG height="374" width="656" SRC="../images/nt_screen_to_edit_reports9.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_to_edit_reports9.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_to_edit_reports9.gif" ID="IDA110AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Report Layouts details session</FigCaption>
			</Figure>
			<ExampleSection><SectionTitle>
                                       Example
                                    </SectionTitle>
				<Paragraph class="Default">The items are printed by item group. At the end of each item group a sub-total is displayed.</Paragraph>
				<List><ListIntro>To achieve this, you must:</ListIntro>
					<ListItem>Make sure that the records are sorted by Item Group: in the report input field properties, define a sort mode for the Item Group field.</ListItem>
					<ListItem>Add a before.field layout. In the layout properties, you must select the Item Group field.</ListItem>
					<ListItem>Start the report editor and place the Item Group field and the corresponding label in the new before.field layout.</ListItem>
					<ListItem>Add an after.field layout. In the layout properties, you must select the Item Group field.</ListItem>
					<ListItem>Start the report editor and place the desired sub-totals in the after.field layout. <List><ListItem>For example: to place a sub-total for the Stock on Hand field (cxoes020.stoh) you must place the cxoes020.stoh field in the after.field layout. In the field properties you must select the "Total" aggregate function.</ListItem>
						</List>
					</ListItem>
				</List>
				<Figure space-and-orientation="indented-estimated"><HTML:IMG height="275" width="659" SRC="../images/nt_screen_to_edit_reports10.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_to_edit_reports10.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_to_edit_reports10.gif" ID="IDA2Z0AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Report with sub-totals per Item Group</FigCaption>
				</Figure>
			</ExampleSection>
		</GeneralSection>
	</GeneralSection>
	<GeneralSection ID="report_script"><SectionTitle>To edit a report script</SectionTitle>
		<Paragraph class="Default">A report script allows you to customize the processing of the report.</Paragraph>
		<Paragraph class="Default">Report scripts have sections that correspond to a layout. A section can be processed before a layout, or after a layout. The report script is compiled with the report when the report is compiled.</Paragraph>
		<List><ListIntro>For details on report scripts, refer to:</ListIntro>
			<ListItem><Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/report_scripts" role="manual">Report scripts</Link>
			</ListItem>
			<ListItem>"Report Script Features" in the <DocRef>ERP LN 6.1 Programmer's Guide</DocRef>. Predefined variables used in a report are also listed.</ListItem>
		</List>
		<Paragraph class="Default">To edit a report script, you must use the <GUIRef href="" role="session">Reports (ttadv3530m000)</GUIRef> session.</Paragraph>
	</GeneralSection>
	<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
		<RelTopic><Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/reports" role="manual">Reports</Link>
		</RelTopic>
		<RelTopic><Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/to_create_reports" role="manual">To create reports</Link>
		</RelTopic>
	</RelatedTopics>
</ManualTopic>
