Skip to Content

<p>+I work for SAP Business Objects in Technical Customer Assurance.  My speciality is the Software Development Kits (SDKs) that we provide with our Business Intelligence products – BusinessObjects Enterprise, Web Intelligence, Desktop Intelligence, Crystal Reports and Crystal Xcelsius.  </p><p>In my blog, I discuss subjects that I personally find interesting – little known or not-well-documented corners of the SDK, new functionality or new SDKs, or interesting issues that I’ve come across in a SAP Incident or SAP Developer Network forums.  </p><p>You’re more than welcome to suggest any topic (SAP Business Objects SDK related, of course…) that you’d like me to discuss – I have a dozen or so items on my blog to-do list, but I’m always on the hunt for anything interesting with our SDKs.+   </p>


If you’re a developer using Crystal Reports for Eclipse (CR4E) for your reporting component, this blog entry will be of interest to you. I’ll discuss how to ensure proper cleanup of reports processed by the CR4E SDK – the Java Reporting Component and Crystal Reports Java.

This isn’t covered in detail in the documentation, but cleanup with CR4E SDKs is particularly important if your application comes under load.  Reports left open take up resources, which, if left unchecked, can starve your app of resources, leading to performance degradation, report request denial, and out of memory problems.

h5. Relationship to the Report Application Server SDK

Underlying the CR4E reporting SDKs are a common root originating from the Report Application Server (RAS) SDK.  The RAS solution is server-client, where the RAS SDK communicates with the RAS server via the Enterprise Framework CORBA TCP/IP connection.  For the CR4E SDKs, the server-client communication is replaced by an in-process connection to a pure 100% Java reporting engine.

One carryover of the RAS framework in the CR4E API is how the lifetime of a opened report instance is controlled.  From the perspective of a programmer coding against the API, the engine appears to use reference counting in determine whether a report instance is still in use or is free to be cleaned up.[[1] | #reference_counting]

h5. Controlling Report Instance Lifetime

In a nutshell, follow these rules to ensure proper cleanup:

 

  • Destroy every  ReportSource.

Every time a ReportClientDocument opens a report rpt file, the reference count for that report instance is incremented.  Every time an unique ReportSource is retrieved from the ReportClientDocument, the count is incremented.

Every time a ReportClientDocument is closed, the reference count is decremented.  Every time a ReportSource is destroyed, the count is decremented. 

Once the reference count goes to zero, the in-process report engine releases all resources used by the instance.  If ReportClientDocument or ReportSource is not cleaned up, then the instance will remain live and taking up resources until timeout garbage collects the object.

One important consideration is the following: even if you invoke ReportClientDocument.close(), that report may still not be closed. 

Here’s a simple test:  (1) open a report with a ReportClientDocument, (2) retrieve a ReportSource using the method ReportClientDocument.getReportSource(), (3) invoke the ReportClientDocument.close() method for that instance, (4) test the value of ReportClientDocument.isOpen() – you’ll see that it’s true!, (5) pass the ReportSource object to the CrystalReportViewer, and invoke CrystalReportViewer.dispose(), (6) now check ReportClientDocument.isOpen() again – you’ll see that it’s false, i.e., that the instance  has been cleaned up.

Another consideration:   the only way to dispose the ReportSource is to pass it to a viewer object – CrystalReportViewer or ReportExportControl – an invoke dispose() on the viewer, since the ReportSource API is not public.  Invoking viewer dispose() will in turn invoke the proper dispose method for the ReportSource.

Yet another consideration: the CrystalReportViewer DHTML web viewer works by post-back on client user events.  This means you’d keep either ReportClientDocument or ReportSource instance in HTTP Session context and, on each postback, retrieve the object and inject the ReportSource into the CrystalReportViewer.  Whether you’d dispose the CrystalReportViewer depends on which object you keep in Session.

h5. Sample Codes

I’ll illustrate using following sample codes for viewing reports on the web, where I keep the ReportSource in session.  The lifecycle consists of three parts (1) opening the report, (2) handling viewer postback, and (3) final cleanup.

bq. JSP Page to Open Report and Handle Postback<br /><textarea cols=”75″ rows=”50″><%@ page
import=”com.crystaldecisions.report.web.viewer.CrystalReportViewer,
com.crystaldecisions.sdk.occa.report.application.OpenReportOptions,
com.crystaldecisions.sdk.occa.report.application.ReportClientDocument”
info=”Import com.crystaldecisions.reports.sdk.ReportClientDocument for Version 11.8-
     Import com.crystaldecisions.sdk.occa.report.application.ReportClientDocument for Version 12+”
%>
<%


final String CR_VIEWER_NAME = “CrystalReportViewer”;
//final String CR_VIEWER_EVENT_PARAM = “CRVEventTarget”;        // Version 12+
final String CR_VIEWER_EVENT_PARAM = “CrystalEventTarget”;  // Version 11.8-


Object reportSource = null;


if(!CR_VIEWER_NAME.equals(request.getParameter(CR_VIEWER_EVENT_PARAM))) {
    ReportClientDocument reportClientDocument;


    reportClientDocument = new ReportClientDocument();


    //reportClientDocument.setReportAppServer(ReportClientDocument.inprocConnectionString);  // Version 12+


    reportClientDocument.open(“Reports
report.rpt”, OpenReportOptions._openAsReadOnly);


    reportSource = reportClientDocument.getReportSource();
    session.setAttribute(“ReportSource”, reportSource);


    reportClientDocument.close();


} else {


    reportSource = session.getAttribute(“ReportSource”);


}


CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setName(CR_VIEWER_NAME);
viewer.setOwnPage(true);
viewer.setReportSource(reportSource);
viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);


