Hello ...
I really did search on all mibuso + web, but can not manage how to do it ...
I have one TEMPORARY table with these colunms: Id1, Id2, Value
I would like to have this displayed in matrix Box.
So "vertical part" will be distinct selection of Id1
"horizontal part (headings)" will be distinct selection of Id2
And values in matrix will be taken from column "Value" (or sum of it, if there are more same Id1,Id2 lines)
for example Id1=Customer Id, Id2=Month, Value=Turnover
Is this possible?
(I manged to run matrix box with normal tables, but have problems with TEMPORARY ones")
P.S. If needed, I can split data among three temporary tables ....
Thank you in advance
0
Comments
Is it possible tu show MatrixBox on RequestOptionsForm?
I tried simple example from NAV "help", but it gives me error: Property ???1 not defined in property list
It is caused by experssion: RequestOptionsForm.Matrix.MatrixRec.Number ...
In normal form, everything works ok ... (of course expression is: Currfom.Matrix ....)
Thank you
I think it's possible, but it will be awful code, though. For reference I would recommend to have a look at the Account Schedule Matrix form for instance, this calculates cell values in a temporary buffer table (in CU 8 ). You can use a similar structure. The main problem would be to assign a temporary table to the SourceTable and MatrixSourceTable properties of the form. To solve this I would recommend to add code in the OnOpenForm(), OnFind() and OnNext() triggers, respectively to route the access to the temporary table. I would try to avoid such code, though.
with best regards
Jens