Home » Developer & Programmer » Reports & Discoverer » COUNT_DISTINCT and Percentages Creates Garbage
COUNT_DISTINCT and Percentages Creates Garbage [message #89990] Wed, 22 September 2004 07:39
Paul Sanders
Messages: 1
Registered: September 2004
Junior Member
I have a report that has a total column using the COUNT_DISTINCT function; all works correctly. However I then add a percentage column based on the totals and after the query is run, the screen is garbage - the title section is missing and the very first row of data is present, the rest is empty.

I've tried various combinations of queries and the result is always the same. If I change the distinct count to a regular count then the report appears correctly. But that's not what I want. I guess this is a known bug but haven't found it written anywhere - anyone have a workaround?

I'm using 9.0.2.

Thanks

Paul
Previous Topic: Reports Help
Next Topic: One query is the best or Two queries regarding Performance ?
Goto Forum:
  


Current Time: Fri Nov 22 08:50:08 CST 2024