Creating Matrix Reports in Nav 2013 R2

Standard

In this article we are going to see how to create a Matrix Report ,

Matrix reports display grouped data and summary information. You can group data by multiple fields or expressions in row and column groups.A matrix  report grows horizontally and vertically on the page

lets see how to create one  inventory  matrix report based on location  and item

Create one new report with data Item ledger entry

1

Open Visual Studio Report designer add matrix control

1

Select Row group field on Rows and Column Group fields in Column

Now I am selecting Item No as Row Group,  Column group as Location code  and Data as Quantity

3

Report Output

4

next insert Item description row after the item Number ,  Right Click Item No text box and select inside the group right and insert description field in the new text box

5

Insert Row  Total in the report, Right Click Item No text box and select Add Total After

6

Insert  Column Total  in the report,,  Right Click Location text box and select Add Total After

7

Final output grouped by item no and and location

8

you can download sample report from here 

Advertisements