Our application uses Crystal Reports 8.5 Runtime.
Running reports against a local or remote (over an VPN WAN) is not a problem.
However when exporting to Excel there is a problem.
2 Clients - one has just the runtime- a virgin machine, and one has the runtime plus Crystal 8.5, XI and 2008 development environments.
On the virgin machine any Excel export done against a remote database is not only slow but downloads lots of data, more that the original query took to run the report in the first place (over 20 times as much data!). It seems to use none of the cached data.
On the development machine this doesn't happen and only a small amount of data is transferred whilst exporting.
What is curious is that using either client/machine always performs well against our local (remote) database.
(Other export formats seem to be fine).
Can you help please?
I'd recommend comparing the runtime on the problem computer and the computer that is OK. To compare the runtime, download the modules utility from here:
Look for both CR file differences and database client file differences - Oh and check MDAC too.
See this thread on how to use modules:
The modules zip file also contains a help file if you need more info on how to use it.