Adding static column to matix in SSRS.. PLz Help !! [modified]
-
Hi, I need to have a Matix report which looks like : ...............|YEARS -------------------------------- ...............|Class1|Class2|Class3 Programme|StudNo|StudNo|StudNo ie; The Matix will look like this Programme|.......2001.................|........2002............|. ------------------------------------------------------------------------ ..............|Class1|Class2|Class3|Class1|Class2|Class3|..... IT...........|..23...|...24..|..45....|..12...|..23...|..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 classnames. 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. Its not available directly from a dataset. Hope u can understand the matix. PLEASE HELP!!! :sigh: Thanks & regards, Payal
modified on Thursday, March 6, 2008 8:38 PM
-
Hi, I need to have a Matix report which looks like : ...............|YEARS -------------------------------- ...............|Class1|Class2|Class3 Programme|StudNo|StudNo|StudNo ie; The Matix will look like this Programme|.......2001.................|........2002............|. ------------------------------------------------------------------------ ..............|Class1|Class2|Class3|Class1|Class2|Class3|..... IT...........|..23...|...24..|..45....|..12...|..23...|..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 classnames. 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. Its not available directly from a dataset. Hope u can understand the matix. PLEASE HELP!!! :sigh: Thanks & regards, Payal
modified on Thursday, March 6, 2008 8:38 PM
-
Your column groupings need to be Year and Class.
Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush
The Class field has 3 static values Class1 Class2 Class3. If Class was a single dataset then only Year and class could be set as Column grouping. Can u plz explain how to go about in the case where i have 3 different static values for the class? Thanks Payal
-
The Class field has 3 static values Class1 Class2 Class3. If Class was a single dataset then only Year and class could be set as Column grouping. Can u plz explain how to go about in the case where i have 3 different static values for the class? Thanks Payal