• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1177
  • Last Modified:

Update all Crystal Reports in the CMC to a new datasource at once?

We are setting up a completely new environment for our Cimpro database which means I must set up a new ODBC data source.  Is there a way, once I've done this, to switch all of the Crystal reports that have been previously set up in the Central Management Console to the new datasource at one time?  I have over 1200 objects that need to be updated and would really hate to do them individually!

Thanks!
0
cjtumlin
Asked:
cjtumlin
  • 3
  • 2
1 Solution
 
mlmccCommented:
When the new source is ready will the old source still be available?

You could setup the ODBC to have the same name so when you switch it will use it.

There is a tool rptIspector that claims it can do it

http://www.softwareforces.com/Products/rpt-Inspector-Enterprise-Suite-for-Business-Objects-and-Crystal-Enterprise

mlmcc
0
 
cjtumlinAuthor Commented:
I'm not sure if the old database will go away immediately or not.  Has anyone out there ever used rptInspector? Have any experiences to share?
0
 
mlmccCommented:
I haven't.  I have read some good things on it and generally Ken Hamady doesn't link to tools that don't work as advertised.  I got the link originally through his site.

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

mlmcc
0
 
mlmccCommented:
0
 
cjtumlinAuthor Commented:
Thank you mlmcc!  I read Ken's review and I, too tend to trust his opinions.  I think I'll give it a try.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now