How to fix report if SQL Server database name got changed

[yurok]

Hi guys,

I am sure some of you ran into this issue- database name got changed, or owner name got changed for SQL Server.
Does it mean that all reports need to be redesigned?
I've change DSN to point to the right one, but Crystal Report doesn't fix it. I am using 8.5 version, is there any way to do it without redesigning the whole report?

Thanks a lot

 

[Turkbear]

Hi, Open the report in CR and click on Verify Database ( under the database menu)..

It will ( should, if structure is the same) update the report to usse the new source..

 

[synapsevampire]

You may need to use Database->Set Location if Turk's suggestion does not work.

-k

 

[fredp1]

Unfortunatly I had the same need a few weeks ago to change a dozen or so reports and changing the ODBC DSN detail is simply not enough.

I'd recommend that you do a set location then do a verify. The set location is the action that will make CR point to the new db.
The verify is to make sure that table hasn't changed in structure.

There are tools that will allow you to change your reports in bulk. I think rtpInspector may do it.

Cheers
Fred

 

[yurok]

Guys,
thanks all for your great help actually Set Location does it(something) that I think version 7 failed to do.
Fred, I don't know about fixing them in bulk, I have only 8 with this issue so I guess would be faster for me just to go one by one.
Thanks all again