Matrix Box Update on Open

SPost29

Hi all,
I have searched the form and not found an answer.
I have a matrix form with machine center No as the form source and Integer (rank) 1..20 as the Matrix source
I am showing a custom production schedule in the matrix box by Rank
so 1 is the first in rank and displays a calcfield of all orders for that machine center with that rank

My problem is that when the form opens, the matrix box and matrix header are blank, until I use the horizontal scroll bar or buttons and scroll to the end and back to 1 then everything is filled in properly
Does anyone recognize this symptom or have a suggestion?

Thanks,
Steve

kriki

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

SPost29

Thanks Kriki,
I did check that out. I was hoping someone would recognize the symptom and say "you have code in blah blah and thats the cause".
I guess I will have to rebuild the whole matrix form from scratch following the example.
I had started the project with date as the matrixRec (which worked fine) but changed the matrixRec to integer to fit the clients requirement better and broke something.
Thanks
again
steve

kriki

One hint:
to fill up a cell, put your code in the OnFormat-trigger. Probably this will help.

SPost29

Thanks Kriki,
I put code in the OnFormat trigger that turns red if Record is a hot item
and black if not Hot. an if then else statement.

This shows the ones that are hot but not the rest until I do the scroll trick.

Any other thoughts?

Thanks
Steve

kriki

Can you post a screenshot so I can see it what you have?

Purvesh_Maisuria

Hi,

I Think Ur Problem is Solve By One Of These Two Solution,
1. Put these line of code @ OnAfterValidate Event.
CurrForm.UPDATE(FALSE);
CurrForm.UPDATECONTROLS;

Or

2. Write This line after U Apply All Filters,
Ex. I Use GetData Function To Fill Data In Cell, I Write Filter & Line IF DimTrans.FINDFIRST THEN is Working Fine.

GetData() : Text[30]
DimTrans.SETRANGE(DimTrans."Dim Code",CurrForm.MyMatrix.MatrixRec."Dimension Code");
DimTrans.SETRANGE(DimTrans."Item No.","No.");
IF DimTrans.FINDFIRST THEN

EXIT(DimTrans.Value);

Hope This is Work,

Thanks & Regards,
Purvesh Maisuria.