| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
