- 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.
推薦閱讀
- 一本書學(xué)內(nèi)部審計：新手內(nèi)部審計從入門到精通
- 新形勢下中國投入產(chǎn)出核算的變革與實踐
- 審計學(xué)
- Citrix XenApp? 7.5 Desktop Virtualization Solutions
- Magento 2 Cookbook
- Mastering System Center Configuration Manager
- 讓財報說話：世界500強(qiáng)CFO帶你輕松讀財報（鮮讀版）
- Business Intelligence with MicroStrategy Cookbook
- 財務(wù)審計實務(wù)指南
- 非線性經(jīng)濟(jì)關(guān)系的建模
- vSphere Design Best Practices
- IBM SPSS Modeler Cookbook
- 企業(yè)并購審查中的相關(guān)市場界定：理論與案例
- 項目管理實務(wù)（第二版）
- Learn Power Query