Axapta : Report Properties

Report

Property	Type/Section		Description
Report
Name		=	AOT name of the report.
AllowCheck		=	If set Configuration keys and Security keys will be validated at runtime.
Autojoin		=	Joins the reports query with the caller. If the report is called from a form,
			the report will be joined with the called record.
Interactive		=	Specify whether the dialog is shown to the user at runtime.

Report design
Name		=	Name of the design. Used to identify the design, if the report have more
			than one design.
AutoDeclaration		=	If set to Yes, the report design node referred from X++ by using the section
			name.
Caption		=	Caption for the report. If the standard report template InternalList is used,
			caption will be used to print the name of the report in the header.
Description		=	Will be printed in the top bar of the print to screen window. If not specified,
			the Caption text is printed instead.
JobType		=	Can be used to identify the design. JobType is not printed.
EmptyReportPrompt		=	Specify a text to be printed in the Infolog, if the report is empty. If not used,
			the default text is printed.
ArrangeWhen		=	Specify when the controls in the design must be arranged.
ColorScheme		=	Specify whether to use RGB colors, or Windows color scheme.
ForegroundColor		=	RGB value or name of Windows color scheme item.
ResolutionX		=	Seems as having no effect.
ResolutionY		=	Seems as having no effect.
Ruler		=	Used to set the measure units for the visual designer.
ReportTemplate		=	Choose a report template to be used for the design.
TopMargin		=	Set the top margin for the design.
BottomMargin		=	Set the bottom margin for the design.
LeftMargin		=	Set the left margin for the design.
RightMargin		=	Set the right margin for the design.
Language		=	Set a fixed language for the design. If not set the users default language will
			be used.
Font		=	The font to be used for the design. If not specified the default font is used.
FontSize		=	The font size to be used for the design. If not specified the default font size
			is used.
Italic		=	Set the design to italic.
Underline		=	Underline text in the design.
Bold		=	Set the design to bold.
PrintFormName		=	The application form used for the printer dialog. If the report is called using
			the report runbase framework, this form is not used.
HideBorder		=	Skip printing labels and lines around controls.
Orientation		=	Fix orientation to portrait or landscape. A design will default be printed
			landscape, if the there are too many controls to fit portrait without scaling.
FitToPage		=	Determine whether to scale the report, if the controls cannot fit in the width
			of the report.
RemoveRepeatedHeaders		=	Skip headers where no records are printed for the header.
RemoveRepeatedFooters		=	Skip footers where no records are printed for the footer.
RemoveRedundantFooters		=	Skip printing sum footers if only one record is to be summed.

Auto design
GrandHeader		=	Defines whether to print a header text at sorting breaks. This header text is
			identified as super grand header, and will be printed before the grand
			header which can be set at the body section.
GrandTotal		=	Will print a super grand total for controls where the property SumAll,
			SumPos or SumNeg is set.
HeaderText		=	This text will be printed as header text at sorting breaks if GrandHeader is
			set to Yes. If no text has been entered, the default test will be printed.
TotalText		=	If GrandTotal is set to Yes, this text will be printed as super grand total text,
			instead of the default text.

Sections controls
ArrangeMethod	All	=	Set the orientation for the arranged
			controls.
ArrangeWhen	All	=	Specify when the controls in the section
			must be arranged.
AutoDeclaration	ProgrammableSection	=	If set to Yes, the section can be referred
	Body		from X++ by using the section name.
	PageFooter
Bold	All	=	Set the bold level for headings and data in
			the section.
Bottom	ProgrammableSection	=	Set a fixed position for the section
	Prolog		calculated from the bottom of the page.
	Body
	Epilog
BottomMargin	All	=	Set the margin below the section data.
ColorScheme	All	=	Specify whether to use RGB colors, or
			Windows color scheme.
ColumnHeadingsStrategy	ProgrammableSection	=	Define whether labels must be word
	Body		wrapped or printed staggered. If set to
	PageFooter		DisplacedLines, the heading labels will be
			printed staggered on two lines, if the labels
			cannot be fit on a single line.
Columns	All	=	This property has no function. Used on
			forms to define the number of columns for
			arranging sub controls.
