Solved

DB Connectivity on Crystal Reports

Posted on 2014-02-13
3
239 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
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

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

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 …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

947 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

22 Experts available now in Live!

Get 1:1 Help Now