How to speed generation of a report in Crystal Reports?

Hi Team,

I am Using Stored procedures to generate Crystal Reports. For simple Report with 5 procedures it is taking 15 minutes to generate the report. How can i resolve the issue to generate the report with 1 minute.

I deployed the application in WebSphere server and invoked the report using JSP. with the following code.

reportClientDocument = new ReportClientDocument();

reportClientDocument.setReportAppServer(ReportClientDocument.inprocConnectionString);

reportClientDocument.open(reportPath, OpenReportOptions._openAsReadOnly);

Fields<IParameterField> parameterFields = reportClientDocument.getDataDefController().getDataDefinition().getParameterFields();

System.out.println("Param Fields Size:"+parameterFields.size());

if (parameterFields.size() > 0) {

ParameterFieldController paramController = reportClientDocument.getDataDefController().getParameterFieldController();

for (int i = 0; i < parameterFields.size(); i++) {

String paramName = parameterFields.getField(i).getName().trim();

System.out.println(" - "+paramName);

if(request.getParameter(paramName) != null) {

paramController.setCurrentValue("", paramName, request.getParameter(paramName));

System.out.println(paramName+":"+request.getParameter(paramName));

}else {

System.out.println("Param is Null:"+paramName+":"+request.getParameter(paramName));

paramController.setCurrentValue("", paramName, "");

}

}

}

reportSource = reportClientDocument.getReportSource();

session.setAttribute("ReportSource", reportSource);

byteArrayInputStream = (ByteArrayInputStream) reportClientDocument

.getPrintOutputController().export(ReportExportFormat.PDF);

response.reset();

response.setHeader("Content-disposition", "inline;filename=crreport.pdf");

response.setContentType("application/pdf");

byteArray = new byte[1024];

while((bytesRead = byteArrayInputStream.read(byteArray)) != -1) {

response.getOutputStream().write(byteArray, 0, bytesRead);

}

response.getOutputStream().flush();

response.getOutputStream().close();

reportClientDocument.close();