O'Reilly logo

Microsoft Dynamics AX 2012 Reporting Cookbook by 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

Creating a multicolumn matrix report

This recipe will show how a multicolumn matrix can be implemented. Here we will expand our report to see how we can dissect it into detail where the rows are further split by months following years and the columns will also show the average price other than the quantity.

Getting ready

This recipe requires that you complete the recipe Creating a matrix report in this chapter.

How to do it…

  1. Create a new design as in the previous recipe or extend the design created in the previous recipe with the steps detailed here.
  2. From the Report Data toolbar, drag the control MonthOfYearId1 to the Row Group control next to Year. When you drop it a blue bar appears and it must face the Year column as shown here:
  3. From the Report Data ...

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