Home » Developer & Programmer » Forms » reports
reports [message #80887] Wed, 11 December 2002 19:07 Go to next message
murli
Messages: 25
Registered: November 2002
Junior Member
hi
I have column called name where i have to count the name and display it in the report.i am using a summary column which displays as a separte column.I want it in the following manner.please help me

id name volume
101 xxx 100
102 aaa 220
103 yyy 300
Total(3name) 620
Thanks in advance
Re: reports [message #80922 is a reply to message #80887] Sat, 14 December 2002 07:59 Go to previous message
Piyush Balan
Messages: 26
Registered: December 2002
Junior Member
Hi James,
U can acheive the volume part of data in the query of the database itslef using COUNT() and GROUP BY ID, NAME.
and u can then get the total of no. of names and the sum of the volume using the summary columns.

let me know if u need any further assistance.

regards,
Piyush Balan,
Consultant,
Comsoft Pte Ltd,
Singapore.
Previous Topic: 9i/9iAS
Next Topic: Displaying no of records dynamically for a block
Goto Forum:
  


Current Time: Thu Mar 28 13:53:09 CDT 2024