- Microsoft Dynamics AX 2012 Reporting Cookbook
- Kamalakannan Elangovan
- 199字
- 2021-08-06 16:40:48
Grouping in reports
The previous recipe results in a report where all the items are listed sequentially, but to make information more readable it must be structured. Structuring the data simplifies and helps in finding the detail that is needed. Here in this recipe, we will structure the report by grouping the items based on the item group making it easier to navigate.
How to do it...
Reports are grouped in as follows:
- Go to the Dataset and select the itemGroupId field.
- Drag-and-drop it to the Groupings node under the auto design ProductsReport.
- This will create a new grouping node and add the field itemGroupId to the group.
- Each grouping has a header row where even fields that don't belong to the group but need to be displayed in the grouped node can be added. The itemGroupId field is added automatically:
- This groups the record and also acts like a header.
How it works...
The grouping can also be done based on multiple fields. Use the row header to specify the fields that must be displayed in the header. A grouping can be added manually but a drag-and-drop saves a lot of task such as setting the row header.
推薦閱讀
- 中國國民經濟核算體系修訂問題研究
- Mastering Microsoft Forefront UAG 2010 Customization
- 一本書學內部審計：新手內部審計從入門到精通
- 審計學基礎
- 會計信息化基礎（金蝶版）
- 陜西文物年鑒·2015
- Microsoft Dynamics CRM 2011 Scripting Cookbook
- Learning Microsoft Azure
- 審計實務案例與實訓教程
- OAuth 2.0 Identity and Access Management Patterns
- Getting Started with Oracle Tuxedo
- Big Data Analytics with R and Hadoop
- 傳習集2
- 計量經濟學
- Building Dashboards with Microsoft Dynamics GP 2016（Second Edition）