Skip to Content
0

Crystal Reports Enterprise

Jul 23, 2017 at 07:47 PM

26

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Jul 31, 2017 at 10:13 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded