Rollup feature within a record set

Does anyone have the experience of using groupby ... rollup features with the creation of a record... via SQL?

I having difficulty while trying to use this SQL within a DataEnvironment and Datareport...

Thanks,
Marc

I've used them rarely.

Thanks anyways...

I think I going the groupby & pivot route within a sql statement...

Marc

------------------