Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Migrate 100 reports from crystal 5.0 to 8.0

Status
Not open for further replies.

Supermary

Programmer
Apr 11, 2003
1
PA
Hi, I need to migrate, urgently, 100 reports from crystal 5.0 to crystal 8.0. Which is the best method to do this?

 
Wow!
The only thing I can think of is to open each report in 8.5, verify the db and then save it as the 8.5 format. It will be a bit of work, but I don't know another way. I'll be watching to see if there are any other suggestions.

Bob
 
Check this:


The description is very wordy which may mean that it's more marketing than substance, and I couldn't handle wading through the excess verbage so it may even mention it in there somewhere, but I couldn't tell whether it does database changes, perhaps if you email you can get some straight answers from a non-marketing/sales sort.

-k
 
According to their documentation, the ".rpt INSPECTOR" utility can READ Crystal Reports 5 to 8.5 and WRITE versions 7 or 8.x

This makes full sense since they are probably using CR 8.5 developer, which can export a Crystal report to either version 7 or version 8.5

Bottom line: contact them and ask... :eek:)

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
Have you heard of "re-crystallize"? Don't know how good the product is but I understand it's quick at converting reports...
 
SuperMary,

synapsevampire and IdoMilletWe are absolutely right (thanks).

We make a product called .rpt Inspector(TM). The current released version 1.00 (released October 2002) supports doing this (and a lot more across the same report or a batch of reports).

You can open as many reports as you'd like (memory and cpu permitting) and save them in 8.x format. You'll need to change at least 1 property (can be any) so that it will know something has changed to save. It can be as simple as deleting a space in the title and putting it back.

Basically what you'd do is open all the reports you want. Select all of them. When all are selected, changes are applied automatically across all selected. So change the title (delete a space and put it back). It will mark the reports as changed and show both the report and property you changed in red to indicate this. Then from the File menu, select Save. It will display a list of all your open reports and again will display the ones that have changed in red. Select all, then click on Save again there and it will now write out those reports in 8.x file format.

That's just one of hundreds of things you can do with .rpt Inspector. It is designed to allow you to edit, audit, and analyze all the different objects and their property values. And it's designed to allow you to do that to a batch of reports. For example, standardize formulas, headers, etc.

On our website is a set of animated quick guides, including.

You can download the existing version for a 30 day free trial.

Our next version is now finishing beta testing.

Here's a little bit of what else the upcoming version does:
o data source / database conversion and migration (we can now do things like... batch set location, batch convert from ODBC to Native Oracle, batch convert from OLE DB to Native SQL Server, etc.)
o spell checker
o search and replace (search for all instances in as many reports as selected for "(c) Acme Corp" and replace with "(c) Whatever You Want" or for table names, formulas, etc...
o report "play" lists (need to modify the same sets of reports all the time? add them to a report list, then with 1 click open them all)
o copy default parameter values from a master and propagate to selected

and a lot more....

Don't know if you had chance to stop by our booth at the 2003 conference for the Crystal Users Group of North America in Vancouver, Canada May 21-23, 2003... We were giving demos and beta copies of 2.00.

You can also sign up to be part of this limited beta program.

Hope that helps.

Software Forces, LLC
makers of .rpt Inspector(TM)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top