<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv3134s000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Report Fields (ttadv3134s000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to maintain the details of the layout fields in a report.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">With this session you can define general data for report fields. You can specify the print expression, domain data, several conditions, color and feature codes.</Paragraph>
		</GeneralSection>
	</HelpTopic>
	<Fields><FieldHelp ID="ttadv331.cmod"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Report</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#100004" role="glossary">module</Link> to which the report belongs.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv331.crep"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Report</Title>
			</Header>
			<FuncDesc>The identification code of the report. A report is uniquely identified by the combination of package code, module code, report code and language.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv331.rseq"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Layout Type</Title>
			</Header>
			<FuncDesc>It is possible to define more than one layout by Layout/Fieldname combination. The layouts of the same Layout/Fieldname will be printed in the order of the sequence number of the layouts.</FuncDesc>
			<SimpleSection><List><ListIntro>There are two reasons to define more than 1 layout by Layout/Fieldname combination:</ListIntro>
					<ListItem>The maximum size of a layout is 22 lines. If your layout should have more lines, you can make a second layout of the same type with a higher sequence number.</ListItem>
					<ListItem>If a particular layout must be printed under certain conditions and another layout under other conditions, you have to define more than one layout with different output conditions.</ListItem>
				</List>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv334.xpos"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Column</Title>
			</Header>
			<FuncDesc>The start column number of the report field in the layout.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv334.ypos"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Row</Title>
			</Header>
			<FuncDesc>The start row number of the report field in the report layout.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv334.pexp"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Print Expression</Title>
			</Header>
			<FuncDesc>The value to be printed at the report layout. You can zoom to the report input field data to select an input field. Furthermore you can use any 3GL expression.</FuncDesc>
			<SimpleSection><SectionTitle>Examples</SectionTitle>
				<List><ListIntro>It is possible to use report script variables in the print expression.</ListIntro>
					<ListItemHead>maitm001.item</ListItemHead>
					<ListItem>Field maitm001.item will be printed</ListItem>
					<ListItemHead>price / 100</ListItemHead>
					<ListItem>The variable "price" divided by 100 will be printed</ListItem>
				</List>
				<Paragraph class="Default">It is possible to use the question mark in the print expression.</Paragraph>
				<Paragraph class="Default">Syntax: condition ? expression 1 : expression 2</Paragraph>
				<Paragraph class="Default">If the condition equals true, the expression 1 is printed, else expression 2 is printed.</Paragraph>
				<Paragraph class="Default">Question mark expressions can be nested, so expression 1 or 2 can be a question mark expression itself.</Paragraph>
				<List><ListItemHead>flag = 1 ? tdsls041.item : tdpur041.item</ListItemHead>
					<ListItem>If flag = 1, print tdsls041.item, if flag is not 1, print tdpur041.item</ListItem>
					<ListItemHead>flag &lt; 0 ? (flag = -1 ? value.1 : value.2) : value.3</ListItemHead>
					<ListItem>If flag lower than 0 and flag = -1, print value.1; If flag lower than 0 and flag is not -1, print value.2; If flag not lower than 0 print value.3</ListItem>
				</List>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv334.pacd"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Domain</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> of the domain of the print expression of the report field.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv334.cdom"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Domain</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#domain.tt" role="glossary">domain</Link> of the print expression of the report field.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="cdom.type"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Domain</Title>
			</Header>
			<FuncDesc>The type of the domain of the report field.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv334.link"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Link with Domain</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the print length, the print format and the alignment are taken from the domain definition.</FuncDesc>
			<SimpleSection><Paragraph class="Default">
                                    If this check box is cleared, the print length, the print format and the alignment can be specified by the user.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv334.plen"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Print Length</Title>
			</Header>
			<FuncDesc>The length of the report field.</FuncDesc>
			<DefaultValue><SectionTitle>
                                    Default value
                                 </SectionTitle>
				<Paragraph class="Default">If the <GUIRef href="/baanerp/tt/adv/ttadv3134s000#ttadv334.link" role="manual">Link with Domain</GUIRef> check box is selected, the length of the specified domain. If there is no link with the domain, the print length can be given by the user.</Paragraph>
			</DefaultValue>
		</FieldHelp>
		<FieldHelp ID="ttadv334.difo"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Print Format</Title>
			</Header>
			<FuncDesc>The print format of the report field. You can fill the print format if there is no link with a domain. The print format can be used for the data types byte, integer, long, double, float, string (with only digits) and date.</FuncDesc>
			<DefaultValue><SectionTitle>
                                    Default value
                                 </SectionTitle>
				<Paragraph class="Default">The print format that is defined in the domain definition.</Paragraph>
			</DefaultValue>
			<SimpleSection><Paragraph class="Default">Depending on the <GUIRef href="/baanerp/tt/adv/ttadv3134s000#cdom.type" role="manual">Domain</GUIRef> type of the report field there are three different formats.</Paragraph>
				<List><ListIntro>DATE For data type is date, the following print format can be used:</ListIntro>
					<ListItem>%D&lt;format code&gt;</ListItem>
					<ListItem>%-n.nD&lt;format code&gt; The form of this format is defined in the <GUIRef href="/baanerp/tt/adv/ttadv4580m000" role="session">Date Formats (ttadv4580m000)</GUIRef> session. Refer to the description of the <Emphasis>sprintf$</Emphasis> function in the <DocRef>ERP LN 6.1 Programmer's Guide</DocRef> for all possibilities.</ListItem>
				</List>
				<Paragraph class="Default">DOUBLE or FLOAT If the data type of the report field is double or float, a special amount defined in the <GUIRef href="/baanerp/tt/adv/ttadv4585m000" role="session">Formats (ttadv4585m000)</GUIRef> session can be specified using %A&lt;format code&gt; or %-n.n&lt;format code&gt;. Refer to the description of the <Emphasis>sprintf$</Emphasis> function in the <DocRef>ERP LN 6.1 Programmer's Guide</DocRef> for all possibilities.</Paragraph>
				<Paragraph class="Default">BYTE, INTEGER, LONG, FLOAT, DOUBLE or STRING If the data type of the report field is byte, integer, long, float, double or string the following special characters can be used defining the print format of the field: Z9+-*TVD. Refer to the description of the <Emphasis>edit$</Emphasis> function in the <DocRef>ERP LN 6.1 Programmer's Guide</DocRef> for all possibilities.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">If a number on the field does not fit in the print format, the field is filled with overflow characters.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv334.adju"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Alignment</Title>
			</Header>
			<FuncDesc>This field indicates whether the contents of the report field must be adjusted or not.</FuncDesc>
			<SimpleSection><Paragraph class="Default">If the <GUIRef href="/baanerp/tt/adv/ttadv3134s000#ttadv334.link" role="manual">Link with Domain</GUIRef> check box is selected, the alignment can not be changed.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv334.tmin"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Minimum of textlines</Title>
			</Header>
			<FuncDesc>The minimum number of text lines the layout contains. If this value is zero, the report manager computes the right value. With this field you can control the size of the text on the layout of the report.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv334.tmax"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Maximum of textlines</Title>
			</Header>
			<FuncDesc>The maximum number of text lines the layout contains. If this value is zero, the report manager computes the right value. With this field you can control the size of the text on the layout of the report.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv334.dcex"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Lang/Curr.(expr)</Title>
			</Header>
			<FuncDesc>This field is only applicable if the value of the <GUIRef href="/baanerp/tt/adv/ttadv3134s000#ttadv334.pexp" role="manual">Print Expression</GUIRef> field is <GUIRef href="/baanerp/tt/domains/adv.type#enumerated" role="option">Enumerated</GUIRef>, <GUIRef href="/baanerp/tt/domains/adv.type#float" role="option">Float</GUIRef>, <GUIRef href="/baanerp/tt/domains/adv.type#double" role="option">Double</GUIRef> <GUIRef href="/baanerp/tt/domains/adv.type#date" role="option">Date</GUIRef> or <GUIRef href="/baanerp/tt/domains/adv.type#text" role="option">Text</GUIRef>.</FuncDesc>
			<DefaultValue><SectionTitle>
                                    Default value
                                 </SectionTitle>
				<List><ListItem>If <GUIRef href="/baanerp/tt/adv/ttadv3134s000#ttadv334.pexp" role="manual">Print Expression</GUIRef> field is <GUIRef href="/baanerp/tt/domains/adv.type#date" role="option">Date</GUIRef>, the sequence of year, month, week and day will be printed in the order as specified for the language of the report. You can overrule this by specifying another language in this field. You can do this by specifying an expression for the desired language code or a variable (e.g. a report input field, like tccom010.lang).</ListItem>
					<ListItem>If <GUIRef href="/baanerp/tt/adv/ttadv3134s000#ttadv334.pexp" role="manual">Print Expression</GUIRef> field is <GUIRef href="/baanerp/tt/domains/adv.type#float" role="option">Float</GUIRef> or <GUIRef href="/baanerp/tt/domains/adv.type#double" role="option">Double</GUIRef>, the display format of the default currency of the company will be used, as specified in the <GUIRef href="/baanerp/tt/aad/ttaad1100m000" role="session">Companies (ttaad1100m000)</GUIRef> session. You can overrule this currency by specifying an expression for the desired currency code on this field. You can do this by using the currency code between quotes (like "pnd") or a variable (e.g. a report input field, like tccom010.ccur).</ListItem>
					<ListItem>If <GUIRef href="/baanerp/tt/adv/ttadv3134s000#ttadv334.pexp" role="manual">Print Expression</GUIRef> field is <GUIRef href="/baanerp/tt/domains/adv.type#enumerated" role="option">Enumerated</GUIRef> or <GUIRef href="/baanerp/tt/domains/adv.type#text" role="option">Text</GUIRef>, the text or the enumerate-description will be printed in the language of the report. You can overrule this by specifying another language at this field as explained above.</ListItem>
				</List>
			</DefaultValue>
		</FieldHelp>
		<FieldHelp ID="ttadv334.supp"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Suppr. Ident. Values</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the value of the print expression will only be printed, when it changes. This possibility is especially important for detail lines. The system will not suppress printing at a new page, or if the value of one of the sort fields change. In the <GUIRef href="/baanerp/tt/adv/ttadv3134s000#ttadv334.sfld" role="manual">Sort Field</GUIRef> field you can specify a sort field, related to this field. When the value of this sort field changes, printing of the print expression will not be suppressed.</FuncDesc>
			<SimpleSection><Paragraph class="Default">
                                    If this check box is cleared, the value of the print expression is always printed in the layout field.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv334.aggf"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Aggregate Function</Title>
			</Header>
			<FuncDesc>Special operations on the print expression can be done with use of an aggregate function. These functions always refer to a group of records, depending on the layout type: footer - All records on a page. after.field - All records where the specified sort field has the same value. after.report - All records of the report. Example if you use a COUNT in an "after.report" layout, it counts all records of the report. A COUNT in a "after.field" layout counts all records where the specified sort field has the same value. A COUNT in a "footer" layout counts all records on the same page.</FuncDesc>
			<SimpleSection><Paragraph class="Default">If an aggregate function can not be applied to all values of the print expression, you can use the <GUIRef href="/baanerp/tt/adv/ttadv3134s000#ttadv334.agge" role="manual">Aggregate Expression</GUIRef> field to specify a condition for what values must be taken into account.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv334.pcon"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Print Condition</Title>
			</Header>
			<FuncDesc>The condition which is evaluated at runtime. When this condition is true the print expression will be printed. This condition can contain any 3 GL expression. It is also allowed to use report script and report input variables in the print condition. With '$$' you can substitute the runtime value of the print expression.</FuncDesc>
			<SimpleSection><SectionTitle>Examples</SectionTitle>
				<List><ListItemHead>1</ListItemHead>
					<ListItem>Print expression will always be printed</ListItem>
					<ListItemHead>x &gt; 0 and y &gt; 0</ListItemHead>
					<ListItem>Print expression will be printed if variable x &gt; 0 and variable y &gt; 0</ListItem>
					<ListItemHead>$$ &gt; 0</ListItemHead>
					<ListItem>Print expression will be printed if the value of the print expression is larger than 0</ListItem>
				</List>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv334.pf"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Report Field Font</Title>
			</Header>
			<FuncDesc>The font of the report field. You can specify standard font types or you can define font types yourself. These fonts can be defined in the printer information files of the printer that is used.</FuncDesc>
			<RelatedTopics><SectionTitle>
                                    Related topics
                                 </SectionTitle>
				<RelTopic>Printer Information Files</RelTopic>
			</RelatedTopics>
		</FieldHelp>
		<FieldHelp ID="ttadv334.colr"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Color</Title>
			</Header>
			<FuncDesc>The color of the report field.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv334.cfbo"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Bold</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the report field is printed bold.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv334.cfre"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Reverse</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the background of report field is printed in the specified color and the characters are printed white.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv334.cful"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Underlined</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the report field is printed underlined.</FuncDesc>
		</FieldHelp>
	</Fields>
</Session>
