Hello all

I'm fairly new to CR and have been thrown into the deep end with our new reports system.

I have a report which contains a formula for calculating the retention of our students, I want to put this in a chart but it is not available as an option in the chart expert.

Here is the report info.

CurrYearRet formula:
{#CompCurrYear} % {#StartsCurrYear}

This takes these two running totals and shows one as a percentage of the other.

CurrYearRetTotal:
{#CompCurrYearTotal} % {#StartsCurrYearTotal}

This is pretty much the same as the above, using two running totals which are identical to the two in the first formula accept that they act as totals and so do not reset.

The report is grouped by the name of the school.

I need to show the report with 1 bar for each school showing the result of CurrYearRetTotal, but it is not available in the charting options.

CurrYearRet and the School Name is in GroupFooter1.
CurrYearRetTotal is in ReportFooter, which is where I want the chart to be.

I understand from a bit of googling that Crystal has some issues with formulas in charts, depending on where they are in the report, but I cannot find a solution that works for me.


Apologies if the above is not terribly understandable, but I'm not quite sure how to explain it without going into several posts!

If anyone can help I would be eternally greatful!