is there any convinient way to creat table with dinamic columns

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.

Find more posts tagged with

Comments

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.

marinTz

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="96950" data-time="1330457237" data-date="28 February 2012 - 12:27 PM">
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. </blockquote>

marinTz

thanks for the quick feedback:).

the first issue is solved , i solved it with cross tabs.
for now lets keep it simple and say that we have only
2 levels: father and multiple sons.
father and sons come from the same data set.
i have flat file where one column represents the father and the other is the son.
exmp:
father col |son col

david| mark
david|nick
mike|oren
mike|anthony

but basiclly it can be three levels as well.

mwilliams

What's your BIRT version?

marinTz

i have the 3.7

mwilliams

Take a look at this example. Maybe it'll help.