Solved

DB Connectivity on Crystal Reports

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

776 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