Matrix form Restrictions

gopalach77

hi,

I would like to restrict the coulmns in a matrix form, based on a flowfield. is it possible?

for ex:


CurrForm.ItemAvailMatrix.MatrixRec.CALCFIELDS(inventory);
IF CurrForm.ItemAvailMatrix.MatrixRec.inventory <> 0 THEN
MatrixHeader := CurrForm.ItemAvailMatrix.MatrixRec."No.";

kriki

I didn't completely understand what you mean, but if you mean to resize the columns programmatically, it is not possible.

SPost29

If you mean display part A, Part C, Part F in the column header
because they have inventory but do not show
part B, part D, and part E because they have no inventory and

you end up with columns in your matrix of: A C F

You can do this. It is controlled on the Matrix control OnFindRecord trigger and OnNextRecord trigger
You need to skip the ones that don't meet your criteria.
This is advanced programming in that you need to understand how the onfind and onnext work.

If you look at any of the matrix forms that use the date in the matrix header you will see it calls a function in the onfind and onnext,
That should give you the clues you need.

Good luck
Steve

gopalach77

hi steve,

you got my question i will try and come back incase i do not find a solution.

thanks
gk

kriki

If the inventory field is a calculated field of the table that generates the columns, you can put a filter on it:

CurrForm.ItemAvailMatrix.MatrixRec.SETFILTER(inventory,'<>0');

See also http://www.mibuso.com/howtoinfo.asp?FileID=13 to know where to put the filter.