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 1, Part 2, 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 report file.

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 AdventureWorks samples.

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.