Hello,
I have a very large report, connecting to a BEx query, via MDX.
If I run the report through Crystal Reports it takes about 35 Minutes to run
If I put the report on the Enterprise server and schedule the report it takes 40 minutes as a RPT file and 50 Minutes as a PDF.
Is this normal? In all the years that I have been working with Crystal it has always been quicker on the Enterprise server. I would normally say that the running it from my local machine would be worst case.
I know its not query speed as this is extremely fast.
It does use subreports, but I have made it as efficient as possible, and change I make to the report itself now makes it longer to run, not quicker.
I was wondering you thoughts about CR local vs Enterprise server.
Thanks