Form Letter with repeated field

[wishiknewmore]

I'm jumping into my first attempt at a form letter and having a bit of a problem. First I'll explain what I have, then what I want to happen.

I have a basic CR (v8.5) report that lists customers with outstanding invoices. The report has one group, the customer name. below that, in the details area, it lists each invoice meeting certain criteria (age, amount outstanding, etc). This is working perfectly.

Now, based on that report, I've built a form letter to send to each customer. The closest I can get is a separate letter for each invoice. What I need is one form letter for each customer and a listing showing all invoices meeting the given criteria.

Can it be done? If so, how? Am I asking too much?

 

[IdoMillet]

Just group by Customer at level 1 and by Invoice at level 2.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

If you insert another Group#1 section (GH#1_b), you could place your letter there, and then display the details below to show the invoices.

-LB

 

[wishiknewmore]

Thanks for the replies. I'm still fooling around with this thing and can only seem to get it right by doing the following:

GP 1 (supressed) Customer
GPH #1b Basic letter showing heading, intro, customer name and reason for letter.
GP 2 (supressed) Invoices

GP2F lists invoices

GPF 1 Remainder of letter and signature.

I doubt if this is the "real" way to do it and it looks like a mess on the screen, but seems to print with the required data.

I had assumed (and hoped) the letter on the screen would all be in a single text box similar to the following:

=================================

Dear [customer_name],
blah blah blah
The following invoices are over due, blah blah blah
[invoice #1]
[invoice #2] (as necessary)
[invoice #3] (as necessary)

blah blah blah

Sincerely,

The Boss

======================================

 

[lbass]

This IS the best way to do it, I think. Didn't realize from your first post that you wanted the invoices embedded in the body of the letter.

-LB

 

[wishiknewmore]

Great! Thanks for the help.

Cheers