<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/EnterpriseStudio/onlinemanual/reports" xml:lang="en" TopicType="Overview">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Reports</Title>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>report</Level2>
		</Keyword>
	</Header>
	<GeneralSection><Paragraph class="Default">Reports are used to print data to the screen, to a printer or to another output device.</Paragraph>
		<List><ListIntro>Reports are used in (print) sessions and in SQL queries:</ListIntro>
			<ListItem>A session can have multiple reports. If more than one report is defined you are usually presented with a list of reports that are available in the session.</ListItem>
			<ListItem>An SQL query can have one report at most.</ListItem>
		</List>
		<ExampleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
			<Figure space-and-orientation="indented-estimated"><FigIntro>You are responsible for general item data. You need to generate list of all items. You start the <GUIRef href="" role="manual">Print Items - General (tcibd0401m000)</GUIRef> session.</FigIntro>
				<HTML:IMG height="460" width="697" SRC="../images/nt_screen_reports1.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_reports1.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_reports1.gif" ID="IDAGG0AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Print Items - General (Selections tab)</FigCaption>
			</Figure>
			<List><ListIntro>When you print the Items - General report, you will see that the session uses three reports:</ListIntro>
				<ListItem>Items - General (Details)</ListItem>
				<ListItem>Items - General (Summary)</ListItem>
				<ListItem>Items - General (General)</ListItem>
			</List>
			<Figure space-and-orientation="indented-estimated"><HTML:IMG height="120" width="307" SRC="../images/nt_screen_reports2.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_reports2.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_reports2.gif" ID="IDAPG0AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Print Items - General – Select Report</FigCaption>
			</Figure>
			<Figure space-and-orientation="indented-estimated"><FigIntro>When you select the Items - General (Summary) report, the following report is printed:</FigIntro>
				<HTML:IMG height="368" width="696" SRC="../images/nt_screen_reports3.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="nt_screen_reports3.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/nt_screen_reports3.gif" ID="IDAYG0AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Items - General (Summary) report printed to screen</FigCaption>
			</Figure>
		</ExampleSection>
	</GeneralSection>
	<GeneralSection><SectionTitle>Report structure</SectionTitle>
		<Paragraph class="Default">
                                 ERP LN reports contain one or more of the following layouts:</Paragraph>
		<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><THEAD><TR><TD width="93" rowspan="1" colspan="1">Layout</TD>
					<TD width="823" rowspan="1" colspan="1">Description</TD>
				</TR>
			</THEAD>
			<TBODY><TR><TD width="93" rowspan="1" colspan="1">Before.report</TD>
					<TD width="823" rowspan="1" colspan="1">Layouts of this type are printed once at the beginning of the report. This layout can be used to present information about the report. For example, the title page of the report.</TD>
				</TR>
				<TR><TD width="93" rowspan="1" colspan="1">Header</TD>
					<TD width="823" rowspan="1" colspan="1">Header layouts are printed at the top of every page.</TD>
				</TR>
				<TR><TD width="93" rowspan="1" colspan="1">Before.field</TD>
					<TD width="823" rowspan="1" colspan="1">You can define this layout for each input field for which a Sort Mode is defined in the <GUIRef href="" role="manual">Report Input Fields (ttadv3532m000)</GUIRef> session. Each time the value of the sorted input field changes, this layout is printed before the Detail lines. In this way the records are grouped. If a group of records spans more than one page, the before.field layout is repeated at the top of the new page (following the header).</TD>
				</TR>
				<TR><TD width="93" rowspan="1" colspan="1">Detail</TD>
					<TD width="823" rowspan="1" colspan="1">Detail layouts are used for the individual records included in the body of the report. They are printed every time that data is sent to the report.</TD>
				</TR>
				<TR><TD width="93" rowspan="1" colspan="1">After.field</TD>
					<TD width="823" rowspan="1" colspan="1">You can define this layout for each input field for which a Sort Mode is defined in the <GUIRef href="" role="manual">Report Input Fields (ttadv3532m000)</GUIRef> session. Each time the value of the sorted input field changes, the layout is printed after the detail lines. In this layout, the presorted input field still contains the old value. This layout, for example, can be used to print totals for a particular group of detail lines.</TD>
				</TR>
				<TR><TD width="93" rowspan="1" colspan="1">Footer</TD>
					<TD width="823" rowspan="1" colspan="1">Footer layouts are printed at the bottom of each page. <List><ListIntro>This layout is used to print:</ListIntro>
							<ListItem>Titles</ListItem>
							<ListItem>Page numbers</ListItem>
							<ListItem>Page totals</ListItem>
						</List>
					</TD>
				</TR>
				<TR><TD width="93" rowspan="1" colspan="1">After.report</TD>
					<TD width="823" rowspan="1" colspan="1">This layout is only printed at the end of the report, and after all other layouts. If this layout does not fill a complete page, the footer layout will be printed at the bottom of the page, where the After.report layout(s) is printed.</TD>
				</TR>
			</TBODY>
		</TABLE>
		<Paragraph class="Default">The contents and layouts of reports are defined in the data dictionary. In addition, you can link a report script to a report. In a report script, you can program actions that you want to be performed at particular stages of the report execution. For example, you can create a script to perform calculations on the report data or to read records from related tables that are not automatically available to the report.</Paragraph>
		<Paragraph class="Default">You program report scripts in the same way as you program 4GL program scripts, except that report scripts use different event sections and some special functions.</Paragraph>
	</GeneralSection>
	<GeneralSection><SectionTitle>To create reports</SectionTitle>
		<Paragraph class="Default">You can create reports in the <GUIRef href="" role="manual">Reports (ttadv3530m000)</GUIRef> session and in the <GUIRef href="" role="manual">Report Generator (ttadv3130s100)</GUIRef> session. You can start these sessions from the <GUIRef href="" role="manual">Sessions (ttadv2500m000)</GUIRef> session and from the <GUIRef href="" role="manual">Sessions (ttadv2100s000)</GUIRef> session respectively.</Paragraph>
		<Paragraph class="Default">You can change the report layout in the Report Editor that is part of Development Tools.</Paragraph>
		<Paragraph class="Default">For details, refer to <Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/to_create_reports" role="manual">To create reports</Link>.</Paragraph>
		<List><ListIntro>For more information, refer to the following topics in the Web Help:</ListIntro>
			<ListItem>Reports Overview</ListItem>
		</List>
	</GeneralSection>
</ManualTopic>
