Home » Developer & Programmer » Reports & Discoverer » Report giving total count per one customer id
Report giving total count per one customer id [message #625934] Thu, 16 October 2014 06:05 Go to next message
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 #625935 is a reply to message #625934] Thu, 16 October 2014 06:09 Go to previous messageGo to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
I made master link
Don't want to pass any param's need the count(order_no) and count(cost)
Re: Report giving total count per one customer id [message #626013 is a reply to message #625935] Sun, 19 October 2014 04:50 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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).
Re: Report giving total count per one customer id [message #626030 is a reply to message #626013] Sun, 19 October 2014 22:42 Go to previous message
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
Previous Topic: Any queries on one page
Next Topic: REP-0069: Internal error REP-57054: In-process job terminated:Terminated with error
Goto Forum:
  


Current Time: Sat Nov 23 05:50:14 CST 2024