How To create a Matrix-form in Navision?

Administrator · **Posted:** Fri Mar 17, 2006 2:04 pm

How To create a Matrix-form in Navision?

http://www.mibuso.com/howtoinfo.asp?FileID=13

Discuss this How To here.

slowhandfan · **Posted:** Wed Apr 11, 2007 7:24 pm

I found this HOW TO to be very useful and helpful in creating Matrix forms... Almost indispensible

However, the only gliche that it seems to have is when you roll from record to record using the NEXT or PREV button, sometimes your data in the Matrix below comes up shifted all the way left with the final column in the matrix appeargin in Cell 1. You then have to press the horizontal positioning bar a couple times to shift it back so the first Column of data is in Column1 and the 2nd column of data is in column 2 etc...

Apart from this, the structure seems to be very stable, and easy to use..

I give it a thimbs up

kriki · **Posted:** Thu Apr 12, 2007 2:15 pm

I answered your post in http://www.mibuso.com/forum/viewtopic.php?t=17673

kriki · **Posted:** Mon Aug 27, 2007 7:47 am

In case you need a boolean field, just remove the existing fields and put a boolean field in it. Remember that you need to rewrite the field-triggers on it.

bks · **Posted:** Tue Sep 04, 2007 1:08 pm

To the Administrator...

Thank you... Thank you.. Thank you... ! =D>

girish.joshi · **Posted:** Tue Dec 18, 2007 10:21 pm

Is it possible to base a Matrix Box on a temporary table?

kriki · **Posted:** Fri Dec 21, 2007 3:25 pm

girish.joshi wrote:

Is it possible to base a Matrix Box on a temporary table?

Yes,
you just need to put some code in the right place:

Temptable on the rows:

Code: Select all

Form - OnFindRecord(Which : Text[1024]) : Boolean
tmpRow.COPY(Rec);
blnFoundRow := tmpRow.FIND(Which);
Rec := tmpRow;
EXIT(blnFoundRow);

Form - OnNextRecord(Steps : Integer) : Integer
tmpRow.COPY(Rec);
intResultStepsRow := tmpItem.NEXT(Steps);
Rec := tmpRow;
EXIT(intResultStepsRow);

Temptabel on the columns:

Code: Select all

Matrix - OnFindRecord(Which : Text[1024];) : Boolean
tmpCol.COPY(Rec);
blnFoundCol := tmpCol.FIND(Which);
Rec := tmpCol;
EXIT(blnFoundCol);

Matrix - OnNextRecord(Steps : Integer;) : Integer
tmpCol.COPY(Rec);
intResultStepsCol := tmpCol.NEXT(Steps);
Rec := tmpCol;
EXIT(intResultStepsCol);

With :
intResultSteps... as integer
blnFound... as boolean
tmp... as temptable

girish.joshi · **Posted:** Fri Dec 21, 2007 4:18 pm

I'll test it out - thanks Kriki!

Thanks ... and wow.

mibuso.com

How To create a Matrix-form in Navision?

Who is online