none
ssrs rdl report roll up of data.

    Question

  • Hello,

    can any one help me to achieve

    From this

    Name |Roll_Number|Marks

    abc    |  1                   | 50

    cde    |  2                   | 40

    abc    |  1                   | 30

    cde    |  2                   | 60

    To this

    Name |Roll_Number|Total Marks

    abc    |  1                   | 80

    cde    |  2                   | 100

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

    thank you.

    Tuesday, November 19, 2013 5:09 PM

Answers

  • Assuming they are both tables, create a parent Row Group that groups on the Name field. You may need to have a group between the name group and the Details group for Roll Number. Then set the Total Marks column to =Sum(Fields!Marks.Value).

    "You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou
    Please Mark posts as answers or helpful so that others may find the fortune they seek.

    Tuesday, November 19, 2013 10:05 PM

All replies

  • Assuming they are both tables, create a parent Row Group that groups on the Name field. You may need to have a group between the name group and the Details group for Roll Number. Then set the Total Marks column to =Sum(Fields!Marks.Value).

    "You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou
    Please Mark posts as answers or helpful so that others may find the fortune they seek.

    Tuesday, November 19, 2013 10:05 PM
  • Thanks sir, it is easy.

    Saurabh ssrs alerts from msdn

    Wednesday, November 20, 2013 4:06 PM