Formula Count Problem

[borisbe]

I have a table with ID, task # and forward date. Example:

ID Task # Forward Date
1 1 01/01/2006
1 2 01/03/2006
1 3 01/05/2006
1 4 01/07/2006
1 5 01/09/2006
1 6 01/10/2006
1 7

2 1
2 2
2 3
2 4
2 5
2 6

3 1 01/10/2006
3 2 01/17/2006
3 3 01/18/2006
3 4 01/18/2006
3 5 01/18/2006
3 6 01/18/2006
3 7 01/20/2006


I need two total fields:

1. If the last task # per ID has no date in the Forward Date field but at least one of their task #s has a date then count it.

This field would have a total of 1 since ID #1 has 7 tasks and task # 1 to 6 have a date but the last task #7 does not have a date.

2. If all of the task #s per ID have no Forward Date then count it.

This field would have a total of 1 since ID #2 has 6 tasks and all of the tasks do not have a date.

ID# 3 would not be counted since all tasks have a forward date.

I'm using Crystal 8 with a csv file and I've grouped the report by ID then task #.

Help would be appreciated.

Thanks

 

[lbass]

Try:

//{@cnt} to be placed in the detail section:
whileprintingrecords;
numbervar cnt1;
numbervar cnt2;

if
(
isnull({table.forwarddate}) or
{table.forwarddate} = date(0,0,0)
) and
{table.taskID} = maximum({table.taskID},{table.ID}) and
(
not isnull(maximum({table.forwarddate},{table.ID})) or
maximum({table.forwarddate},{table.ID}) <> date(0,0,0) then
cnt1 := cnt1 + 1;

if
(
isnull({table.forwarddate}) or
{table.forwarddate} = date(0,0,0)
) and
{table.taskID} = maximum({table.taskID},{table.ID}) and
(
isnull(maximum({table.forwarddate},{table.ID})) or
maximum({table.forwarddate},{table.ID}) = date(0,0,0) then
cnt2 := cnt2 + 1;

Then in the group footers, reference these with separate formulas to show the counts as they accumulate per group, and/or add these to the report footer:

whileprintingrecords;
numbervar cnt1;

whileprintingrecords;
numbervar cnt2;

-LB

 

[borisbe]

Thanks LBass. The formula worked great. This is the best forum ever and it is because of people like you willing to take the time to help others.