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