Report giving total count per one customer id [message #625934] |
Thu, 16 October 2014 06:05 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi all,
customer_id:1234
customer name:Vision Tech
order no order_name Cost
---------- ---------- ----
1000 ABC 1000
1001 CCC 2000
Total Order: 4 Total Cost: 3700
customer_id:1000
customer name: Tech
order no order_name Cost
---------- ---------- ----
400 DDD 300
4001 EEE 400
Total Order: 4 Total Cost: 3700
Needed Report output
customer_id:1234
customer name:Vision Tech
order no order_name Cost
---------- ---------- ----
1000 ABC 1000
1001 CCC 2000
Total Order: 2 Total Cost: 3000
customer_id:1000
customer name:Tech
order no order_name Cost
---------- ---------- ----
400 DDD 300
4001 EEE 400
Total Order: 2 Total Cost: 700
[Updated on: Thu, 16 October 2014 06:07] Report message to a moderator
|
|
|
|
|
Re: Report giving total count per one customer id [message #626030 is a reply to message #626013] |
Sun, 19 October 2014 22:42 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Quote:Total order and total cost are ... what? Summary columns? If so, modify their "break" property. It seems it is set to "report", while it should be a "group" (group name, of course).
Thanks Littlefoot , those are summary columns , you mean put a summary columns in the Report or group level, can you please give me some steps on this?
Thanks
|
|
|