Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combine records into one? 1

Status
Not open for further replies.

mbDutch

MIS
Nov 13, 2007
39
US
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
 
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)



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top