This is the fifth article of a series that uses ASP.NET and
Crystal Reports to build reports using the Adventure Works Sample Database.
Before reading this article it would be helpful to read Part
3, and Part
4, but it is not required. At a minimum you should read Part 1. This
article creates a web service that delivers the Invoice report developed in Part
1. The article then covers creating a web site to consume the web service,
filter the report, and display the report to the user using the Crystal Reports
Viewer control. Reading Part 1 would be most beneficial because I will use the
Invoice.rpt file developed in that article to create the web service. You can
also download the code here to get the
Before you begin you will need to have installed Visual
Studio 2008 with Crystal Reports for .NET. The samples are written in Visual
Studio 2008 but they will work with Visual Studio 2005 also. You also will
need to download the AdventureWorks
sample database for SQL Server 2008. Download and install the
SQL2008.AdventureWorks_All_Databases.x86.msi file. If you do not have SQL
Server 2008 you can use SQL Server 2005, but you'll need to download the 2005
The goal of this article is to create a web page that looks
like the following image.
As stated earlier, this is the same report that was created
in Part 1 of this series. The user can select a customer from the drop down
list and preview all the invoices for the selected customer.