Sample Application: FFAssist using Crystal .NET for Visual Studio 2005 - Part 3
page 1 of 5
Published: 18 May 2005
Unedited - Community Contributed
Abstract
In the third and final part of our series creating the FFAssist sample application, Eric Landes demonstrates new features of Visual Studio 2005 Beta 2 and Crystal Reports .NET.
by Eric Landes
Feedback
Average Rating: 
Views (Total / Last 10 Days): 34302/ 85

Introduction

This is the third part of a three-part series examining the new features in Visual Studio 2005, focusing on Crystal Reports.  Part 1 of this series introduced you to the sample application design, new features in Crystal, and some sample code for the admin application. Part 2 goes over the mechanics of creating a report using stored procedures.

In this final part, I will go over binding an object to the report, rather than a query or a stored procedure.  As more developers create business objects for applications, this may be something that a report designer may want to take advantage of.  This part of the sample application will use an automatically created object (a DataSet).  I will show how I created the report, and then how I created the business object as the data source for the report.  Finally, I'll demonstrate populating the business object in a web page,  allowing users to view a report bound to a business object.

System Requirements

I developed this part of the sample application using Windows XP Service Pack 2, SQL Express 2005 (which is included with Visual Studio Team Suite) April CTP, and Visual Studio Team Suite Beta 2.  The exciting thing about the Beta 2 for Visual Studio is that it includes a go live license, so it can be used now for a live site. I am assuming that the reader is familiar with ASP.NET, Crystal Reports .NET, SQL Server, and ADO.NET.  

To set up the database used in the application, do the following.  In the download, a backup of the FFAsistant database is included.  To restore the backup to your version of SQL 2005 Express, execute this command at a command prompt.

Listing 1: SQL Command to install Database

osql -SSERVERNAME\SQLEXPRESS -dFFAssistant -E -q"RESTORE DATABASE
TestDB FROM DISK = 'c:\ffassistantbak.dat'

This should set up the sample database for you with some data in the tables, and the correct table structure.  All code assumes that you use integrated Windows security to access the data.

To set up the Project Files, follow the Readme file included with the download.


View Entire Article

User Comments

Title: Crystal Report for Visual Studio 2005   
Name: waiche
Date: 2006-02-09 9:31:58 AM
Comment:
Help me ! I used Crystal Report in ASP.NET pages with VS2005. When I used ASP.NET Development Server to test, it is ok. But I used IIS Server to test, it throw an error. (Error: Report load fail). Report can't display
(my email: waicheqn@yahoo.com.vn)
Title: Problems about SQLEXPRESS db version   
Name: Sabry
Date: 2005-11-08 10:26:59 AM
Comment:
\S
Title: re: Abdullah Alshuaili   
Name: Daniel Nico
Date: 2005-11-08 7:27:47 AM
Comment:
How do you set a relative path to a datasource location in Crystal Reports? Please let me know how you did this.
Title: very nice   
Name: Abdullah Alshuaili
Date: 2005-09-07 5:22:26 PM
Comment:
Thank u very much a useful page, it was better if u set relative path instead of absloute in case of crystal reports in vb .net !!!!

Product Spotlight
Product Spotlight 



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


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-06-24 3:07:45 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search