Hello Experts,
For my app it is conveneant to be flexible with presenting data.
So, how do i get a kind of datagrid where table data are transposed in viewer/UI ?
That is, just a easy as one can set tabpanel layout from top to left, why not for e.g. with the portal
Any suggestions ?
Currently, i made a double loop to actually get a transposed dataset - being able to show it in a JSTable.
But SURELY! can this not be done simpler ( seems to me a plain developer need)
Regards, Jan
I don’t get the point, what are trying to achieve exactly?
Well, …
(Just to get any misunderstandings out of the way) transpose operation means
… most simply in Excel, swap your rows with the columns
So MyTable >> some_id | Fieldname1 | fieldname 2
1 Hey there 1001
2 I’m fine 1002
Is shown on a (for example) portal, like: some_id | 1 | 2
fieldname1 | Hey there | I’m fine
fieldname2 | 1001 | 1002
I would expect an easy method/opton
for this, is there one… ?
Hope this helps
No, there is no out of the box way to do that but you can code it yourself in several ways: Dr Maison datagrid bean (smart client only), html table in an html area (smart/web), create a datasource on the fly and genarate a new form to display it, etc.
If you really need that you will have to work a bit, keep an eye closed for performance though, all of the above requires you looping on datasets/foundsets.
Thanks, Nicola