Skip to Content
0

Crystal Reports - Several values of a field in one issue

May 17, 2017 at 10:42 AM

18

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
May 04 at 02:17 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded