This is the second part of a series of articles that use the free version of Crystal Reports to create ASP.NET web sites using the AdventureWorks sample database. The first part examined the creation of an invoice application. This article will build a quarterly sales report using the cross tab and the charting capabilities in Crystal Reports. The AdventureWorks sample database can be downloaded from http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407 for SQL Server 2008. Download and install the SQL2008.AdventureWorks_All_Databases.x86.msi file.  The sample was written using Visual Studio 2008, but it will work with Visual Studio 2005 as well.  If you do not have SQL Server 2008 you can use SQL Server 2005, but you will need to download the 2005 AdventureWorks samples.

The goal of this article is to create a quarterly sales report that looks like the following figure.

Figure 1

This article will demonstrate how to use cross tabs, charts, create formula fields, attach to tables in a SQL Server database, use the Database Expert to create links between tables, and insert groups in a report.