How to: Add or Delete Fields in a Data Region [AX 2012]
Updated: September 17, 2011
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
You can add or delete fields for a data region in an auto design report. Each data region has a single underlying dataset. If you add a field to a data region, the field must be from the same dataset as the other fields in the data region. The following procedure explains how to add or delete fields in a data region within an auto design.
To add a field to a data region within an auto design
-
In Model Editor, expand the node for the data region that you want to add a field to.
-
To add a field, do one of the following:
-
Drag the field from the dataset, which is located under the Datasets node, onto the Data node for the data region.
- or -
-
Right-click the Data node for the data region, point to Add, and then click Field.
-
Select the node for the field.
-
In the Properties window, specify the following properties.
Property
Description
Expression
An expression that identifies the data to be displayed. From the drop-down list, select an expression that identifies the field you want to display or click <Expression…> to display the Edit Expression dialog box where you can create an expression. For information about creating expressions, see Expression Examples in Reporting Services.
Name
The name of the field.
A data region displays fields from only one dataset. To identify the dataset that is assigned to a data region, select the data region in Model Editor and view the DataSet property in the Properties window.
-
To delete a field for a data region within an auto design
-
In Model Editor, expand the node for the data region that contains the field you want to delete.
-
Expand the Data node.
-
Right-click the field you want to delete, and then click Delete.
When you delete a field in a data region, it is deleted from the selected data region only. It is not deleted from the dataset or any other data regions that display the field.