Crystal Reports XI Help

[adam84]

I created a field called counter, which get increased by 1 everything a record is retrieved and it will restart back to one every time it reaches 3.

 

Formula Field: counter

numberVar c = 0;
Whileprintingrecords;

c := c + 1;

if  c > 3 then
c := 1;

 

I have another field that I want to concatenate the results together

StringVar data;

Whileprintingrecords;
    data & {@fieldName}

 

 

The last field I have, I want to have the

{@counter}

 

But for some reason when I run the report I get the result of

0

0

0

1

D

 

Not

1 2 3 1

 

My problems are that my counter isn’t working correctly and the data isn’t being concatenated together, it seems like there is a line break after the data.

Any help? Thanks