I am using Crystal Report XI R2.

I have some customers that give specific instructions for some of the parts they order from us.   We enter those instructions into our ERP which then splits each line of the instructions into its own, separate, up-to-50-character, record in the db by Part ID and Customer ID.

I have a subreport that pulls those instructions, but the formatting is terrible.  I have written formulas to combine all those records into one field, but it repeats the last record or if only one record, it repeats that.

Here are my formulas:

Instruction 1:

WhilePrintingRecords;
Global Stringvar Notes;
Notes:= Notes & {Standard_Notes.NOTE_46}

Instruction 2:

WhilePrintingRecords;
Global Stringvar Notes:=""

Here is how I have inserted the formulas into the subreport:
GH1      {@Instruction2}
Details  {@Instruction1}
GF1       {@Instruction1}

I have suppressed GH1 and Details.  I end up with Notes like this:

Several lines/records:

Target is 6-8psi. Do not exceed 9psi.  Flag seams.  Mark the color of the sponge on the labels, including black.  on the labels, including black.

Only one record:

Use Whiting pallets. Stand rolls on end.  Use Whiting pallets. Stand rolls on end.

How can I prevent the last (or only) record from duplicating?

Edited by GrisCorp - 15 Oct 2014 at 3:38am

That did it!

Thank you, z9962!