Supressing 0 value Data in a line chart 1

[AJTexDev]

Using CR 8.5 and a line chart tracking 2 data series.
Target Lesson count and
Actual Lesson Count

The Target data comes from a statis table that has the years worth of target data. This is already know and planned for the year.

The Actual lesson Count is live data joined from a different table.

Both Target and Actual data is each set up as a running sum field.

The Target data is fine to show Jan - Dec.

But since we are only in July Once the running sum passes beyond any real data it flattens out showing the current value but still printing a line that runs flat across the remaining months.

I want to suppress the printing of the Actuals unless it has real data.

I can see that a formula where chart date > Current date then "suppress" but there is no suppress options in the code and

although the running sum field is on the report body as group data ( grouped by month)

I set the field to "suppress if = 0" as a formula for the field control but that really doesn't affect the underlying data which the line graph uses. So the line continues on..

This might be a future "feature" CR might consider.

Anyway hopefull this is understandable, and there is a simple way to fix this.


Regards and Thanks BeforeHand

AJ

 

[kenhamady]

What happens if you use regular subtotals instead of running totals, or do you need to use running totals for some reason? Ken Hamady

http://www.kenhamady.com/

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

 

[AJTexDev]

I think I need Running Totals, but maybe not. I want to accumulate (rollup) the lessons done over the months if 10 in Jan and 20 in Feb I want Feb to Show Jan + Feb or 30. Same for the Targets they are a linear because the target value is the same for each month. say 20 per month so Jan = 20 Feb = 40 Mar = 60 etc.

It's when the accumulated lessons Jan-June = say 547 and we do not have July aand later data..

What happens is the line at July through DEc stays at 547.

This is the line I want to suppress.

The Data is actually coming to the Chart from a Union query one table being Target Data which DOES HAve Jan - Dec Data and that's union with the Actual_Lessons table which as a result of the UNIOIN fills in nulls from July - Dec until as we get later in the year...the actual data is accumulated.

I may be causing my own problem using this UNION query but I don't see another way to compare the two on a single chart.

Thanks

AJ

 

[kenhamady]

I think the problem is more in the nature of a running total. You want it cumulative, and a cumulative number carries forward to the end of the report.

You could try giving the running total a reset condition defined as when the date moves past the current month; or giving it an evaluate that says the month is up to the current month; but these may just drop the line to 0 level instead of suppressing it. Ken Hamady

http://www.kenhamady.com/

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