Columnspace	All	=	Set the space between columns.
ControlNumber	ProgrammableSection	=	The identification for a programmable
			section. Used to execute the section from
			X++.
Font	All	=	The font to be used for the section. If not
			specified the default font is used.
FontSize	All	=	The font size to be used for the section. If
			not specified the default font size is used.
FooterText	Body	=	Only available in auto designs. This text
			will be printed as grand total text, instead
			of the default text.
ForegroundColor	All	=	RGB value or name of Windows color
			scheme item.
GrandHeader	Body	=	Only available in auto designs. Defines
			whether to print a header text at sorting
			breaks.
GrandTotal	Body	=	Only available in auto designs. Will print a
			grand total for controls where the property
			SumAll, SumPos or SumNeg is set.
HeaderText	Body	=	Only available in auto designs. This text
			will be printed as header text at sorting
			breaks. If not text entered, the default test
			will be printed.
Height	All	=	Set a fixed height for the section.
Italic	All	=	Set the font to italic for headings and data
			in the section.
LabelBottomMargin	ProgrammableSection	=	Set the margin below the heading labels,
	Body		and before section data.
	PageFooter
LabelTopMargin	ProgrammableSection	=	Set the margin above the heading labels.
	Body
	PageFooter
LeftMargin	All	=	Left margin for the section.
LineAbove	All	=	Add a line above the section data.
LineBelow	All	=	Add a line below the section data.
LineLeft	All	=	Add a line to the left of the section data.
LineRight	All	=	Add a line to the right of the section data.
Name	All	=	The name of the section. This is the name
			used from X++ to refer to the section,
			when the property AutoDeclaration is set.
NoOfHeadingLines	ProgrammableSection	=	Labels are printed as heading lines. Used
	Body		to set NoOfHeadingLines to a fixed value.
	PageFooter		Set to zero if no header should be printed.
ResolutionX	All	=	Seems as having no effect.
ResolutionY	All	=	Seems as having no effect.
RightMargin	All	=	Right margin for the section.
Ruler	All	=	Used to set the measure unit for the
			current section in the visual designer.
Table	Body	=	Used by element.send() to determine
			which body sections to be printed.
Thickness	All	=	Set thickness of the lines added for the
			section data.
Top	ProgrammableSection	=	Set a fixed position for the section
	Prolog		calculated from the top of the page.
	Body
	Epilog
TopMargin	All	=	Set the margin above the section data.
Underline	All	=	Underline headings and data in the
			section.

Section Template
SectionTemplate		=	Name of the section template.
Table		=	The table used for the section template. The table must a part of the map
			used for the section template.

Section Group
DataField		=	Can be used to identify a section group if a report contains two section
			group using the same table.
Name		=	Name of the section group.
Table		=	The table used in the section group. Used by element.send() to determine
			when to print the section group.

Type controls
Alignment	String	=	Align the control data. Can be used to left
	Real		align control data, when controls are
	Integer		positioned vertical.
	Enum
	Date
	Time
	Sum
	Bitmap
	Prompt
AllowNegative	Real	=	This property is of no use on reports. The
	Integer		property is used on forms to prevent
	Sum		negative values to be entered by the user.
ArrayIndex	String	=	If the selected field or method is an array a
	Real		single element of the array can be
	Integer		specified to be printed only.
	Enum
	Date
	Time
	Sum
	Bitmap
	Prompt
AutoDeclaration	All	=	If set to Yes the properties for the control
			can be referenced from X++ by using the
			control name.
AutoInsSeparator	Real	=	Used to have MorphX to set a decimal
	Sum		separator.
BackgroundColor	String	=	RGB value or name of Windows color
	Text		scheme item.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
BackStyle	String	=	Set the background for the control to
	Text		transparent. Used if the background color
	Real		of bitmaps should not be shown, or to set
	Integer		the color of the background for the control
	Enum		data to the color set with the property
	Date		BackGroundColor.
	Time
	Sum
	Bitmap
	Prompt
Bold	String	=	Set the bold level for control data.
	Text
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
BottomMargin	All	=	Set the margin below the controls data.
ChangeCase	String	=	Used to set the control data to lower case
	Text		or upper case.
	Enum
	Prompt
