Hi,

I need to have a Matix report which looks like :

...............|YEARS
--------------------------------
...............|Class1|Class2|Class3
Programme|StudNo|StudNo|StudNo

Column--Years SubColumn--Class1,Class2,Class3
Row --Programme
Data --No of Students


ie; The Matix will look like this

Programme|.......2001.................|........200 2............|.
------------------------------------------------------------------------
..............|Class1|Class2|Class3|Class1|Class2| Class3|.....
IT...........|..23...|...24..|..45....|..12...|..2 3...|..12..|.....
MBA........|..34...|...12..|..12....|..31...|..13. ..|..14..|.....


I don't know how to split the YEARS' column into 3 different subcolumns which has got class1,class2,class3.Each year has got the 3 different staic column headers as class Names. Under that the no of students in each class comes. The students in each class in each year should be calculated based on some condition which is not available directly from a dataset. Hope u can understand the matix.

PLEASE HELP!!!


Thanks & regards,
Payal