- Microsoft Dynamics AX 2012 Reporting Cookbook
- Kamalakannan Elangovan
- 291字
- 2021-08-06 16:40:48
Adding ranges to the report
Ranges play a crucial role in reports as they try to limit the amount of data that appears and makes it much more interactive. In this part of the recipe, we will see how we can easily expose a query field as a range in the report.
How to do it...
The following steps will help you add ranges to the report:
- Open the PKTReleasedProduct query in AOT.
- Drag the field Name Alias to the Range node in AOT.
- In the Visual Studio project right-click on Datasets and click on Refresh.
- The parameter
Products_DynamicParametercollectively represents any parameters that will be added dynamically through the ranges. This parameter must be set toTrueto make additional ranges available during runtime. This adds a Select button to the report dialog, which the user can use to specify additional ranges other than what is added:
- Right-click on the auto design ReleasedProducts and select Preview. The preview should display the range that was added in the query.
How it works...
The report dialog uses the query service UI builder to translate the ranges and to expose additional ranges through the query.
Dynamic parameter: Dynamic parameter unanimously represents all the parameters that are added at runtime. This adds the Select button to the dialog from where the user can invoke an advanced query filter window, which can be used to add more ranges and sorting. The dynamic parameter is available per dataset and can be enabled or disabled by setting the Dynamic Filter property to true or false.
The Report wizard in AX 2012 still uses the MorphX reports to auto-create reports using the wizard. The auto-report option that is available on every form uses the new AX SSRS report.
- 金融科技（FinTech）發展的國際經驗和中國政策取向（中國金融四十人論壇書系）
- 審計學基礎
- 注冊會計師全國統一考試專用教材：審計
- 國家治理能力視角的國家審計功能理論研究
- vSphere Design Best Practices
- 從零開始學房地產會計
- 行政單位經濟責任審計實務指南
- Getting Started with Microsoft Lync Server 2013
- 內審兵法
- Oracle Primavera Contract Management，Business Intelligence Publisher Edition v14
- INSTANT IBM Lotus Notes 8.5.3 How-to
- 統計原理與實務
- Force.com Tips and Tricks
- 汪博士解讀PMP?考試（第6版）
- 2014年注冊會計師（CPA）全國統考專用輔導教材系列：審計（名師解讀版）