Crystal Reports 8.5 Export to Excel
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?