You can modify the properties of an existing attribute within a model.
 |
Caution: Modifying a model may break reports attached to it. See Managing Model Breaking Changes for more information. |
To modify an attribute
- Next to a model in the Models list, click Edit.
- In the model editor that appears, in the Entities list on the left, select the entity whose attribute you want to modify. The properties appear in the workspace and the Attributes and Relations lists populate with any associated attributes and relations.
- In the Attributes list on the right, select the attribute whose properties you want to modify. The properties appear in the workspace.
- In the workspace, change properties as necessary. The table below details the properties that you can change.
Attribute properties
Property Name Type Description (Id) ID A unique identifier for the attribute. Used internally by the system. Name String The name for the attribute. Binding ID The database object that the attribute represents. DataType Enum The data type for the attribute.
DiscourageGrouping Boolean Indicates whether data is grouped by entity instead of by attribute. Format String The default format for the attribute. Hidden Boolean Indicates whether the attribute is hidden from end users. IsAggregate Boolean Indicates whether the attribute is an aggregate. Nullable Boolean Indicates whether the attribute can have a null value and is used in filter and parameter editors to provide special values. ValueSelection Enum Determines what control is used to display attribute values in the filter and parameters editors.
- Dropdown shows lookup values in a dropdown control.
- List shows more values at once than Dropdown.
- None disables the entire lookup process.
By default, ActiveReports 9 Server selects this value based on the UAVC (unique attribute values count):
- Less than 200 - Dropdown
- Between 200 and 1,000 - List
- Otherwise - None
- If the attribute that you are modifying has a list of variations under it such as date parts (e.g. Expense Day, Expense Month) or aggregations (e.g. Total Amount, Avg Amount), that you have modified with format changes or deletions, you can click the Regenerate command at the top right of the Attributes list to generate all of the available variations. Note that the attribute for which you want to regenerate variations must have focus for the Regenerate command to appear.
See Also