Data Source Options 2

[biggerV]

The background: I am working in a Crystal Enterprise 10 environment accessing Oracle databases. The DBA is currently in process of moving the data to new warehouse that he is creating on a new server. He has asked me to run tests of the Crystal reports that run on Enterprise against this new server. I copied all of the report structures to a test directory on Enterprise and have started to point these reports to the new data warehouse.

The problem: When I open these reports up in Crystal reports and change the data source location and run the reports in Crystal Reports 10, the reports run fine. I save the reports back to Enterprise after a successful run. When I then go back to Enterprise and try to schedule the report, the data source has not been updated; in fact the new server isn’t even listed as a potential data source. All of the reports fail at this point with "Unable to connect: incorrect log on parameters."

If I do a save as after a successful run in Crystal Reports, then save the report to a new location and try to run the report from Enterprise, everything is happy. The new Data Source is listed, and the reports run fine.

Obviously I want to avoid doing this process with over 200 reports, and I am hoping that someone can point out if I am doing something incorrectly, or have just forgotten a step. Any advice or suggestions would be much appreciated.

V

 

[Turkbear]

Hi,
When a report is republished ( or resaved, or refreshed) the database password is cleared ( for security reasons) UNLESS, under the Refresh Options tab on the Properties page of the published report, you uncheck the one about refreshing the default database..

The database connection shown in the left hand panel of the database tab will be the same as originally in the report, but the actual connection info ( in the center of that page) should show the 'actual' connection info..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

You've never been able to set the data source by changing it in CR and then saving to CE, you need to change it in CE.

Your second and 3rd paragraphs appear to same the same thing only you claim different results.

There are 3rd party products that do this, such as APOS:

http://www.apos.com/InfoScheduler/

Someone posted a script recently intended to do this as well, but I can't find it now.

-k

 

[synapsevampire]

Turk: Are you saying that you can preserve the original datasource when a new report is published?

I've never heard of that but I'd like to learn more.

I understand the republishing part, but not with new reports.

-k

 

[synapsevampire]

And have a look at this:

http://support.businessobjects.com/library/kbase/articles/c2016379.asp

-k

 

[Turkbear]

Hi Synapse,
for NEW reports ( not ones opened from the repository and resaved to it, using CR), the publishing wizard handles that ( as you no doubt know) , but using the 'Save As' from CR does not preserve that info and, in fact, has the 'Prompt user for Database logon' option selected..









To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[biggerV]

Thanks to both of you!

Turks recomendation worked perfectly. Outstanding.

Synapse, apparently you can change the data source in CR and save to CE. The second and third paragraphs are admittedly confusing. What I was attempting to state was that if I uploaded the report as a new report I had no problems, sorry for the confusion. Thanks for the very helpful link, that is going to save me some time.

You both have been a huge help..Stars for everyone! Thanks again.

V

 

[synapsevampire]

OK, thanks Turk, that's what I thought.

-k