SSRS 2005 Reporting - Matrix

• raghavendraselvan.sk

  Old Hand

  Points: 325

  More actions

  January 11, 2012 at 9:14 am

  #262695

  Hi ,

  Hope you are fine .

  Currently I am developing a SSRS 2005 reports . Right now there is an excel based reporting which I am converting to SSRS . The excel based used a Pivot table . So I am using MATRIX in SSRS for generating the same .

  One issue I am facing is I need to have 3 more extra column apart from Matrix . The column name is 1+2,TOTAL, TOTAL(Minus N). Not sure how to do this ang googling did not help me .

  Since it is a matrix , I have dragged the Row data ,Column data and the detail data . My matrix look like this below

  1 2 3 4 N

  jane 50 60 70 80 3

  Selva 60 50 78 98 4

  Mark 90 70 68 68 0

  It need to be like this

  1 2 3 4 N 1+2 Total Total(MInus N)

  jane 50 60 70 80 3 110 263 260

  Selva 60 50 78 98 4 110 290 286

  Mark 90 70 68 68 10 160 306 296

  1+2 ==> Addition of first two values in Matrix

  Total ==> addition of all values

  Total(Minus N) ==> Total - N values

  Since it is a Matrix , I am not sure how to add 1 st and 2 nd value as rest of column value need to be skipped and also how to get Total - N values . How can Get the first and secong value specific from Matrix . IF it is table I can .

  Please help me ...Thanks in advance . Any more info need pls let me know , it is little urgent

  Warm Regards

  Raghav