Subreports using Distribution Expert in 8.5

[maryjo2001]

i have created a report that uses subreports. i compiled and ran the distribution export with no problems. i installed on desired machine and upon open i encountered a print engine error "cannot open sql server". just to make sure i could hit the datasource i ran a test from msaccess and sql+ and was successful. i also installed a report that had no subreports and was successful. so that leads me to believe that there is an issue with the subreports but after searching the web i could not find any help. can you not distribute a report with subreports or does anyone know a patch to fix? thanks in advance for any help.

 

[SurfingGecko]

Subreports are not handled very well with the Distribution Expert. One reason I suspect it has been discontiued. CR9 does nto support it at all.

Can you run the compiled report on the machine it was created on?

Our Crystal Ease product might be something to ease your deployment pain.

Cheers,

SurfingGecko
SurfingGeckoSoftware.com

 

[kenhamady]

If you try to run the compiled report on the design PC does it work?

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[maryjo2001]

i figured out what was going on. the dsn name was different on my machine than the one on the client's machine. after correcting that it worked fine.