Matrix form Restrictions

gopalach77
gopalach77 Member Posts: 18
edited 2011-11-18 in NAV/Navision Classic Client
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.";

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    I didn't completely understand what you mean, but if you mean to resize the columns programmatically, it is not possible.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • SPost29
    SPost29 Member Posts: 148
    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
    gopalach77 Member Posts: 18
    hi steve,

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

    thanks
    gk
  • kriki
    kriki Member, Moderator Posts: 9,121
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories