Dynamic Columns in a table

Hello 
I am running Eclipse Mars.1 with BIRT 4.5.0. 
I need a table with a dynamic number of columns. 
The table should look like the following table Plans used Element(1) Element(2) ...... Element(6)

Plan 1 no - - 1 10 2 20 
 Plan 2 yes 1 10 - - 3 30 
 ... 
 Plan n no 3 30 3 30 3 30 
 
 
 Plans used Element(7) Element(8) ...... Element(n)

Plan 1 no - - 1 10 2 20 
 Plan 2 yes 1 10 - - 3 30 
 ... 
 Plan n no 3 30 3 30 3 30

Each row represents one plan (Plan 1 .. n) and every plan has a dynamic number of elements (Element (1) .. (n)). For every element in a plan we will show some information (e.g. "1 10"). 
If the number of columns exceeds the page width the table should continue with a new table. 
The number of Elements and the number of Plans are known at runtime (SQL statement). 
Is there a way to get this solution? 
Kind regards, 
Johann

Find more posts tagged with

Comments

Matthew L.

This is possible however it will require some custom coding to accomplish this.
Take a look at the following example for details on creating a dynamic table:
<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/24254-creating-column-dynamically/?p=132987'>http://developer.actuate.com/community/forum/index.php?/topic/24254-creating-column-dynamically/?p=132987</a>
 
Additional effort will be needed to get the Master Page width and calculate the max number of columns in your table.
Then loop the dynamic table creation with the remaining data that has not yet been processed on a previous table.

JohannJ

Hey Matthew 
thanks for your help, the example is very helpful. 
In the example a DataSet "odaDataSet.setQueryText( "SELECT * ...) is used. In my case I need 
a PL/SQL function to get a result like "Plan 1 no - - 1 10 2 20". Is it also possible to
use a PL/SQL function with parameters ? 
And how can i set the Header for the Elements (the name of the element) ? 
Thanks, 
Johann