How to display column names and values vertically

merkum

My Data Set is a result of a web service call and contains few hundreds elements (columns).
I have the Data Set configured so it has that many output columns and I can see all of them when I preview results.

I need to create a report that shows only one row but lists all its values vertically. I.e. my report will have 300 lines if the Data Set contains 300 output columns. Something like:

<Column1 Name> <Column1 Value>
<Column2 Name> <Column2 Value>
<Column3 Name> <Column3 Value>
…
<Column300 Name> <Column300 Value>

Of course I can create a table and manually insert labels and dataSetRow values but it's not a solution.
I would like to know what BIRT feature or structure can I use to create this layout? Should I use scripting? Should I use a table, or list, or crosstab? How can I automatically display a column name and value?

BTW, I get data trough a Web Service call but I don't think it make a difference.

Thanks,
Mike

mwilliams

Hi Mike,<br />
<br />
At first glance, you'll probably have to manually move all the labels and data values to where you want them. If you drag the dataSet to the report layout, it automatically creates lables and data elements, you'd just have to drag them all to the same detail columns and delete the extra columns. Another possibility could be creating the table dynamically with script. See the following devShare post.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/262-birt-dynamic-adding-tables-and-columns/#description'>BIRT: Dynamic Adding Tables and Columns - Designs & Code - BIRT Exchange</a>