• Thank u but my problemi is i want to display the report like this

    Agent 1

    NoName balance

    1Ramesh1000

    2Suresh2000

    3Rajesh1000

    Total4000

    Agent 2

    NoName balance

    4Veeresh 2000

    5Maltesh3000

    6Amit 4000

    Total9000

    Grand total13000

    But after adding group it is displaying like this i.e 1 extra column is adding

    Agent1NoName balance

    1 Ramesh1000

    2 Suresh2000

    3 Rajesh1000

    Total 4000

    Agent2NoName balance

    4 Veeresh 2000

    5 Maltesh3000

    6 Amit 4000

    Total9000

    Grand total13000

    How to solve this problem