%>

The above handles opening the report and viewer postback.  Postback is detected by  checking to see if the request parameter “CrystalEventTarget” is set to the name property specified for the CrystalReportViewer. 

If the request is an initial request, the ReportClientDocument is used to open the report (reference count = 1), generate a ReportSource (reference count = 2), store the ReportSource in HTTP Session, then close the ReportClientDocument (reference count = 1).  Even though the ReportClientDocument instance is closed, the reference count is non-zero, so the report instance remains open. 

If the request is a postback, then the ReportSource is retrieved from HTTP Session.

Whether the request is postback or not, the ReportSource is passed to the viewer and processHttpRequest called to write the report page to the web browser.  Note that the viewer dispose() method is not called in this page, since we wish to keep the report open for subsequent viewer postback requests, and do not want to dispose the ReportSource kept in HTTP Session.

bq. JSP Page for Final Report Cleanup<br /><textarea cols=”75″ rows=”15″><%@ page import=”com.crystaldecisions.report.web.viewer.CrystalReportViewer”
%><%

CrystalReportViewer crystalReportViewer;
Object reportSource;

reportSource = session.getAttribute(“ReportSource”);

crystalReportViewer = new CrystalReportViewer();

crystalReportViewer.setReportSource(reportSource);
crystalReportViewer.dispose();

%></textarea>
<p>The JSP page above is used for final cleanup – it retrieves the ReportSource from HTTP Session, passes it to the CrystalReportViewer and invokes dispose(), to zero the reference count and release all resources held by the report.  Note that the CrystalReportViewer instance here is not used for any viewing purpose – it’s instantiated solely to dispose the ReportSource.</p><p>This page should be call only when the user is done viewing the report.  There’s several ways to invoke this, for example (1) have this page called when a new report is requested, to clean up any previously viewed reports, or (2) create a ‘Logoff’ button, that the user clicks that posts to this page, or (3) wrap the viewer in a Frame, or create a hidden Frame, that on page unload events invokes JavaScript that calls this page, or (4) put the code in a HTTP Session Listener instance registered with the web application to listen for HTTP Session timeout events.</p>h5. Conclusion
<p>The workflow required for proper report lifecycle management isn’t very intuitive, unless you know a bit about the internal workings of the Java Crystal Report Engine.  </p><p>I hope you find this information useful, and helpful in creating a more performant CR4E reporting application.</p>h5. References
<p>[[1] | #reference_counting]<a name=”reference_counting” title=”reference_counting”></a> Why RAS appear to use reference counting arises from a change in XI Release 2, when Serialization support was introduced.   Since the RAS SDK reference to a report on the RAS server may cross across multiple web application servers, the server keeps track of the number of oustanding references extant.  Once the count goes to zero, the server assumes the report instance is no longer being used, and cleans up resources used by the instance.  The CR4E SDKs do not, at this time, support Serialization of report objects, but still uses this behavior to determine report instance lifetime.</p><p> </p>

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. William Goss
    Hi Ted,

    Thanks for all your great blog articles. 

    Here’s my situation:  I created a jsp that displays arbitrary crystal reports using  parameters handed off from Maximo’s Custom Report Integration web pages; the parameters contain the report filename and its parameters by name.  I want to dispose of the report when the user is done, without interfering with the users’ viewing of the report.  Can jspdestroy be used for this purpose?

    (0) 
  2. William Goss
    Hi Ted,

    This is report-cleanup related… we are using a report viewer jsp run from an exploded war (i.e. CrystalReports.war directory) under WebLogic 9.2.  The reason for this setup is so we can dynamically redeploy reports we’ve tweaked, without rebuilding/redeploying the war file, and (hopefully) without having to shut down the server, clear the cache, and restart, for each report tweak.

    Unfortunately we are seeing the same (old) report instance after copying a new xx.rpt report into the CrystalReports.war directory (in the appropriate …\classes subdirectory.

    Is there any way to ensure, at least on the dev server, that we always get the latest .rpt file?

    Thanks,

    Bill

    (0) 
  3. Luis Montaz
    Hello…
    If I am working with CR in a web enviroment, where I have to use a connection pool (20 connections) and I have 21 users, executing reports… the user number 21 does not going to have a available connection to execute her/his report, until one of the other users, close one report, right?

    Question:
    how can I work with the connection pool concept? I mean, I would like to CR takes the connection just when it really needs it. and not to take the connection and keep it forever and ever… is it a possibility? Can I do that?

    (0) 
  4. Community User
    Are you aware if you can you change the location of the tmp files that get created so that they are on a different / larger drive than the application works space?

    Thanks

    Kevin McManus

    (0) 
  5. Hashem B

    Ted,

    What is the proper way to clean up the report in desktop applications? I am calling  reportClientDocument.close() on window closing event of the report window [after the report is displayed], it doesn’t close the database connection. Although calling the same close method works when I export or print the report.

    (0) 

Leave a Reply