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

Aggregation in reports

Aggregate functions are very useful in SSRS reports in AX R3 to calculate the aggregate values that show the numeric data. Totals are an obvious need in all reports. For example, the sum aggregate function calculates the total of transaction amounts. SSRS provides easy and powerful aggregation capabilities. This recipe will discuss a couple of aggregation methods and how they can be applied at different levels.

How to do it…

In this recipe two aggregations will be implemented:

  • Total value of transactions per customer
  • Count of the total number of transactions per customer

To define the total value of transactions implement the following steps:

  1. Navigate to the Data | AmountMst node.
  2. Set the Aggregation Function property to Sum

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