Matrix form

Silva

Hi,

Does Anyone have any Idea to make to create a matrix form and then Export that data to excel or show it to reports?

I want to achievd is that to show all the Item Quantity base on the Posted sales Invoice

This is my requirements:

Matrix header is the All item tht trnsact in the base in the posted sales invoice.

Matrix Body is the Quantity of all the item base in posted sales invoice.

The Left Side is the Invoice header(e.g Sales Invoice No...Sell-to Customer..etc)

And I want to show all the data in the reports or Export to Excel....just asking for Idea how to do it..

Hoping for your reply...TY

jlandeen

Form 113 - Budget (and Report 82 - Export Budget To Excel) in base Navision is built on a matrix and has export to excel functionality. These two standard components should give you an indepth example (and possibly give you some code/objects) that you can build a solution on.

At least it may help you get started by heading in the right direction.

kriki

There is also this: http://www.mibuso.com/howtoinfo.asp?FileID=13
You can then start looping the records in the form and in that loop start looping the records in the matrix-record and export all in Excel.