>Sylvain
>
>So the group by is the same as a grouping clause in a report. The only difference is that it does the grouping with the records PRIOR to the report and this, the detail of the report would be JUST the grouped records and not the individual ones that make it up.
>
>If that is the case, if I want the detail as well as group footers with totals, I would NOT use the GROUP BY in the select but instead use a DATA GROUPING in the report to catch the totals in the header.
>
>Correct?

Correct. With GROUP BY, you lose a level of detail, so it's fine as long as you don't want that detail.