Report Automation - Crosstab

[TEM3]

I am using Crystal Reports 8.5:

Our admin needed a report that would total pending/backlogged (>30 days/>30 days) open assignments as a snap shot of the last 7 years. I created a cross-tab report that totaled the desired numbers but had to run it 7 times (9/5/2002 through 9/5/2007) using a parameter to enter the seed date.

I would like suggestions as to how to automate this process by entering a starting date (say 9/5/2002) and having it increment by year (or month or whatever) as a group so that the cross-tab would run in the group footer for the appropriate date.

Here is the formula I used to select the appropriate records:

//@IsOpen

if ((isnull({ALL_ASSIGNMENTS.Date Completed})) and ({ALL_ASSIGNMENTS.Date Assigned} <= {?ReportDate})) then "T" else
if ((date({ALL_ASSIGNMENTS.Date Completed}) >
{?ReportDate}) and ({ALL_ASSIGNMENTS.Date Assigned} <=
{?ReportDate})) then "T" else "F";

 

[Madawc]

is there a reason why you can't have an extra higher group for the seven years? DatePart or DateDiff should be OK for this.

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