on 2008 Jun 03 9:19 PM
Greetings,
I need a way to turn detail lines into a list that I can place into the group footer.
ex.
Group 1 header:
Detail lines:
a
b
c
d
Group 1 footer:
a,b,c,d
I figure I need to create an array, load it then loop thru and unload it... but I don't know the syntax - can anyone help ??
Thanks in advance!
Hello James,
I'm using Crystal Syntax:
You'll need to initialise a string variable in the group header. Create a formula as follows, and place it in the group header.
whileprintingrecords;
stringvar names := "";
Then create a formula which adds the names to the string variable you created. Please it in the details section.
Whileprintingrecords;
stringvar names := names + {Employee.First Name} + ", ";
Now you are ready to display the result in the group footer field. Create a formula which displays the name, and use the left function to trim the the trailing comma and space to make it neat.
whileprintingrecords;
stringvar names := left(names,length(names)-2);
Hope this helps.
Fritz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.