* WITHDRAWN* Urgent - Subgrouping with Datareport designer

[cboffsite]

This is driving me mad....

I have a table with: ID / DATE / TIME

I'm using a data environment & would prefer to stick with it as all my other lists use the enviroment.

What I want to do is to list the number of entries per hour per day.

IE:

12/June/02

12:00 + 2 entries
14:00 + 5 entries
17:00 + 7 entries

Total 14 entries


14/June/02

11:00 + 6 entries
12:00 + 2 entries
15:00 + 9 entries

Total 17 entries

Grand Total: 31 Entries


Using the grouping tab only works for one level of grouping, not 2
I need to use child commands but things get difficult as you can't use GROUP BY when you have to alias fields ie: 'hour(time) as shour'

Somebody please help me?

Thanks

Chris B