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

3 thoughts on “Creating Matrix Reports in Nav 2013 R2

Leave a Reply

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

WordPress.com Logo

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

Google+ photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s