Subtotaling a group of data within a larger group

[nastenka]

I'm trying to create a report to show a group of orders with detail.

I have a stored procedure that pulls order detail within a date range for a customer.
I want to subtotal each Purchase Order of the individual items on the orders, break move on to the next order subtotal and then it would run a grandtotal for all order on the report for that customer
What is the best way to do the subtotal then move to the next record.
Would you use embedded repeaters and a seperate query.
I can't figure out how to do a group by on the storeprocedure unless I build a different on.

 

[vbkris]

>>I can't figure out how to do a group by on the storeprocedure unless I build a different on.

hi, i think this can be achieved with a RollUp clause.

can i have your query???

Known is handfull, Unknown is worldfull