473,386 Members | 1,726 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

How to create Report Letter with multiple pages in C# and Crystal Report.Net VS2008

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.
Oct 25 '08 #1
0 3226

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Jason Chan | last post by:
I am beginner on Crystal Report. I want to ask a basic question. How can i display a report in ASP? I search for many web and try the sample from crystal dicussion but no luck, the code does...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
3
by: Fabian | last post by:
Hello, Iam searching for a way to design a letter with Crystal Report. Now I want to imlement a table. I have the Data in a ArrayList, but it will not be able to make a Database, so I need a way...
4
by: Tim Frawley | last post by:
Crystal Reports product version 9.2.3.611 Developement Environment is VB.NET 2003 I have created a report that has several comment fields and a subreport. The comment fields are all set to...
0
by: Anniech | last post by:
I use VB.NET to integrate with crystal report 9.0 to print a report with custom paper size (using Dot Matrix printer). I have already added a custom paper size in the printer server and set the...
0
by: Chris | last post by:
I have the following situation in a VB.Net App I am working on: 1.)A report created in VS.Net 2003 using the CR.Net component of VS 2003. 2.)The datasource for the report is a Stored Proc in a...
1
by: monskie | last post by:
Hello to all, I have a problem which could be trivial to you guys. This concerns opening several crystal reports on the a crystal viewer on an ASPX page by calling window.open. My...
9
by: itmags | last post by:
I need to create a couple of reports, invoices, credit reports, etc... My question is: How/what is the best way to go about this using VB2005 / SQL Server 2000 Crystal Reports? MS Reporting?...
0
by: John Smith | last post by:
Hello, I have 7 different crystal reports that need to be collated. Since I want to end up with a page of each (which all together make a single report), I created a blank main report and then...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.