Report in Matrix FORM

Dear all,

How can I print the Sale Order Test Report/Purchase Order Test Report in the below format ?
4628.Matrix _Test Document.JPG

Kindly reply.

Perhaps this can be done in NAV 2009 SP1, for details read the following blog:

http://blogs.msdn.com/nav-reporting/archive/2009/08/28/building-a-matrix-report-in-microsoft-dynamics-nav-2009-sp1.aspx

But I’m in NAV 5.0 SP1.

I am not sure if something like this can be done in nav 5.

Perhaps something like this is there in LS Retail database…

It should be done with the help of ARRAY…

can be done with array, as subrata bauri mentioned. but the problem of array is limited to data dimension that you set for array. e.g. you set item[10], but then you have 11 item lines in you docs, the 11th can not show up, and you will need to go back to modify your report.

But you can specify a large array length…

The question I have though is what is the difference between the way you have this, the columns are data and the rows are “fields”, and having the rows as field and columns are data?

I haven’t run the report you talk about, but looking at the X and Y you have here, if you reverse them its basically a list form… am I missing something?

What you are missing is that the client asked for it like this, and the partner just said “Yes can do” without questioning the logic or suggesting a better solution.