Creating a Chart with Formula

[Petendbh]

In Crystal 8, I was able to create a bar graph in the advanced chart expert using a formula I created in the formula expert. However, in 8.5, my formula does not even show in the chart expert.

Simple formulas are available to me in the chart expert; however, the more complicated formulas don't show. Any suggestions?

 

[kenhamady]

Not all formulas are eligible for charting.
If they include a summary function (Sum, count,Maximum) or if they use a 'whileprintingrecords' variable they will not be eligible.

If not sure, post an example. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Petendbh]

I was able to resolve the problem!! I faked out the chart expert by "commenting out" the code in the formula expert and created a new formula (i.e. "If true then 1&quot. By doing this, I was able see the formula in the chart expert. I then created the bar chart. I went back to the formula, took off the "comment" and saved the formula. The chart displayed the correct data.