Creating Matrix Reports in Nav 2013 R2

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

Open Visual Studio Report designer add matrix control

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

Report Output

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

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

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

Final output grouped by item no and and location

you can download sample report from here 

Author: Akhilesh E Kartha

Experienced BC Developer with 10 years history of working in the information technology and services industry. Skilled in Microsoft Dynamics NAV & D365 Business Central, Strong experience in C/AL, Extension Development, Requirements Analysis, Effort Estimation, Integrations, Version Upgrade, View all posts by Akhilesh E Kartha