Special Matrix Form

geri79

Hello,

I would like to create a form what shows some flow fields of the job table as lines and different periods as colums

i.e.

---

| period period+1 period+2

---

Budgeted Cost |
Usage Cost |
Sales Price |


I hav no idea how to do this. Any good ideas? Maybe some hints how to start...

geri79

kriki

For the columns, you can use other matrix-forms that use this system as an example.

For the rows, use table Integer and set filter on the number of flowfields you want as rows.
In the OnAfterFormat-trigger of the cell, you can check in which row you are (with rec.NUMBER) and calculate the correct flowfield.