Running Total

[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.

Can i evaluate the running total on change of group and formula together?

I am using Crystal report 10.0 and Oracle 10g.


Help is appreciated


Thanks

 

[lbass]

Try an evaluation formula like:

(
onfirstrecord or
{table.costcenter} <> previous({table.costcenter})
) and
{table.period} = 1

-LB

 

[busi1]

Hi ibass,

I tried Using that evaluation formula, its giving me a blank report.

 

[lbass]

I think you need to lay out the fields you are working with in the detail section and see what gets populated.

Are you sure there are budget figures, etc., available for each month/period by cost center to begin with? You say these are already calculated fields, so either they are calculated by period by cost center so that there is no need for running totals (in which case it seems there would be no need for running totals) or the figures are for the entire year and need to be prorated or something like that.

I think you need to show us what the detail level data looks like in addition to what you've already shown us.

-LB

 

[busi1]

Hi LB

I tried evaluating the fileds using that formula and placing all the fields in detail section, but all the fields for each cost center are populated multiple times(cost centers displayed multiple times)

I have budget and other funds for all the periods ( i checked it by running the report based on the cost center parameter. Report runs perfectly when i use parameter for costcenter and place all the fields in the report footers( eg: budget, committed funds etc in different report footers)

All the fields are caluculated i mean i have caluculated the sum for all the fields for the entire year and break down by periods in report.

Thanks

 

[lbass]

All I meant for you to do by placing the fields in the detail section was to get an understanding of how your data is behaving--this wasn't meant as a suggested solution.

It sounds like you might be able to insert a group on cost center and then place all of the relevant fields in the group footer or group header, suppressing the detail section, and without using any running totals (if you didn't need to use them in the report footer when using a cost center parameter).

-LB