Adding dynamic table columns based on dataset SQL query resultset

abhiallen

Hello All,

I have a requirement to develop a report which shows a table with dynamically changing columns based on the SQL query dataset resultset, which have to be analyzed to create required columns.

I read some previous posts about dynamic column addition, but couldn't find any in which dataset result set is analyzed to add columns in the existing table in the report.

Please recommend most efficient approach for this problem!

thanks
Abhishek

kclark

<a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/262-birt-dynamic-adding-tables-and-columns/#description'>Here's a devshare</a> that shows how you can dynamically add columns to a table. Are you trying to add columns based on how many rows your SQL is returning or some other calculation?