Solved

HTML & PDF export very slow

Posted on 2004-09-01
2
1,087 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 100 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 400 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Not Exists 3 65
Group Header Repeating on every page 4 39
[NotSupportedException: Not supported within subreports.] 2 62
Visual Studio .Net 2012 and Crystal Reports 9 43
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

948 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now