How do you arrange it horizontal direction?

I'm sorry. The same question was posted to the practice place. ;p

Data queues up in the vertical direction usually.
How should I do to arrange it in transverse?

exam.

Name Country
AAAAAA USA
BBBBBBB FRA
CCCCCC GER
DDDDDD AUS

Name AAAAAA BBBBBB CCCCCC DDDDDD
Country USA FRA GER AUS

Find more posts tagged with

Comments

Virgil Dodson

Hi tempua,

You should experiment with the "inline" display feature to get this sort of output. To see this, select a data field, then Properties window | Advanced | Section | Display. It should be set to "block" by default but you can chance it to "inline". Put name in one list control in this fashion, and country in another list control and you will get the output you showed in your post. An example is enclosed. If you want more alignment of the name and country, try using a crosstab control instead.

dinov

vdodson:

Could you show an example on how to use crosstab to achieve the original poster wanted based on the following xml data:

<records>
<record><name>AAAA</name><country>USA</county></record>
<record><name>BBBBBB</name><country>FRA</county></record>
<record><name>CCCCCC</name><country>GER</county></record>
<record><name>DDDDD</name><country>AUS</county></record>
</records>

I'm finding the crosstab functionality a bit confusing for xml datasets.

Virgil Dodson

I updated this same example with a crosstab. I actually put two crosstabs, one for the JDBC data source, and one for this new XML data source. It seemed to work for either case. I created these in BIRT 2.3.

dinov

<blockquote class='ipsBlockquote' data-author="vdodson">I updated this same example with a crosstab. I actually put two crosstabs, one for the JDBC data source, and one for this new XML data source. It seemed to work for either case. I created these in BIRT 2.3.</blockquote>
 
Virgil, thanks a million. 
 
Another question. How would I add a label to each line ("Name" and "Country" in this instance)? 
 
BWT: this answer should be in the FAQ. It is essentially allows the orientation of the table to be changed.

Virgil Dodson

Here is one more copy that has labels. Basically, you can add labels and crosstabs to a grid for this simple example... or you can let the crosstab put the labels in for you when you add the measures. By default, these labels will be on top, but in the general properties of the crosstab you can switch from horizontal layout to vertical layout and the labels will show up on the left. See example.

dinov

<blockquote class='ipsBlockquote' data-author="vdodson">Here is one more copy that has labels. Basically, you can add labels and crosstabs to a grid for this simple example... or you can let the crosstab put the labels in for you when you add the measures. By default, these labels will be on top, but in the general properties of the crosstab you can switch from horizontal layout to vertical layout and the labels will show up on the left. See example.</blockquote>
 
Many many thanks! Works like a charm. This question has been asked a ton of times and this is the first real solution I have found.

anir

Thanks for the solution