Dynamic column creation in table

RepBIRT

Generally for every row returned by dataset a new row is created dynamically by the table element. But how to generate dynamically column in the tables based on the dataset values.

For example: Select employeenumber from employees(ClassicModel db)
How do create a different column for each of employeenumber?

It would be great, if a sample report is shared.

kclark

You could flip the rows and column of the table using a crosstab. <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/1475-flip-tabular-rows-and-columns-using-a-crosstab/'>Here's a devshare</a> with an example.