Wednesday, August 19, 2009

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.

No comments: