Solved

DB Connectivity on Crystal Reports

Posted on 2014-02-13
3
242 Views
Last Modified: 2014-02-24
Hello All,
We recently had a migration of our app. The crystal reports have to updated with the new DB connection.
Is there any tool which can do a bulk update on all the rpt files to point to new Db.
Thanks
0
Comment
Question by:Star79
[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
3 Comments
 
LVL 18

Accepted Solution

by:
vasto earned 250 total points
ID: 39857006
http://www.r-tag.com/Pages/CRDataSource.aspx but this version supports just one connection per report
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 39857092
There are 3rd-party tools that claim to be able to do that.  I haven't used any of them so I don't know for sure if they work or not.

Ken Hamady's site has a good list of the tools and he has a review of them every year.

http://www.kenhamady.com/bookmarks.html#doc

mlmcc
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 39857162
What's changed about the data connection?  It might just be as simple as changing the server that an ODBC DSN points to.  Is it a matter of you having moved data to a new database or a new database engine?  How do you currently access the reports?
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone 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

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

733 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