Extended Data Type Properties
Extended data type (EDT) properties are divided into the following groups:
-
Common to all EDTs
-
Available only for certain base data types
The following properties are related to report models that are used to add information to a report. For more information see, How to: Generate a Model for an Ad Hoc Report (MorphX Reporting Tools).
-
AnalysisDefaultSort
-
AnalysisDefaultTotal
-
AnalysisGrouping
-
AnalysisUsage
-
FormatMST
|
Property |
Description |
|---|---|
|
Alignment |
Changes the alignment of the text (Left, Right, Center). |
|
AnalysisDefaultSort |
Specifies the default sort order for a field in a report model with this EDT. For more information about report models, see "Generate and publish report models" in the Help menu for System and Application Setup. |
|
AnalysisDefaultTotal |
Determines the aggregate function for a measure. Use this property when AnalysisUsage is set to Measure. You can specify one of the following values.
The aggregate function can be overridden at the field level. That is, you can change the aggregate function for the field using the AnalysisDefaultTotal property for the field. |
|
AnalysisGrouping |
Specifies whether a field with this EDT is grouped by default when the field is added to a report using the Report Builder for Microsoft SQL Server Reporting Services. The property is automatically set to Discouraged for currency amounts. For other fields that are unique, you should set the property to Discouraged. For more information about report models, see "Generate and publish report models" in the Help menu for System and Application Setup. |
|
AnalysisUsage |
Identifies the role of the extended data type in a cube. This setting is automatically propagated to all table fields that reference the extended data type. However, the setting can be overridden on the table field. Specify one of the following values.
Note
Extended data types that are based on enumerations cannot be measures.
|
|
ArrayLength |
Read-only property. By default, the ArrayLength is 1. To add array elements to the EDT, right-click the Array Element node and select New Array Element. The value of the ArrayLength property will increase to reflect this. |
|
ButtonImage |
Specifies the image to be displayed when the EDT is used for a lookup button on a form. The possible values are:
|
|
CollectionLabel |
Specifies the label that is used to display the plural name of a field with this EDT. |
|
ConfigurationKey |
Specifies the configuration key for the EDT. |
|
CreatedBy, CreationDate, CreatedTime, ChangedBy, ChangedDate, ChangedTime, LockedBy |
Read-only properties. |
|
DisplayLength |
Specify a maximum number of characters to be displayed in a form or report. |
|
Extends |
Enables you to base the EDT on another EDT. |
|
FormHelp |
Specifies a form to be used when performing lookup from a field in a form. |
|
HelpText |
Creates a Help string for the EDT. The Help string is displayed when the type is used in a form. |
|
ID |
Read-only property. |
|
Label |
Specifies a label for the type that is shown when the type is used in a form or report. |
|
Name |
Specifies the name of the type. The name is used when referring to the type from X++. |
For rules and hints about setting these properties, see Best Practice for extended data types.
Leave these properties set to Auto unless specified otherwise in the following table.
|
Property |
Exists for these types: |
Description |
|---|---|---|
|
Adjustment |
String |
For fixed length strings, this specifies whether the entered characters will be stored on the left or the right side of the padding spaces. Values are Left or Right. The default is Left. |
|
AllowNegative |
Integer Int64 Real |
Specifies whether the field can accept negative values. |
|
AutoInsSeparator |
Real |
Specifies whether the system inserts a decimal separator automatically. For example, if you enter 2222, the system automatically shows 2222.00. |
|
ChangeCase |
String |
Specifies how text entered in a string control should be formatted. For example, the text can be formatted as upper case, or with title capitalization. |
|
DateDay |
Date UtcDateTime |
Specifies how the day should be displayed. |
|
DateFormat |
Date UtcDateTime |
Specifies the layout of a date. |
|
DateMonth |
Date UtcDateTime |
Specifies how the month should be displayed. |
|
DateSeparator |
Date UtcDateTime |
Specifies the separators between year, month, and day. |
|
DateYear |
Date UtcDateTime |
Specifies how the year should be displayed. |
|
DecimalSeparator |
Real |
Specifies the decimal separator. The default (Auto) setting is whatever is specified in your system setup. |
|
DisplaceNegative |
Integer Int64 Real |
Specifies if negative numbers should be indented to the left. |
|
DisplayHeight |
String |
Specifies the number of lines to be displayed simultaneously when the EDT is displayed in a form. |
|
EnumType |
Enum |
Specifies the base enum used to create the EDT. |
|
FormatMST |
Real |
Specifies how to format master currency values. The following list contains the possible values for this property:
|
|
NoOfDecimals |
Real |
Determines the number of decimals when a value displays on a form or a report. |
|
RotateSign |
Integer Int64 Real |
Choose this to negate the number, that is, change - to + and + to -. |
|
ShowZero |
Integer Int64 Real |
Specifies whether the value zero should be shown as an empty field. If the value zero in fields of this type means null/nothing, ShowZero set to No. |
|
SignDisplay |
Integer Int64 Real |
Specifies whether the sign of a number should be displayed, if it is a negative number, and also whether the sign should be before or after the number. Normally set to Auto. Can be set to None if used with DisplaceNegative. |
|
StringSize |
String |
Specifies the maximum size of the string. |
|
ThousandSeparator |
Real |
Specifies the thousand separator. |
|
TimeFormat |
Time UtcDateTime |
Specifies how times should be formatted. |
|
TimeHours |
Time UtcDateTime |
Specifies whether hours should be included. |
|
TimeMinute |
Time UtcDateTime |
Specifies whether minutes should be included. |
|
TimeSeconds |
Time UtcDateTime |
Specifies whether seconds should be included. |
|
TimeSeparator |
Time UtcDateTime |
Specifies the separator to be used when displaying times. |
|
TimezonePreference |
UtcDateTime |
Specifies the time zone that the value should be converted to from Coordinated Universal Time (UTC). For more information, see Form Control Properties. |
Note