Skip to Content
0

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

Oct 12, 2016 at 11:02 AM

193

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

8 Answers

Don Williams
Oct 12, 2016 at 02:10 PM
0

Post to :

SAP Crystal Reports, version for Visual Studio

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Don,

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

0
Don Williams
Oct 18, 2016 at 02:30 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 19, 2016 at 09:33 AM
0

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)

Share
10 |10000 characters needed characters left characters exceeded
Don Williams
Oct 19, 2016 at 12:56 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left 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.

0
avatar image
Former Member Oct 20, 2016 at 07:34 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Don Williams
Oct 27, 2016 at 05:31 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 21, 2016 at 03:14 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 05, 2016 at 03:48 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded