Solved

Remove Datasource from Crystal Report

Posted on 2008-09-30
2
2,161 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

759 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