chart based on formula values

[Tracey]

I am trying to add a chart to a report (containing one subreport) which has many formulas to calculate and display revenue generated by a truck.

In Group Footer 3A
@TheRate = WhilePrintingRecords;
Shared NumberVar TheRate;
TheRate

In GroupHeader 3b
@revenue = {load.weight} * {@TheRate}
@TotalRevenue = WhilePrintingRecords;

NumberVar TotalRevenue;
TotalRevenue := TotalRevenue + {@Revenue};

In Group Footer 2A
@DisplayRevenue = WhilePrintingRecords;

NumberVar TotalRevenue;
@VehRevenue = WhilePrintingRecords;

NumberVar VehRevenue:= {@DisplayRevenue}+ VehRevenue

In Group Footer 1 (vehicle.fleetno)
@DisplayVehRevenue = {@VehRevenue}

I am trying to create a chart that will show the revenue for each vehicle, with dates on the x axis.

"On Change Of Vehicle FleetNo..... show value(s) sum of @Revenue" shows an empty chart.

No data is shown in my chart. What am i doing wrong? Can I base a chart's data on formulae?

 

[mmaz]

Yes, you can base a chart's data on formulas.

Maybe the problem is caused by the shared variable and the chart's location (above or below the section where @Revenue is displayed.)

Where is your chart? Try inserting it in your report footer. Is there data displayed?

 

[Tracey]

no data anywhere... report header or footer :-(

 

[Tracey]

Is it possibly the fact that the formulae are based on a value returned from a sub-report? Can I not chart values based on subreports??