Dynamic columns / horizontally sliding portal / fixed left column
I'm trying to build a 'spreadsheet'-like view on a normal user-screen layout.
What i basically like to do is generate a pivot-table, with the column-headers being the different values (=records) of a specific field in a different table.
I suppose that i need to work with a portal for this, but then i need to be able to determine the number of 'columns' dynamically (depending on the number of records in the 'other' file) and hence it might be that not all values fit in display-size of the portal which would then mean that a horizontal slidebar would be required.
Preferable also the first column should be 'fixed' so that it remains visible at all times.
... and i would like to do all this in FM (=without exports of data and further treatment in Excel, ...)
Am i asking something impossible? Does anybody has any suggestion?