Problems with "COUNT(DISTINCT xxx)" and end-user Reporting Tools

Couple of ?s for those of you who understand this stuff. I've been evaluating several end-user reporting tools (e.g. IQ Pro, BusinessObjects, Impromptu), and they all use the following syntax for the COUNT aggregate function: "COUNT(xxx)" whereas Informix SQL requires: "COUNT(DISTINCT xxx)" which is causing me all kinds of grief. Is the "COUNT DISTINCT" keyword unique to Informix? Since you can't do a count without the DISTINCT keyword, why doesn't Informix just make that the default definition "COUNT(xxx)" ? What kinds of workarounds have been employed, specifically with repsect to IQ Pro? Thanks in advance. -- -------------------------------------------------------------------------- Jeff Webster | 102110,3554@compuserve.com Visual Services, Inc. | Tel: (810) 433-7943 Bloomfield Hills, Michigan, USA | Fax: (810) 646-0888 "Any opinions expressed herein are my own and not those of my employers." --------------------------------------------------------------------------