Home » Developer & Programmer » Reports & Discoverer » COUNT DISTINCT
COUNT DISTINCT [message #90215] Thu, 09 December 2004 04:27 Go to next message
Luis
Messages: 29
Registered: November 1999
Junior Member
How can i implement COUNT(DISTINCT a) in a REPORT ...the functions available is just a simple count.
That's the problem, i've to show all values from a query, but i īve to count records from subgroups and the counting considers repeated values, How can i make a count distinct formula? ,ORACLE REPORTS only allows me to put sum,count,first,last,avg etc ....
All my problem will resolve if only i could put a count distinct in the report, not in the query.
Thanks

Report message to a moderator

Re: COUNT DISTINCT [message #90217 is a reply to message #90215] Thu, 09 December 2004 20:41 Go to previous message
Arvin AUDIT
Messages: 22
Registered: November 2004
Junior Member
You just have to put a formula column in your report and you are done

Report message to a moderator

Previous Topic: update command in after report trigger
Next Topic: How to call reports from forms10g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 11 07:05:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.