Not Charting Data Correctly

[shelby55]

Hi

I am using Crystal 9.0 from an Access 2003 database.

I have a field that is a shared variable from a subreport and I'm summing it with a field in the main report.

So I have a field called ds_2008_wts which is:
shared numbervar wts_2008;

And another field called ip_wts_2008: if {Data.Fyear}="2008" then {Data.IP_Wt}

Ttl_Wts_2008:={@ds_2008_wts}+Sum ({@ip_wts_2008})

I've done the same above for years 2009, 2010 and 2011.

If I put all of the above formulae fields in the report footer they equal as they should.

I want to graph the variance from one year to the next so I'm using the formula: if {@TtlWts_2009}>0 then
({@TtlWts_2009}-{@TtlWts_2008})*100/{@TtlWts_2008}

Again, this field shows as it should in the footer but if I try to graph (based on all records, maximum of the variance value), it doesn't show as it should and investigations revealed it's because it isn't recognizing the shared variables of ds_weights_2008 etc. The variance it is showing is between the ip_weights per year but not the total weights.

Is there any way to get this to work? Thanks.

 

[lbass]

If you are using shared variables, you have to use the following complex method "Charting on Print-time Formulas":

http://www.sdn.sap.com/irj/boc/go/p...2a54ff4cd?QuickLink=index&overridelayout=true

-LB