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,

4 thoughts on “Creating Matrix Reports in Nav 2013 R2”

  1. Thanks alot. Especially about the summing. At first I didnt even think it was possible. In any case, I think you left out the expression for the row/column sum. In my case it is: =Sum(Fields!Time.Value,”PD”) . PD is the name of the group I am summing.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: