I am very new to Crystal reports...basically I have learned enough to be a danger to existing reports everywhere.

 

I am attempting to add a pie chart to a subreport. The main report uses a SQL db for the majority of the data. The pie chart hits an Access DB table which contains a calculated field.

 

I tried to add the Access table to the report but the chart will no generate at all.

 

I have since been trying to figure out how to get the crystal report to create the calc'd fields on the fly...without success at the moment.

 

As an FYI, this crystal is a participant statement of 401k activity. The chart is actual fund allocation percentages used to compare against investment elections to see quickly if a rebalance should be done.

 

Any suggestions or tips to point me in the right direction would be greatly appreciated! Thanks!