Eclipse Community Forums: BIRT » Flip lines and columns

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

Flip lines and columns [message #819128]

Mon, 12 March 2012 10:34

Eclipse User

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!

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

Mon, 12 March 2012 12:15

Eclipse User

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

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

Tue, 13 March 2012 04:35

Eclipse User

Thanks Jason, your example helped me a lot Smile

Previous Topic:	Installation Error
Next Topic:	Hyperlink to go to web application for specific record (ticket id ))

Goto Forum:

-=] Back to Top [=-

Current Time: Sun May 11 07:43:05 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter