Running Total 1

[busi1]

Hi,

I have a report which Looks like this:


Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec
Budget
Forecast
Committed
Spent
Accrual
Total

All the five fields in this report ( Budget, Forecast etc..) are caluculated fields in the view i created for this report. I have 6 Cost centers for this report and i grouped the data on cost center.i want the report to be displayed in this way

Cost center :1
Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec
Budget
Forecast
Committed
Spent
Accrual
Total

Cost center :2
Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec
Budget
Forecast
Committed
Spent
Accrual
Total

Cost center :3
Jan Feb Mar Apr May June July Aug Sep Oct Nov Dec
Budget
Forecast
Committed
Spent
Accrual
Total


I created running totals for all the fields ( eg: for budget i created 12 running totals for 12 months and in the same way for other fields).

I am evaluating the running total on a formula:
{Table.Period}=1 and so on.
and reseting the running total on change of group (cost center). When i run the report with this criteria report is not displaying any data.

When i evalute the report based on change of Group (cost center) and reset it on change of group (cost center), report displays the wrong data.


I am using Crystal report 10.0 and Oracle 10g.


Help is appreciated


Thanks

 

[lbass]

Please do not post the same thread in multiple CR forums. I responded to your other post.

-LB