how create a simple cross tab?

[2006 IR Open Discussion]

By: charlyjava - charlyjava

how create a simple cross tab?

2006-06-08 02:43

hi, i would really apreciate some help. Looks like the cross tab wizard is not so ntuitive....... and try to make the cross table with jasper reports tags could be terrible !!!!!!!

Someone can explain me how to make a simple cross tab please??????

for instance, some so simple as:

 

 

year | 2000 | 2001 |2002| 2003| TOTAL

-----------------------------------------------

init money | 23 | 32 | 12 | 34 | 101

-----------------------------------------------

final money| 34 | -23 | 15 | 22 | 48

-----------------------------------------------

benefits | +11 | -55 | +3 | -12 | -53

 

 

Data is stored in database, i know how retrieve it, but when i start the cross table wizard i have a very bad feeling .......