Eclipse Community Forums: BIRT » Flip lines and columns

Help

Home

Home » Archived » BIRT » Flip lines and columns (Is it possible in a Table?)

Show: Today's Messages :: Show Polls :: Message Navigator

Flip lines and columns [message #819128]

Mon, 12 March 2012 14:34

David B.

Messages: 24
Registered: February 2012

Junior Member

Hi,

I have a file that contains a fixed number of rows and columns.
I want to display the data in a table but I would like to flip the lines and columns.
Is it possible with BIRT?

Here is an example:

My input file would look like this:
Number of Tries ; Score ; Money
1 ; 10 ; 20
2 ; 10 ; 20
3 ; 30 ; 60
4 ; 35 ; 70

And I would like to display it in a Table like this:
; Try 1 ; Try 2 ; Try 3 ; Try 4
Score ; 10 ; 10 ; 30 ; 35
Money ; 20 ; 20 ; 60 ; 70

I took a quick look at some examples for the Cross Tab component but I wasn't convinced this is what I need in my case. Maybe there is a very simple way to flip lines and columns (like it is possible to flip axis in the charts very easily)...

Thanks in advance!

Report message to a moderator

Re: Flip lines and columns [message #819207 is a reply to message #819128]

Mon, 12 March 2012 16:15

Jason Weathersby

Messages: 9167
Registered: July 2009

Senior Member

Very simple to do this with a crosstab. I created an example report
that uses a scripted data set to simulate your data, then created a cube
and crosstab to show you how it flips it. The example is located here:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1475-flip-tabular-rows-and-columns-using-a-crosstab/

Jason

On 3/12/2012 10:34 AM, David B. wrote:
> 1 ; 10 ; 20
> 2 ; 10 ; 20
> 3 ; 30 ; 60
> 4 ; 35 ; 70

Report message to a moderator