You can create a string representation of an array using several formulas.

You will need:

-one formula in the report header to initialize an empty string.
-one formula in the group header that will append the group name to it (assuming you group on "client1" etc)
-one formula in the detail section that will append the code to the string
-one formula in the group footer section to insert new-line characters (use the chr() function for this)
-one formula in the report footer that will print the string.

All formulas should use the "whileprintingrecords" keyword. They will all use the same global variable.

An example initialization formula would be

whileprintingrecords;

global stringvar output := "";

and a group header formula would be

whileprintingrecords;

global stringvar output := output & " " & {group_name}

In the end you should get something like



Dealing with the comma at the end may be difficult.

Edited by Keikoku - 11 Apr 2011 at 6:39am

whileprintingrecords; //set evaluation time
stringvar x; //declare variable
if {Axis1Link.RANK}=1 then
   x := x & {Axis1.Code} & ", ";

Unless you are using basic (which I've never used), & is the crystal syntax for concatenation.

Edited by Keikoku - 11 Apr 2011 at 9:43am

Not sure what more there is to explain.
Which part are you having trouble with?

Your display formula seems quite complicated.

It doesn't seem like an array is necessary in this case if you only want to show information.

Array is only necessary if you need to store multiple records and retrieve them at the end.

You should able to construct your string "as you go" and just print it out at the end.

You should construct your string in that fashion then.

x := x & " " & {code} & "." & {rank} & ", "

Then if code = 501 and rank = 1, you will have something like

501.1, 502.1, ..., 509.1,

If the last comma is aesthetically unpleasing, then in your print formula you should write

x[1 to length(x) - 2)]

This basically says to print everything except the last two characters, which from above we can see is the comma followed by a space.

Edited by Keikoku - 11 Apr 2011 at 5:13pm

Do you want to display it in the *report footer* or the group footer?

I think the display should be fine in the group footer.



This is why it's resetting.

Edited by Keikoku - 12 Apr 2011 at 3:11am