Create Crystal Reports on the Fly using ASP.NET
page 1 of 4
Published: 03 May 2005
Unedited - Community Contributed
Abstract
An article that shows some methods that simulate creating a Crystal Report on the fly in an ASP.NET application using Crystal Developer 10.
by Eric Landes
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 75643/ 113

Introduction

[ Download Sample ]

Those of you familiar with Crystal are probably asking, what exactly I’m smoking?  You can’t create Crystal Reports on the fly, at least not with Crystal .NET.  So I’ll admit this title is a little misleading.  But I will show you how to dynamically create new looking reports by using an existing report.  I consider that close to creating reports on the fly.

I’ve seen many .NET developers asking how to add fields to existing reports or how to altogether create a Crystal report on the fly, in code.  The answer for those using Crystal .NET is that it can’t be done.  However, using Crystal 10, I’m going to show you how to come close to dynamically creating your report.

System Requirements

This code was created using Visual Studio 2003 Enterprise Architect, Crystal Reports 10 Developer Edition, and SQL Server 2000 on a Windows XP SP2 machine.  I also have the Northwind sample database installed on my SQL Server and I utilize the 1.x version of the Microsoft Data Access Application Blocks in some of the C# code.  I’m also assuming that the reader has experience developing with ASP.NET, C#, Crystal Reports, and SQL.


View Entire Article

User Comments

Title: drag and drop   
Name: mohit
Date: 2006-02-16 7:33:35 AM
Comment:
Hello Sir,

i m trying to make project using drag and drop function.but my problem is that when i m try to connect two or more picturebox using lines , i cant do it . if i clear or refresh the lines then at a time only one line is possible and i cant draw lines with other boxes .
i need ur help . can u tell me how it is possible.

email id :- rathod_mohit20@yahoo.co.in
Title: Query   
Name: Murali
Date: 2006-01-26 11:39:56 PM
Comment:
Sir i want to generate a crystal report with dynamically a table is generated on runtime.is it possible
Title: need creating a crystal report   
Name: d pavan
Date: 2006-01-20 10:34:44 PM
Comment:
Dear friend

I need a code to create a crystal report using a sql database, with vb.net as backend code
Title: Nice code but one more clarification   
Name: jalaj
Date: 2006-01-11 11:54:59 PM
Comment:
i have one scenario in which i have certain bills which are to printed and bill page no I m getting from database so now if I want to manipulate the page no for last page programmatically then how to do that
Title: great   
Name: navaneethkrishnan
Date: 2005-12-27 12:01:01 AM
Comment:
the article is great and really useful. wish you good luck.
Title: Nice Article   
Name: Sunny
Date: 2005-12-13 9:58:36 PM
Comment:
Hi Eric,
This is article is very nice. And downloaded the sample but somefiles are missing in the project. It's asking for customerOrders.cs file and we couldn't find SQLHelper class file. "The referenced component 'Microsoft.ApplicationBlocks.Data' could not be found". Can U please send me those files. It will be very much useful to me. Thanks, Sunny
This is my Mail Id : laxman.rd@gmail.com
Title: AssemblyInfo.cs   
Name: Chris
Date: 2005-11-29 3:15:11 PM
Comment:
I try to run the report.It didn't include the AssemblyInfo.cs file in that zip file. could you send the "AssemblyInfo.cs" file to my Email chris_chin192@yahoo.com
Thank.
Title: Crystal Report   
Name: Vishal
Date: 2005-09-08 5:33:42 AM
Comment:
If Noboby Having SqlHelper class Then What We Will Use instead of SqlHelper Class
Title: Can I?   
Name: Shararti
Date: 2005-08-19 8:12:10 AM
Comment:
How can i configure a Crystal Report @ Run Time, Means that Creating a DataSet @ Run time and other things?

Thanks.
Title: GREAT !!!   
Name: Nimesh Sheravia
Date: 2005-07-30 8:10:10 AM
Comment:
Great Code that will help me for my application development.
Title: Not Working   
Name: Rukku
Date: 2005-07-28 3:53:26 AM
Comment:
my mail ID : reddy.ruk@gmail.com
Title: Not working   
Name: Rukku
Date: 2005-07-28 3:49:18 AM
Comment:
its saying invalid cast, any reponses appreciated

thanks
Title: UR CODE NOT WORKING   
Name: anupama
Date: 2005-07-26 10:58:29 AM
Comment:
Hi,
I tried to run ur code by just using a single line by converting it to vb.net
oRpt.SetDataSource(dsCust1);
((FieldHeadingObject)oRpt.ReportDefinition.Sections[4].ReportObjects[1]).Text="Category"

But it is not working it gives error invalid cast.

Could you plese help me why is this coming
email: anupama_lakhanpal@satyam.com
Title: CustomerOrders.cs missing   
Name: govinn
Date: 2005-06-29 9:36:02 AM
Comment:
CustomerOrders.cs file is needed for the project. But it is missing in the download.
Title: Thanks   
Name: Caleb
Date: 2005-05-31 12:30:13 AM
Comment:
Sir,
This is Caleb. I thank you for your kind reply.

caleb
Title: Nice   
Name: Caleb
Date: 2005-05-30 7:43:33 AM
Comment:
sir,
This is Caleb. I've downloaded your sample on how to dynamically create new looking reports by using an existing report. But you didn't include the AssemblyInfo.cs file in that zip file. It will be more usefull for me if you send me the "AssemblyInfo.cs" file to my Email id
caleb.sathiyanathan@inmail.tranquilmoney.com
Thank you
caleb

Product Spotlight
Product Spotlight 



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


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