cross tab problem


my query Return following data

Name   age  Group
XYZ    21   a
MNO    22   m
ABC    23   p
XYZ    21   d
MNO    22   n
ABC    23   q
XYZ    21   f
MNO    22   o
ABC    23   r
PQR    24   __

i want to design cross tab like that how to design my cross tab plz help me
in irepor

name  age  A  B  C

XYZ    21  a  d  f
MNO    22  m  n  o
ABC    23  p  q  r
PQR    25  -  -  -

singh758's picture
Joined: Oct 22 2012 - 7:20am
Last seen: 7 years 10 months ago

2 Answers:


If you want to capture a many-to-many replationship between name to group, you might want to define each group as it's own dimension.

udidav's picture
Joined: Nov 8 2012 - 4:55pm
Last seen: 7 years 9 months ago

i want to capture one-to-many relationship..

singh758 - 9 years 2 months ago

Hello frds,
Iam new @jasper Report.....i have one requirement ,,,iam enable to get any blog for this so plz help meeeeeee

My requirment is .......i want to do SubTotal for more than 2 rows .So iam unable to get this .Soooo plz help and send step how to do this...

Plz check below attached Excel File like tht i want output............Iam waiting for Your Reply.

Office spreadsheet icon gopal.xls16 KB
gopalreddy436's picture
Joined: May 8 2014 - 4:48am
Last seen: 6 years 1 month ago