- 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.
- 中國新股民必讀手冊（2015年最新版）
- Microsoft Dynamics GP 2016 Cookbook
- Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c
- 基于價值增值的治理導向型內部審計研究
- Splunk：Enterprise Operational Intelligence Delivered
- 博弈論及其在經濟管理中的應用
- SAP ABAP Advanced Cookbook
- 從零開始學房地產會計
- 行政單位經濟責任審計實務指南
- 企業(yè)內部審計全流程指南
- Stata統(tǒng)計分析與行業(yè)應用案例詳解（第2版）
- QlikView for Developers Cookbook
- Instant Windows PowerShell Guide
- 中國重點經濟領域統(tǒng)計分析
- 審計基礎與實務（第二版）