Data Report Grouping Help Please

I have a SQL query in the Data environment that joins 3 tables and I have grouping on some fields. I have designed a report that uses this DE command object with the grouping and it all works fine.

However I would like to add another level of grouping based on another field. I know how to add a new group to the report but how do I add another level of grouping to the command object containing the SQL query?

Help would be very much appreciated.

Hello,
I u use DE in VB6, u can add the child command. If u use code to create Grouped RS, u can use shape command.
It is easy fo u to do that .
H.Q.Cuong