locked
Remove Duplicate Records From Crystal Report RRS feed

  • Question

  • User1724124194 posted

    I want to remove duplicate records from my crystal report.

    My Actula Report is like this.

    Item Code Item Name Amount
    A001 Item 1 100
    A001 Item 1 100
    A002 Item 2 50
    A002 Item 2 50
    A003 Item 3 200
    A004 Item 4 150
    Total 650

     

    But I want to remove the dupliacte records and my report should be like this

    Item Code Item Name Amount
    A001 Item 1 100
    A002 Item 2 50
    A003 Item 3 200
    A004 Item 4 150
    Total

    500

     

     

    I have already tried with Group and with Previous Command. In Grouping my report is getting ok but the total Value of the report is not correct.

    Can anybody help me.

    Thanks in Advance

    Friday, June 24, 2011 8:06 AM

Answers

All replies