Building Reports Using ASP.NET and Crystal Reports - Part 2

Print Add To Favorites Email To Friend Rate This Article
Building Reports Using ASP.NET and Crystal Reports - Part 2 - Quarterly Sales Report

page 1 of 15

Published: 15 Jun 2009

Abstract
In this second part of the series, Vince examines the creation of a quarterly sales report with the help of Crystal Reports by using the Adventure Works sample database. He provides detailed coverage of each step including the concept of cross tab reports and date manipulation with the help of relevant screen shots and source code. The article also demonstrates the usage of the Crystal Report Viewer and the Object Model to view the report as a PDF using ASP.NET.

by Vince Varallo
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 16491/ 632

Article Contents:

Introduction

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.

View Entire Article

(Page 2) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 3 and 4 and type the answer here:

User Comments

Title: Awesome
Name: Rusty
Date: 8/27/2009 10:36:14 AM
Comment:
Awesome job. I am a brand new CR user and I found your article to be easy to understand, follow, and very helpful. Thanks and keep them coming.

Title: Superb
Name: ramakrishna
Date: 8/1/2009 6:51:52 AM
Comment:
This article is very good to customise my website,

Title: great work
Name: Ankit Agarwal
Date: 7/28/2009 12:48:39 AM
Comment:
u have done a great work
this article is really helpful

Title: Great Job
Name: yin min
Date: 7/26/2009 5:52:54 AM
Comment:
Thanks for your step by step article.
Everyone who is new at crystal are looking for such a simple and very useful article.
Thanks again.

Title: Well Done
Name: Muhammad Aijaz Rajput
Date: 7/10/2009 10:47:53 AM
Comment:
This is an excellent article. Thanks. I realy need the detailed step-by-step article approach that you take.

Title: Source coming soon
Name: Vince
Date: 6/22/2009 9:20:19 AM
Comment:
The source should be posted soon.

Title: Excellent
Name: Walter
Date: 6/16/2009 4:03:31 AM
Comment:
Hi Vince,

another excellent article. Thanks. I really like the detailed step-by-step approach that you take.

Will the source be available as a download?

Regards

Product Spotlight