Skip to Content

Crystal Reports - Several values of a field in one issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 04 at 02:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded