Rolling data on Crystal Reports Chart

[iamrahben]

I am trying to display a rolling 52 week period on the chart. Is there a way to get a rolling date so that each week the chart drops off the oldest date. In the report, I counted the weeks and suppressed it, but the data in the charts doesn't reflect it. See below the formula for suppressing older dates. But this doesn't translate on the chart.

{@RUN_count_total} < (DistinctCount ({@WeekOfMon}, {Command.dr_user_fld_2}) - 52)


{@RUN_count_total} -> Counts each week
{@WeekOfMon} -> Each week

Thanks for your help!

 

[Madawc]

Datediff("ww", {your.date}, currentdate) will give you a number, Use record selection to eliminate those that are too early.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[iamrahben]

Thank you SO MUCH! That worked perfectly! You have a wonderful day!