O'Reilly logo

Microsoft Dynamics AX 2012 R3 Reporting Cookbook by Deepak Agarwal, Chhavi Aggarwal, Kamalakannan Elangovan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Improving the functionality of reports

Designing a report and making it function better relies on getting it fundamentally right. This recipe will cover some simple steps, which when implemented, can help design a better, faster, and more reliable report.

How to do it…

  1. Use query: Opt to use a query-based report over an RDP-based report wherever possible, and use RDP only if there is a compulsion to use business logic for the query.
  2. Use SSRS for totals: Use the totals functions in SSRS to run totals, and don't calculate them in the RDP logic.
  3. Use relations in RDP: Create relations in an RDP table to get automatic drill through in reports.
  4. Make parameters optional: Remember to set Allow blank to True and Nullable to True for optional report parameters. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required