Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

HTML & PDF export very slow

Posted on 2004-09-01
2
Medium Priority
?
1,124 Views
Last Modified: 2008-03-04
We use CR 10 Developer. We have a 20-page report that contains roughly 30 images. Each image appears in two versions in our DB: low-res (cca 500x450 pixels) and hi-res (cca 2000x1800 pixels). We export the report into HTML and PDF formats; the HTML export uses low-res images and the PDF uses hi-res ones.

Our problem is that exporting is very slow: the HTML takes 205 secs and the PDF takes 395 secs (measured on a fast PC). Previously, when we used our own exporting code, HTML took 45 secs and PDF took 145 secs. That is, Crystal is 2.5 to 5 times slower than our own code.

My question is: do you know of any tricks to speed up exporting? Please note that our reports contain a lot of images - they are very important for our users, and their quality must be very good, especially in the PDF. Thus, reducing the image resolution is not an option. Instead, I'm hoping there's a hidden registry setting or sth like that that might help here.

My second question: it seems to me that Crystal's exporting speed very much depends on the resolution of the images in the report. I did an experiment: I used the low-res images for the PDF export, and the exporting time went down to cca 10% of the original!
Does anybody have an idea *why* Crystal is so sensitive to image resolution? (Actually, this observation applies to all export formats, not only PDF.)

Thanks,

Bence Kodaj
Geomagic Hungary Ltd.
0
Comment
Question by:Geomagic_Hungary
2 Comments
 
LVL 10

Assisted Solution

by:ebolek
ebolek earned 300 total points
ID: 11953398
you are exactly right, Images are problem for export

In this article it refers that even crystal adjusts the image qualty and degrades them to increase the report performance.
http://support.businessobjects.com/library/kbase/articles/c2010317.asp

This is a known issue with the crystal

Regards
Emre
0
 
LVL 42

Accepted Solution

by:
frodoman earned 1200 total points
ID: 11953485
Crystal will be slower to export then code specifically written to do (only) the export.  Remember that Crystal doesn't just export what you can see, but generates a report, looks at fields and sections for conditional suppression, etc., etc. - everything it normally does in it's report passes.  There's a lot more work involved then just pumping the resulting output out to a PDF converter.

I believe the link Emre provided is the .net version of the information that I gave in your last thread ( http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21115093.html ).  It's not going to help you speed up your export, particularly if decreasing resolution isn't an option for you.

Sorry, I don't know of anything that will help you with the export speed except for lowering resolution.  As to "why" Crystal is so sensitive to this, unfortunately I don't know enough about the algorythm being used to answer that - I suspect any information about it would be proprietary.

frodoman
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question