How to: Add or Delete a Field Group in a Data Region
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
When you bind a report to a query that was defined in the AOT, the report framework provides support for field groups. Field groups are objects that group together fields that logically belong together. When a change is made to a field group, the change is reflected in all cases where the field group is used. This means that the change is reflected in the report. For more information on field groups created in Microsoft Dynamics AX, see Defining Field Groups.
When you bind a dataset to a query, you can select one or more field groups that exist on the table referenced in the query. The following procedure explains how to add or delete a field group data region within an auto design.
To bind a dataset to a query
In Model Editor, expand the node for the report to which you want to add a field group.
Right-click the Datasets node, and then click Add Dataset.
Select the node for the dataset.
In the Properties window, specify the following values.
Property
Value
Data Source
Dynamics AX - The data source for the dataset must be set to Dynamics AX if you want to set the data source type to an AX Query.
Data Source Type
Query indicates you will bind the dataset to an AX Query.
Default Layout
The default data region type for the dataset. Table, TopDownList, and HorizontalList layouts will support adding field groups. For more information about data region types, see Report Data Region Overview.
Dynamic Filters
Set the Dynamic Filters property to True to create dynamic filters on your report. When this value is True, a dataset parameter and report parameter will be created. Both of which will have the same name. When the value is False, the dataset parameter and report parameter for the default ranges are created. For more information about creating dynamic filters, see Adding Interactive Features to Reports.
Name
Provide a name for the dataset.
Query
Click the ellipsis button (…). A dialog box displays with the queries that are defined in the AOT. Select a query and then click Next. Expand the field nodes and select fields, field groups, and display methods that you want to use on the report.
Note
The field groups you select in this step will be the field groups you can add to the report design.
Click OK.
Drag the dataset onto the Designs node. An auto design named AutoDesign1 is created for the report.
To add a field group to a data region within an auto design
In Model Editor, expand the node for the data region to which you want to add a field group.
The following table describes the next step to navigate to each of the data region elements to which you can add a field group.
Data region element
How to navigate
Table data
Right-click the Data node for the data region.
Table grouping header
Expand the Groupings node, expand the SubsegmentId > Header node, right-click the Row node.
Table grouping footer
Expand the Groupings node, expand the SubsegmentId > Footer node, right-click the Row node.
List data
Right-click the Data node for the data region.
List grouping header
Expand the Groupings node, expand the SubsegmentId node, right-click the Header node.
List grouping footer
Expand the Groupings node, expand the SubsegmentId node, right-click the Footer node.
Point to Add, and then click Field Group.
In the Properties window, specify the following properties.
Property
Description
DataSetFieldGroupBase
Select the field group to add to the data region. The drop-down contains a list of the field groups that you selected when you bound the dataset to the query.
AutoFieldGroupOrder
Indicates the save status of the fields. Select the drop-down list to display the following options.
Do not save the field properties - Use this option when all the properties of the sub-fields should be read-only. In model editor, expand the field group and select one of the fields. The visibility, text align, and caption will be used from the base field. The default styles and format will be used. Fields cannot be re-ordered.
Save the field properties - Use this option when the properties of the sub-fields should be editable. You can change the properties for each field. The overridden properties are then used when the report displays. Fields cannot be re-ordered.
Save the field properties and order – Use this option when the properties of the sub-fields should be editable and the fields can be re-ordered.
Caption
Enter a Label ID to be used for the field group.
To delete a field group for a data region within an auto design
In Model Editor, expand the node for the data region that contains the field group you want to delete.
Expand the Data node.
Right-click the field group you want to delete, and then click Delete.
When you delete a field group in a data region, it is deleted from the selected data region only.