Unknown number of columns in a result set

Hi,

I'd like to be able to create a list report that has a y-axis of dimensional data and then an x-axis with column titles as dimensional data and then the grid filled with numbers.

The rub is the number of columns on the x-axis is unknown at runtime. Is there a nifty way for BIRT to handle this? My brute-force way is to have a static report with the maximum number of columns and then hide them if nothing in them, but I was hoping for a better way.

Thanks.

Find more posts tagged with

Comments

johnw

Couldn't you generate the table dynamically? 
 
<a class='bbc_url' href='http://digiassn.blogspot.com/2007/11/birt-dynamic-adding-tables-and-columns.html'>The Digital Voice: BIRT: Dynamic Adding Tables and Columns</a> 
 
Something like that might work, the only problem is I dont believe you can modify the report design during the phase where data is retrieved in the report run cycle. Search through the DevShare for dynamic table. That might turn something up. 
 
John

GalenBoyer

After a little bit of thought, my list report would be the same output as a crosstab, so I'm wondering if I could fill up the cube from a SQL query and then use that cube in a crosstab in BIRT?

Virgil Dodson

Crosstab should work too.