Matrix box based on temporary tables

rixrix
rixrix Member Posts: 121
edited 2011-04-17 in NAV/Navision Classic Client
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

Comments

  • rixrix
    rixrix Member Posts: 121
    + 1 other question

    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
  • jglathe
    jglathe Member Posts: 639
    Hello rixrix,

    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

Categories