Another and probably simpler way would be to prepare your cursor with all records (including total) in advance. That's how I tackled this kind of the problems in the past.
>Dear Experts
>
>In report, Is it possible to display grand total more than one time.
>Here is description
>
>230501--------apple---50
>230502--------mango---60
>subtotal--------------------80
>
>230601--------tomato---30
>230602--------potato---40
>subtotaol--------------------70
>
>grand total-----------------150 && here I want to display grand total of 2305 and 2306
>
>230701--------copy---10
>230702--------book---20
>subtotal--------------------30
>
>grand total---180 && this is grand total of 2305,2306 and 2307
>
>Please help
If it's not broken, fix it until it is.
My Blog