Problem in Calculating Total

Hi Everybody,

I need to generate report for all the days in a current month. I have to display the total in the folg. way.

Day1 Day2 etc.
Group Name sum of amount sum of amount
from day1 to end from day2 to end
of month of month

upto end of month.

I had a problem in setting the columns. And is there any way to calculate the group wise sum with out creating groups.

If you have any idea, pls. help me

Thanks,
harmonycitraHi,
I dont think it is possible to have groupwise total without creating group. You can group,find sum and suppress group header.

Madhivanan|||Thanks,

But I'd done it by Cross tab. The only difference is,

instead of starting from 1st to 31st, I reversed the order from end of month to beg. of month. So I'm calculating running total easily.

Any way, thank you!