Skip to Content
avatar image
Former Member

Crystal Reports Enterprise

I have a report with grouping on Regipn,Location, Customer Name,Credit Program.

Data Looks as below:

Custno Customer Name Credit Program Amt

12356. ABC Flex 25 0

Total balance 0

12356. ABC. Flex 25. 2500

Total balance. 2500

21346. DEF. FOUNDATION. 3400

Total balance 3400

21346. DEF. Foundation. 2300

Total balance 2300

My report as it is grouped by Credit Program it should show as below:Since ABC customer has same credit program it should get grouped and should show as single record.but my report is not showing.plz help me if we can write any group by formula in subreport.

Custno Customer Name Credit Program Amt

12356. ABC Flex 25

2500

Total balance. 2500

21346. DEF. FOUNDATION. 3400

Total balance 3400

21346. DEF. Foundation. 2300

Total balance 2300

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 31, 2017 at 10:13 AM

    Hi Kethireddy,

    1. Insert a Group on the Credit Program

    2. Place all fields on the Group Header/Group Footer

    3. Insert a Summary on the Amount field and place this on the Group Header/Footer

    4. Suppress the Details/Body Section

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded