Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » complex pivot table(how to create complex pivot table with cross tabs)
complex pivot table [message #812837] Sun, 04 March 2012 11:39 Go to next message
marina tzerluk is currently offline marina tzerluk
Messages: 13
Registered: February 2012
Junior Member
Hi
i need to create this table in birt.
the date should by dimanic.
i am trying to use cross tabs but it doesnt give me the wanted functionality.


student name| mathematics | science
01/01/2010|02/01/2010|03/01/2010| 01/01/2010|02/01/2010|03/01/2010| stud1 82 83 84 52 52 53

stude2 52 52 98 65 67 52 the values of the months should be hiden , just the deviation of the grades should exist.

my data set is:

date | student | mathemathics| science

can you please help me to understans how it can be implemented?
Re: complex pivot table [message #813936 is a reply to message #812837] Mon, 05 March 2012 21:34 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Can you put some sample data in a text file to create a report off of?
If so post it and the desired output. For example you have dates, do
you want the years shown only?

Jason

On 3/4/2012 6:39 AM, marina tzerluk wrote:
> Hi
> i need to create this table in birt.
> the date should by dimanic.
> i am trying to use cross tabs but it doesnt give me the wanted
> functionality.
>
>
> student name| mathematics | science
> 01/01/2010|02/01/2010|03/01/2010| 01/01/2010|02/01/2010|03/01/2010|
> stud1 82 83 84 52 52 53
> stude2 52 52 98 65 67 52 the values of the months should be hiden , just
> the deviation of the grades should exist.
>
> my data set is:
>
> date | student | mathemathics| science
> can you please help me to understans how it can be implemented?
Re: complex pivot table [message #814494 is a reply to message #813936] Tue, 06 March 2012 14:12 Go to previous message
marina tzerluk is currently offline marina tzerluk
Messages: 13
Registered: February 2012
Junior Member
hi

i have two flat files .dinamic2, dinamic3.

basiclly my original file looks like dinamic2, but i figure out some solution for my problem, where i duplicate 2 columns(type which is performance or availablity) and value (the original vLUE FOR PERFORMANCE/AVAILABILITY). i can creat those computed columns in the run time in birt as well.

but this solution is not good enough because it means i need to duplicate all data to performance and availability.

i tried taking different approach like the one in my second table, but in this case i cant add some additional columns like volums...

if you can give me some better solution it would be great.
Previous Topic:birt report java script problem in chrome and firefox
Next Topic:How to dynamically remove or disable a chart (or other element)?
Goto Forum:
  


Current Time: Tue Sep 16 04:56:09 GMT 2014

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

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