ChangeLabelCase	String	=	Used to set the label to lower case or
	Real		upper case.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
ColorScheme	All	=	Specify whether to use RGB colors, or
			Windows color scheme.
ConfigurationKey	All	=	Used to specify a Configuration Key for
			the control.
CssClass	All	=	Web property.
DataField	String	=	Select a field from the selected data
	Real		source. Instead of selecting a field, a
	Integer		display method can be specified in the
	Enum		property DataMethod.
	Date
	Time
	Sum
	Bitmap
	Prompt
DataFieldName	Sum	=	Name of the control to be summed.
DataMethod	String	=	Select a display method to be printed. If
	Real		the display method is from a table, the
	Integer		data source must be specified in the
	Enum		property Table.
	Date
	Time
	Bitmap
DateDay	Date	=	Specify how day is shown. Windows
			regional settings are used as default.
DateFormat	Date	=	Set the date format. Windows regional
			settings are used as default.
DateMonth	Date	=	Specify how month is shown. Windows
			regional settings are used as default.
DateSeparator	Date	=	Set the date separator. Windows regional
			settings are used as default.
DateYear	Date	=	Specify how year is shown. Windows
			regional settings are used as default.
DecimalSeparator	Real	=	Specify the decimal separator. Windows
	Sum		regional settings are used as default.
DisplaceNegative	Real	=	Adjust the position of negative values
	Integer		printed.
	Sum
DynamicHeight	String	=	If set to Yes the height will be set
			according to the text.
ExtendedDataType	String	=	Specify an extended data type for the
	Text		control if a DataField or a DataMethod is
	Real		not specified.
	Integer
	Enum
	Date
	Time
	Prompt
ExtraSumWidth	Real	=	Defines extra space for the summed value.
	Integer		Useful in currencies with a lot of digits.
	Sum
Font	String	=	The font to be used for the control data. If
	Text		not specified the default font is used.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
FontSize	String	=	The font size to be used for the control
	Text		data. If not specified the default font size
	Real		is used.
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
ForegroundColor	All	=	RGB value or name of Windows color
			scheme item.
FormatMST	Real	=	Format the value using the settings for the
	Sum		standard company currency.
Height	All	=	Set a fixed height for the control.
ImageName	Bitmap	=	Path and filename for bitmap.
ImageRessource	Bitmap	=	Used to specify a resource id for the
			bitmap. Use the report
			Tutorial_Resources to get an overview
			of the resource id’s.
Italic	String	=	Set the font to italic for the control data.
	Text
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
Label	All	=	Used to override the default label or if no
			DataField or ExtendDataType is specified.
			The label will not be printed, if the
			property ShowLabel is set to false.
LabelBold	String	=	Set the label to bold.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelCssClass	All	=	Web property.
LabelFont	String	=	Set the font for the label. If not specified
	Real		the default font will be used.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelFontSize	String	=	Set the font size for the label. If not
	Real		specified the default font size will be used.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelItalic	String	=	Set the label to Italic.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelLineBelow	String	=	Print a line with the width of the control
	Real		below the label.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelLineThickness	String	=	Set the thickness of the line below the
	Real		label.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelPosition	String	=	Position the label above or to the left.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelTabLeader	String	=	Used when the property LabelPosition is
	Real		et to Left. Put tabs or dots follow by a
	Integer		colon after the label.
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelUnderline	String	=	Underline the label text. The property
	Real		LabelLineBelow is used to set a line
	Integer		below in the full width of the label.
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
LabelWidth	String	=	Used when the property LabelPosition is
	Real		set to Left. Set a fixed width for the label.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
Left	All	=	Set the control to a fixed position
			calculated from left. If controls are
			horizontal aligned and one control is set to
			a fixed position, all controls must be fixed.
LeftMargin	All	=	Set a left margin for the control.
Line	Shape	=	Specify the line type for the shape.
LineAbove	All	=	Add a line above the control data.
LineBelow	All	=	Add a line below the control data.
LineLeft	All	=	Add a line to the left of the control data.
LineRight	All	=	Add a line to the right of the control data.
MenuItemName	All	=	Web property.
MenuItemType	All	=	Web property.
ModelFieldName	All	=	Enter the name of a control which this
			control must be position according to. Is
			often used to position prompt and sums
			controls to be on line with the data
			controls.
