Solved

Remove Datasource from Crystal Report

Posted on 2008-09-30
2
2,073 Views
Last Modified: 2012-06-27
I have a Crystal Report (Visual Studio 2005 standard) and change the data source at run time:
        crReport.SetDataSource(my DataSet)
        crReport.Refresh()
This has the identical structure as the dataset used at design time.  
The problem is that CR wants to open both the original and new datasets at run time.
I can't see any way to remove the design time data.  It does not show in the Visual Studio Data Sources panel, only in the Crystal Design database/database expert.

Thanks



0
Comment
Question by:John4343
2 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 250 total points
ID: 22610964
Check this article on feeding your report from a data set
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx

Also here is a document to show you how to change the data source.  I think it is on page 131.
http://www.businessobjects.com/global/pdf/dev_zone/VS2005_Walkthroughs.pdf

If you want to change it permanently you can do it in design using
DATABASE --> SET DATASOURCE LOCATION

mlmcc
0
 

Author Comment

by:John4343
ID: 22641067
Thanks.   It's actually page 138 if anyoune else is searching.  
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now