| reports [message #80887] |
Wed, 11 December 2002 19:07  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