Name	All	=	Name of the control.
NoOfDecimals	Real	=	Set the number of decimals to be shown.
	Sum
ResizeBitmap	Bitmap	=	Used to resize the bitmap if a fixed width
			and height is specified for the bitmap.
RightMargin	All	=	Set a right margin for the control.
RotateSign	Real	=	Used to invert negative values.
	Integer
	Sum
SecurityKey	All	=	Used to specify a Security Key for the
			control.
ShowLabel	String	=	If set to No, the label will not be printed.
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Shape
ShowPicAsText	Bitmap	=	Print the image path or the resource id
			instead of printing the bitmap.
ShowZero	Real	=	Defines whether zero values must be
	Integer		shown.
	Sum
SignDisplay	Real	=	Set how to display negative values.
	Integer
	Sum
SumAll	Real	=	Sum all values. Used by sum controls to
	Integer		define which controls to be summed. If set
			in auto design, the control will be summed
SumNeg	Real	=	if the user add a group total in the dialog.
	Integer		Set if only negative values should be
			summed.
SumPos	Real	=	Set if only positive values should be
	Integer		summed.
SumType	Sum	=	Set to sum only positive or negative
			values.
Table	String	=	Select a data source to be used for the
	Real		control.
	Integer
	Enum
	Date
	Time
	Sum
	Bitmap
	Prompt
Text	Text	=
Thickness	All	=	Enter the text to be printed.
			Set thickness of the lines added for the
			control data.
ThousandSeparator	Real	=	Specify the thousand separator. Windows
	Sum		regional settings are used as default.
TimeFormat	Time	=	Set the time format. Windows regional
			settings are used as default.
TimeHours	Time	=	Specify whether to show hours. Windows
			regional settings are used as default.
TimeMinute	Time	=	Specify whether to show minutes.
			Windows regional settings are used as
			default.
TimeSeconds	Time	=	Specify whether to show seconds.
			Windows regional settings are used as
			default.
TimeSeparator	Time	=	Set the time separator. Windows regional
			settings are used as default.
Top	All	=	Set a fixed position for the control
			calculated from the top of the section. If
			controls are horizontal aligned and one
			control is set to a fixed position, all
			controls must be fixed.
TopMargin	All	=	Set the margin above the controls data.
Type	Shape	=	Set the type of shape to be printed.
TypeHeaderPrompt	Text	=	Specify whether to put following dots and
	Prompt		a colon after the text.
Underline	String	=	Underline the control data.
	Text
	Real
	Integer
	Enum
	Date
	Time
	Sum
	Prompt
Visible	All	=	Used to hide the control. If the follow
			controls are auto positioned, the controls
			will be adjusted.
WarnIfMissing	Bitmap	=	Print a warning in the Infolog if the
			bitmap cannot be located from the
			ImageName, ImageRessource or the
			DataMethod.
WebTarget	All	=	Web property.
Width	All	=	Set a fixed width for the control. If set to
			default, the extended data type will set the
			width.
Field Group
AutoFieldGroupOrder		=	Determine whether properties and field order must be saved. The field
			group will automatically be updated according to changes made to the field
			group from the data dictionary.
DataGroup		=	Field group name.
Table		=	Table from which the field group is picked.

Written by Komkid on August 18th, 2009 with no comments.
Read more articles on Axapta.

[+] Digg: Feature this article
[+] Del.icio.us: Bookmark this article
[+] Furl: Bookmark this article

Related articles

Axapta : Execute SQL command (October 20th, 2010)
Axapta : Find user group of current userid (October 20th, 2010)
Axapta : Posting journal by code (February 11th, 2010)
Axapta : Firewall config (January 26th, 2010)
Axapta : Detecting Type of Variable (December 15th, 2009)

No comments

There are still no comments on this article.

Leave your comment...

If you want to leave your comment on this article, simply fill out the next form:

You have to be identified to write a comment.