Group footer formula

[Bruni007]

Crystal Reports 9
DB2

My report is grouped by hostname and in the group footer of the report, there is a field which is adding the hostnames in a string

stringvar string1;
string1 := string1 + HOSTNAME + "^";

it works fine except that when I display the value in the report footer, the last hostname is displayed twice at the end of the string

server#1^server#3^server#7^server#9^server#9^

it should display only: server#1^server#3^server#7^server#9^

I've tried to put the formula in the group header, but it is giving me the same result

I don't understand why it adds the last one twice...
any idea?

 

[satinsilhouette]

Are you grouped on that server field so you only get a unique value back for it? The "^" might also be a reserved character, can you use something else instead of that?

 

[lbass]

Your formula is for accumulation. You need a different formula for display in another section, otherwise the new section causes the formula to execute again and accumulate another instance:

whileprintingrecords;
stringvar string1;

-LB