Building Reports using ASP.NET and Crystal Reports - Part 3 - An Invoice Report Using Disconnected Data
page 1 of 4
Published: 20 Jul 2009
Abstract
In this third part of the series, Varallo shows how to rebuild the Invoice created in Part 1 using disconnected datasets instead of connecting directly to the database. This gives the user the flexibility to manipulate the data and implement rules in a c# business class rather than in the report. He provides a detailed overview of each concept in a step-by-step manner supported with screen shots and source code.
by Vince Varallo
Feedback
Average Rating: 
Views (Total / Last 10 Days): 37480/ 376

Introduction

This is the third 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 have read Part 1 and Part 2, but it is not required. This article focuses on redeveloping the Invoice created in Part 1 using disconnected datasets instead of connecting directly to the database. Using disconnected datasets gives the developer the flexibility to manipulate the data and implement rules in a C# business class rather than in the report.

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 as well.  You also will need to download the AdventureWorks sample database 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. 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 an invoice that looks like the following image. 

Figure 1

If you have read Part 1 then you will notice that this is the same report. If you have not read Part 1 then this article will also demonstrate how to use master\detail records, create formula fields, use variables in a report, insert groups in a report, dynamically format groups using the Section Expert, and how to create summary fields.


View Entire Article

User Comments

Title: Report   
Name: Sagar
Date: 4/5/2010 5:42:37 AM
Comment:
Hi,

I am not able to see any data on the report and instead it shows blank columns.
Please Help
Title: Nice Article   
Name: Rick
Date: 12/1/2009 2:17:51 PM
Comment:
The example was very easy to follow. Thanks for taking the time to document. I am sure I can apply this imformation. I renamed my default.aspx from Part 1 and it worked well. It would have been nice to build all tutorials on the same page, however it was still a great article.
Title: vineet   
Name: vineet
Date: 11/14/2009 8:40:46 AM
Comment:
I can See the group Tree But I Can we resize group Tree.
Left nevigation always show to see the group items.
If i press Group item Item is on the lower side of the page.I have to scroll up.Can we set group item and its child aligned.

Product Spotlight
Product Spotlight 



Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2014 ASPAlliance.com  |  Page Processed at 12/17/2014 7:55:27 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search