# Matrix Form!!

**URL:** <https://www.dynamicsuser.net/t/matrix-form/18444>\
**Category:** Developers Forum\
**Created:** [February 20, 2008, 6:46am UTC](https://www.dynamicsuser.net/t/matrix-form/18444 "2008-02-20T06:46:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kiLL6](https://avatars.discourse-cdn.com/v4/letter/k/43a26b/32.png) [@kiLL6](https://www.dynamicsuser.net/u/kiLL6)\
**Post date:** [February 20, 2008, 6:46am UTC](https://www.dynamicsuser.net/t/matrix-form/18444/1 "2008-02-20T06:46:57Z")

</div>

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?[:D]

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 in the reports or Export to Excel…just asking for Idea how to do it…but if you have done It can i download it?[:D]

Hoping for your reply…TY

---

<div class="post-metadata">

**Author:** ![rkjais75](https://avatars.discourse-cdn.com/v4/letter/r/46a35a/32.png) [@rkjais75](https://www.dynamicsuser.net/u/rkjais75)\
**Post date:** [February 20, 2008, 11:34am UTC](https://www.dynamicsuser.net/t/matrix-form/18444/2 "2008-02-20T11:34:49Z")

</div>

Have a look on FORM - 7117 (Sales Analysis Report).

It may help you to achieve your requirement.
