How to create Data set with dynamic output columns

thanhdn

<p>Hi all,</p><p>I' trying create report with dynamic table columns with columns name from GA1 ....GAn (n is dynamic value).</p><p>Now, I know how to create dynamic table columns based on <a data-ipb='nomediaparse' href='http://devndev.wordpress.com/2011/03/05/birt-add-dynamic-column/'>http://devndev.wordpress.com/2011/03/05/birt-add-dynamic-column/</a></p><p>But I don't know how to create dataset with dynamic output columns (GA1 ...GAn).</p><p> </p><p style="font-size:13.63636302947998px;color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">Can/How do I script this?</p><p style="font-size:13.63636302947998px;color:rgb(0,0,0);font-family:Arial, 'Liberation Sans', 'DejaVu Sans', sans-serif;">Many thanks in advance</p>

BRM

<p>If you are creating the dataset with SQL the way to add columns is to use joins to add the columns you want.  You didn't say why you want to go the the trouble to have dynamic table columns but one thing you might try would be to do the joins to create all the possible columns you might want and then hide them selectivly based on the report data (or user input or whatever).</p><p> </p><p>If the columns have names that can change then you should look into crosstab tables.</p><p> </p><p>Hope that helps.</p>