Group By

Hi,
I have created a report and when i checked the SQL, its not doing the Group by. Is there a way to set the SQL to generate Group by Clause too.
Thanks,
Ellis

BO 6.1b/ Oralce 10g


ellis27 :us: (BOB member since 2004-06-22)

If you include an aggregated column (one with a sum, count, min, max, etc. function), BusObj will automatically create a Group By clause for all non-aggregated columns. Stated another way, if you’re not aggregating, there is nothing to “group” together.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)