- 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.
推薦閱讀
- Microsoft Dynamics GP 2016 Cookbook
- 審計全流程技術(shù)操作實務(wù)指南
- 自愿審計動機與質(zhì)量研究：基于我國中期財務(wù)報告審計的經(jīng)驗證據(jù)
- 金融科技（FinTech）發(fā)展的國際經(jīng)驗和中國政策取向（中國金融四十人論壇書系）
- Pentaho Business Analytics Cookbook
- 國家治理能力視角的國家審計功能理論研究
- 財務(wù)審計實務(wù)指南
- 大數(shù)據(jù)搜索與挖掘及可視化管理方案 ：Elastic Stack 5：Elasticsearch、Logstash、Kibana、X-Pack、Beats （第3版）
- Learning Microsoft Azure
- 振蕩指標MACD：波段操作精解（升級版）
- 風險導向?qū)徲嫓蕜t實施效果研究
- 行政單位經(jīng)濟責任審計實務(wù)指南
- 2017年度注冊會計師全國統(tǒng)一考試專用教材（圖解版）：審計
- Learn Power Query
- Oracle E-Business Suite Financials R12：A Functionality Guide