slow CR Excel Export on terminal server

[johnhugh]

Hi,
I've created a report in CR10 for our financial system.
All is located on a MS terminal server.
The terminal server is a Hyper-V server.

When I'm in the office and export the report into Excel (formatted) it goes reasonable fast.
When overseas the export is painfully slow.
I thought, when connecting to the TS, all you do happens locally on your TS?
I save the exported file on the server desktop so why would there be such a difference in speed?
It's that slow I think it must export the data into the cache of my local computer and then transfer it back to the Excel file on the server.
Exporting a data only file is even slower.

It does not matter whether I export from teh finacial system or from the CR10 editor.

Would could be the reason here?
Any help much appreciated.

 

[hilfy]

How much RAM does your TS session have as compared to the RAM on the workstation you're on when you're not overseas? How much free disk space? Does the report take any longer to run without exporting when you're on TS? Depending on the amount of data you're working with, Crystal can be a big memory hog. It also does a lot of swapping to the C drive of the computer where it's running when it's doing its processing. I suspect this may be contributing to your problem.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[johnhugh]

Thanks for your reply.
I should mention that I always connect to TS to run my reports, whether I'm in the office or overseas.
So it shouldn't have anything to do with RAM or disk space.

How could I check whether Crystal copies data onto my local computer when processing a report in a TS session?
That's the only explanation I can think of for why it's so slow.

 

[hilfy]

Hmmm....It shouldn't be copying to your local C, it should be working completely on the TS session. I'm not sure what might be causing this issue for you.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.