Seagate Info 7.5 Crystal Report

[theDeej]

Seagate Info 7.5
Crystal Reports 8.0

I have created a formula field that calculates a growth rate from month to month as follows:

({Statistics.EnrolledUsers} - previous({Statistics.EnrolledUsers})) % previous({Statistics.EnrolledUsers})

Since I'm using the "previous" function, the first record does not have a growth rate value. This is fine, but when I chart the growth rate (line chart), it displays the first record's date, but no value (because there isn't one). Is there a way to get rid of that month column on the chart? Is there a way to tell the chart to ignore the first record?

For the chart, the group axis is the date (month and year) and the data axis is the growth rate value (percentage).

Thanks in advance!

~D

 

[Ngolem]

hmmm...I haven't done this but since the first value is not valid...perhaps you can suppress the formula for that calculation and it won't show up in the chart.

in the conditional suppress of the formula put

whileprintingrecords;
onfirstrecord;

Hope that works. Jim Broadbent

 

[theDeej]

Thanks for replying.

Supressed records and/or fields show up on the chart.