is there any convinient way to creat table with dinamic columns

marinTz

Hi
i need to create some over time report, which will danamiclly show over time , acoording user selection in the filter.
i would need dinamiclly to alter the number of columns, and dynamiclly take the relevant buinding in the data set.
is there a convinient way to do so?

and i have another question:
i need to creat tree table, where the father element can have several sons. on the father element there should be option to expand (+)and to see all the childeren, and (-) option to colapse and to hide the children.
how can i creat such table?


thanks.

mwilliams

So, when the user selects different durations, there are different numbers of columns returned? Or do you have a single date field and you want each year/month/day or whatever to have its own column? If this is the case, this sounds like a crosstab. Let me know.

As far as the tree table goes, is it only a 2 level table? Or do the sons have sons? Do the fathers come from one dataSet and the sons from another? Let me know.