Combine records into one? 1

[mbDutch]

Hello -

Not sure if this is possible but:
I have a table that contains a part number, an operation number and a memo description.
Report is grouped by Part Number (1) and detail records would look somewhere along the lines of:

Operation # Description
10 Pull from freezer
20 Cut to size
30 Add coloring
Group Footer

What I want is to combine the memo records into 1 memo record and place it in the
group footer. Is this possible?

I am using Crystal Reports XI on a Progress DB.
Sorry if this was asked before.

Thanks in advance,

Marco

 

[Turkbear]

Hi,
Perhaps a formula in that section that concatenates the Description fields ( should be set to 'while reading records', I believe..)

Not really sure if it will work that way ( I know that concatenation of string fields REQUIRES that ALL records have contents, else the entire concatenated string wil be null)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

More specifically, use a formula like this in the detail section:

whileprintingrecords;
stringvar desc;
if isnull({table.description}) then
desc := desc else
desc := desc + {table.description}+", ";

Add a reset formula like this to the group header:

whileprintingrecords;
stringvar desc;
if not inrepeatedgroupheader then
desc := "";

Then in the group footer use a display formula like this:

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

Then suppress the detail section.

-LB

 

[mbDutch]

Thank you so much. Works like a charm!!