Error using Report Distribution Expert

[pamplemousse]

Hi Again!

I wrote a few report using CR SQL Designer witch are link to CR Designer. When I run them on my computer or any computer witch have CR installed, everything work fine.

The problem is that when I want to distribute these report using the Report Distribution Expert I get an error that tells me "Cannot open SQL server". It suggest that I make sure that the report was generated in this machine or can be refreshed int this machine, witch is true.

I used an ODBC-CROR7 driver to access an Oracle Database when I created my .QRY, then I link a regular report to that .QRY. (The .QRY file does not have save data checked because I want it to refresh data on every print)

I'm sure forgetting something that will make me go dough! But this problem has been bothering me for a will.

Thank You!

 

[kenhamady]

See if the following helps:

http://support.seagatesoftware.com/library/kbase/articles/c2005632.asp

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal