Scheduled report based on Crystal dictionary fails

[tseaman]

I have published a report based on a Crystal dictionary in CE 8.0. It runs fine on-demand, but when I schedule it, it fails with a "cannot open SQL server" message. Both the page server and job server accounts run under the same domain-wide user. Any ideas why this is happening would
be appreciated.

 

[JohnEck]

The dictionary is found on the PC that published the report so the APS cannot find the dictionary. If the dictionary is copied to the server running as the APS then CE will be able to find it. I believe it needs to be in the same path as you have it on the PC running CR. This limitation caused me to dump using dictionaries for reports published to CE.