Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Flip lines and columns (Is it possible in a Table?)
Flip lines and columns [message #819128] Mon, 12 March 2012 14:34 Go to next message
David B. is currently offline 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!
Re: Flip lines and columns [message #819207 is a reply to message #819128] Mon, 12 March 2012 16:15 Go to previous messageGo to next message
Jason Weathersby is currently offline 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
Re: Flip lines and columns [message #819715 is a reply to message #819207] Tue, 13 March 2012 08:35 Go to previous message
David B. is currently offline David B.
Messages: 24
Registered: February 2012
Junior Member
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:
  


Current Time: Fri Oct 31 07:18:52 GMT 2014

Powered by FUDForum. Page generated in 0.11286 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software