Create a bar chart from a Formula

[shaleen7]

I created a formula where I calculate the difference between the current date and the expiration date of a product and then I take the average.


I placed this formula in the Summarize field section
DateDiff ("yyyy", CurrentDate, {VTABBRE.DATEXP}) and then I selected average in the calculate this summary field. The average number is correct but is there any way I can create a bar chart. The insert chart option is unavailable for this report.

Ultimately, I going to combine reports because each bar graph contains slightly different criterias so I want the bar graphs to stagger each other.

For example:
Total Average Product Life
Bar Graph 1 8.5 years
Bar Graph 2 7.5 years
Bar Graph 3 10.3 years




Any suggestions?

Thanks.

 

[rosemaryl]

Dear Shaleen,

You didn't indicate what version of Crystal, what driver, and what database.

When you say the Insert Chart option is not available, are you saying that Insert Chart is grayed out?

If what you are saying is that the formula for average is not available, then typically what you do is to choose a field or formula that contains the value for the record that you want to get the average for and insert that, then in the show value section choose the value and select change summary type. Now you can choose average rather than sum and it will average according to the On Change of Value for your chart.

If I have failed to understand the problem, please provide more facts.

Regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.