Dynamic Tables in BIRT

Hi All,

Did some creeping in the forum to see if I could find a full answer for this one, but wasn't able to. I did find a nifty example, but I'm wondering if there is a way without having to list out the columns in the table in a parameter.

Basically I have columns in tables that are user generated....which means, a user adds a new field to their survey, my code will add a column to the table for that field. So, while there are a few fields that are consistent across all survey tables, there are also a bunch of user-generated fields that I wouldn't know about until runtime.

So a SELECT * FROM tbl_survey_results could have 3 columns, 12 columns...30...etc. How can get I get my report to just dynamically "dump" those results into a table?

Any help of course is greatly appreciated! OH and BTW - I attended the BIRT Roadshow here in Hotlanta...very cool. Thanks guys!

Amanda

Find more posts tagged with

Comments

JasonW

Amanda,

The issue is that the last time you can modify the table in this fashion is before you actually open the dataset. Most mods to tables/reports are done in the beforeFactory event. So your choices are to write a Java class that polls the columns and include that with the report in a beforeFactory event or have a driver report that collects the information and passes it to another report as parameters.

Jason