Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Oct 12, 2016 at 02:10 PM

    Post to :

    SAP Crystal Reports, version for Visual Studio

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Don,

      I am not using Visual studio. I am integrating it with Openedge 11.5.

  • 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 comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded

  • 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 comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Don,

      I will not be able to access the portal till 20 Nov. Please do not move this post under archive.

  • avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded

  • 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 comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 comment
    10|10000 characters needed characters exceeded