A string with possible multiple values PROBLEM

[Simon2100]

I have a string with possible multiple values (product x, product y, product z, etc.). As soon as I add this field to the report (Crystal Report XI for Maximizer), it generates separate records for each of the products. I would like to have them all displayed in one record. How to do it?

Thanks,

Simon

 

[dgillz]

Please post sample data, current results, and desired results. Table names and relationships would be nice too.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If the phone doesn't ring, it's me".....Jimmy Buffet

 

[lbass]

You can collect the values in a formula placed in the detail section:

whileprintingrecords;
stringvar x := x + {table.product}+", ";

Then in the group footer use a display formula:

whileprintingrecords;
stringvar x;
if len(x) > 2 then
left(x,len(x)-2)

Place a reset formula in the group header:
whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";

Then suppress the group header and detail section.

-LB

 

[MohSheikh]

Nice one! Works a treat thanks


Mohammed