Hello,
I'm somewhat new to Crystal Reports so bear with me. I'm trying to create a running total with a character field and then I would like to display that "total"(concatenated string) in the report footer.

I have my data grouped by GroupNum and I only want to display the strings for the second group.

For some reason, the total string only shows the last record in the second group.

Here is an example of my data:

Letter      GroupNum
A                 1
B                 1
C                 1
D                 1
E                 2
F                 2
G                 2
H                 2

I would like to display this in the report footer: "EFGH"

I have a Formula setup with this code that is placed in the report footer.

Here is the code:

WhilePrintingRecords;
Global StringVar Letters;
Letters := Letters + {Letter}


My problem is that the formula only displays "H" in the report footer.

Any help is appreciated.

Thanks,
Erik

Edited by ejh21 - 08 Dec 2010 at 10:31am

Thank you for your response. That helped. Except now I'm getting these results in the Report Footer: "EFGHH"

For some reason, the last record is showing twice in the total string. Do you what could be causing this?

Thanks again!