Post reply

Display group with maimum value in SSRS

  • January 29, 2014 at 2:13 am

    #303840

    hi

    In SSRS how to display single group which is having maximum value

    thatis for example from below records iwant to display student id 1 and Total marks 82

    I can write sql to bring this result but not able to achieve same in ssrs

    student Subject marks Total

    1 Maths 29 82

    1 English 25

    1 Science 28

    2 Maths14 63

    2 English23

    2 Science26

    3Maths32 78

    3English25

    3Science21

    4Maths11 66

    4English23

    4Science32

  • January 29, 2014 at 4:26 am

    #1684232

    http://www.sqlservercentral.com/articles/Reporting+Services/106306/

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply