Skip to Content
author's profile photo Former Member
Former Member

Export to pdf is slow in crystal report 2016 using dotnet objects

Hi Team,

I am using SAP Crystal Reports 2016 SP2 (14.2.2.1975) and SAP crystal Reports runtime engine for .NET Framework (32-bit) (13.0.17.2096)

tvgchd001userszedbdgumypersonaldatadesktopcapture.jpg

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Posted on Oct 12, 2016 at 02:10 PM

    Post to :

    SAP Crystal Reports, version for Visual Studio

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 18, 2016 at 02:30 PM

    Ah, good to know.

    How long of a delay are you seeing?

    If you use a report with Saved Data and export how long does that take?

    What database are you connecting to and how, ODBC, OLE DB etc.?

    Don

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 19, 2016 at 09:33 AM

    Hi Don,

    1. It is taking 8 seconds.
    2. I am connecting to .dll and that .dll is calling a source program asgetReportdata.p on the server which is using progress DB. And that program completes within a second.

    Below are the logs, 1) is from the crystal report generation program and 2) is the appserver log for '

    asgetReportdata.p

    16/10/19 11:23:32 : Log Creation: yes, LogLevel: Detailed (2)
    16/10/19 11:23:32 : Spool Path : E:\server\crystalService\winsure\comDev1\spool\
    Report Path : E:\server\crystalService\winsure\comDev\report\
    Temp Path : e:\server\crystalService\winsure\comDev1\temp\
    Port : 0
    16/10/19 11:23:32 : Fetching ReportDocument Object for template: E:\server\crystalService\winsure\comDev\report\policy.rpt
    16/10/19 11:23:32 : Refreshed crystal report template
    16/10/19 11:23:33 : passed template parameters
    16/10/19 11:23:33 :
    Report template : policy.rpt
    Exporting to PDF : yes
    Printout : no
    16/10/19 11:23:33 : PDf file name: e:\server\crystalService\winsure\comDev1\temp\43D7.pdf
    16/10/19 11:23:41 : comDev1:Exported to PDF: e:\server\crystalService\winsure\comDev1\temp\43D7.pdf
    16/10/19 11:23:41 : Completed procedure generateCrystalReport.p

    --------------------------------------------------------------------------

    [16/10/19@11:23:40.683+0200] P-025028 T-040512 3 AS AS Negotiated ASK Version= 1.0capabilities= allowServerASK,denyClientASKActivityTimeout= 60ResponseTimeout= 60

    [16/10/19@11:23:40.683+0200] P-025028 T-040512 3 AS AS connect requestID= NULL

    [16/10/19@11:23:40.683+0200] P-025028 T-040512 2 AS AS Application Server connected with connection id: 10.48.69.136::comdev1a::29825::d93104a8b4e2cad3:4d838a78:157c8021761:-34c6. (8358)

    [16/10/19@11:23:40.683+0200] P-025028 T-040512 3 AS AS CSS_CONN before ACK, connection=10.48.69.136::comdev1a::29825::d93104a8b4e2cad3:4d838a78:157c8021761:-34c6 bound=0 changed=0

    [16/10/19@11:23:40.684+0200] P-025028 T-040512 3 AS ASrequestID= <REQ|gWqQdBEZrEaxAfqOPGZgXg-00000013>

    [16/10/19@11:23:40.684+0200] P-025028 T-040512 3 AS AS -- TRACE: Non-PERSISTENT Procedure 'asgetreportdata.p' START. (5498)

    [16/10/19@11:23:40.691+0200] P-025028 T-040512 3 AS AS -- TRACE: Non-PERSISTENT Procedure END SUCCESS. (8397)

    [16/10/19@11:23:40.699+0200] P-025028 T-040512 3 AS AS disconnect requestID= disconnect(10.48.69.136::comdev1a::29825::d93104a8b4e2cad3:4d838a78:157c8021761:-34c6)

    [16/10/19@11:23:40.699+0200] P-025028 T-040512 2 AS AS Application Server disconnected with connection id: 10.48.69.136::comdev1a::29825::d93104a8b4e2cad3:4d838a78:157c8021761:-34c6. (8359)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 19, 2016 at 12:56 PM

    What happens when you export the report from Crystal Reports Designer?

    When exporting it runs the report, so it's reconnecting to the data source(s) and refreshing.

    This may be the delay which is why I asked you to test using a report with saved data.

    How does CR and a report with saved data take?

    Don

    PS - I converted your Comment to an Answer. Comments are for non-technical info.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2016 at 07:34 AM

    Hi Don,

    When I use preview and/or Export the report with saved data in PDF using Crystal report Designer then it takes less than a second.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 27, 2016 at 05:31 PM

    8 seconds sounds about right. When exporting with saved data all DB connections are not required and the formatting is mostly completed.

    You can possibly speed this up, part of the time may be due to CR loads the dll's when the first report is loaded, load a dummy blank report when your app first starts up and then close it and then open the report you want to use. May save some time.

    Don

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2016 at 03:14 PM

    Hi Don,

    I tried to reuse the old loaded report, but no luck in saving time while exporting the report to PDF. Yes it definetely saves nearly 8 seconds, as I do not have to load the old loaded report.

    I am using clReport:REFRESH() statement to refresh the old parameters, As I am passing different parameters every time.

    Could you please suggest some other solution.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2016 at 03:48 PM

    Hi,

    If anyone is aware of the solution or someone had faced the same problem earlier, then please let me know what can be the root cause and solution of the problem.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.