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

Creating a multicolumn matrix report

This recipe will show you how a multicolumn matrix can be implemented. Here, we will expand our report to see how we can dissect it in detail, and see how the rows can be split by months, followed by years, and how the columns can show the average price and the quantity.

Getting ready

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

How to do it…

Create a new design as done in the previous recipe, or extend the design created in the previous recipe with the help of the following steps:

  1. From the Report Data toolbar, drag the MonthOfYearId1 control to the Row Group control, which is next to the Year. When you drop, a blue bar appears, and it must face the year column as shown ...

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