Hi experts, I’d like to have some helps from you guys.
I need to create an app with C# and Crystal Report.Net using VS 2008 for a Landscape & Nursery company. The company will send out coupon letters to some customers who purchased something from the company within past 12 months. Users will get customers’ info from database using zip code. I have a drop-down control to populate all the eligible zip codes. The following 8 data fields will be retrieved from database; FirstName, LastName, Address1, Address2, City, State, ZipCode, and PreviousPurchased. I have a pre-defined Crystal Report Letter Template, something like:
[Address1],[Address2],[City], [State], [ZipCode]
Dear [FirstName] [LastName]
Thank you for purchasing [PreviousPurchased], blah, blah………..
blah, blah……At the bottom of the letter is 15% off coupon for your next purchasing.
blah, blah……
The coupon letter's format and content are fixed. At the very bottom of the letter is an image 15% off coupon. The only differences are the data field with the square [ ], the customers’ info. When a user select a ZipCode, for example, 92649 (Huntington Beach) returns 30 customers, the user clicks on print button, can print 30 coupon letters, and 90895 (Carson) returns 45 customers, the user can print 45 coupon letters.
I know the Crystal Report.Net can create Form Letter, but just don’t know how to. There are too many samples out there for the tabulate kind reports. But I can not find a single sample for Report Letter with multiple pages.
Appreciate for all your helps.