NEVER MIND. I FIXED IT! Please disregard this question. I solved the problem.
Solution:
I took out the "=0" in the second line of the formula below and got the result that I wanted. Thanks anyway.

I have CR 8 and I am having trouble with a formula in the report footer. I group my data on year. So I inserted a summary counter to count the number of records per year and report the number at the group level so I have the following groups and group results in my report:

1996 50
1997 100
1998 75
1999 200
2000 150
2001 125

But I want to show these results in the report footer as follows and I am going to suppress the group footer section and detail section:

1996 1997 1998 1999 2000 2001
50 100 75 200 150 125

I am playing around with a formula named records_1997 that is in the report footer, but I can't seem to get a number other than 0. Is this possible to do using a formula? I want a separate formula in the report footer for each year up to and including 2001.

Here's my Crystal formula that keeps giving me 0 result. Thanks for helping.

WhilePrintingRecords;
NumberVar total_annual_arrests_97:=0;
If Trim(GroupName ({arrest.date}, "annually")) = "1997" then
total_annual_arrests_97:=Count ({arrest.date}, {arrest.date}, "annually");
total_annual_arrests_97;