Crystal Reports - Several values of a field in one issue

[tforster]

Hi,

i got the following example:

ID - Value

1 - 1.1

1 - 1.2

2 - 2.1

2 - 2.2

This happens while creating a crystal report because ID one has two values. I just wanted to have the output like this:

ID - Value

1 - 1.1, 1.2

2 - 2.1, 2.2

What is the easiest way to get this in the report?

Thanks a lot

[abhilash_kumar]

Hi Tobias,

1. Insert a Group on the ID field.

2. Suppress the Group Header and Details Sections.

3. Create a formula with this code and place it on the Details Section:

shared stringvar str := str + totext({Value_Field}) + ", ";
'';

4. Create a formula called "reset" and place this on the Group Header:

shared stringvar str := '';

5. Create a formula to display the final string with this code: (Place it on the Group Footer):

shared stringvar str;
Left(str, len(str)-2);

6. You may also want to place the ID field beside this formula field on the Group Footer.

-Abhilash