Integration With Crystal Reports

[kpiljava]

Hi ,
I was evaluating app servers for web applications and i was trying
to use reports in web applications.
I am using Crystal Reports 9.0 RAS(Report Application Server)
with IBM Websphere .I tried to get a pdf file from JSP using Report
SDK provided by Crystal Reports 9.0 RAS .The code is giving me
servlet language exception at runtime but it is running on Weblogic
without any error.Something related to strictservletlifecycle.Although
code is going to RAS but at a point it is giving me the problem.
Is it a server related problem ????
I am pasting the code and the Exception below..Plz let
me know if it is server dependent.

Code is pasted below

<%@ page contentType=&quot;text/html; charset=utf-8&quot; %>
<%@ page session=&quot;true&quot;%>
<%@ page import=&quot;javax.servlet.jsp.*&quot;%>
<%@ page import=&quot;java.util.Locale&quot;%>
<%@ page import=&quot;java.net.*&quot; %>
<%@ page import=&quot;java.text.DateFormat&quot; %>
<%@ page import=&quot;javax.servlet.jsp.JspWriter&quot;%>
<%@ page import=&quot;javax.servlet.http.HttpServletRequest&quot; %>
<%@ page import=&quot;javax.servlet.http.HttpSession&quot; %>
<%@ page import=&quot;com.crystaldecisions.sdk.occa.report.data.*&quot; %>
<%@ page import=&quot;com.crystaldecisions.sdk.occa.report.application.*&quot; %>
<%@ page import=&quot;com.crystaldecisions.report.web.viewer.*&quot; %>
<%@ page import=&quot;com.crystaldecisions.sdk.occa.report.exportoptions.*&quot; %>
<%@ page import=&quot;com.crystaldecisions.sdk.occa.report.definition.*&quot; %>

<!--Code Starts here ........... -->
<%
System.out.println(&quot;$$$$$$$$$$$$$$$$$$$$$$$$&quot;

String reportName=(String)request.getAttribute(&quot;ReportName&quot;
String requestNumber=(String)request.getAttribute(&quot;RequestNumber&quot;
String requestNumber=&quot;RPT_112&quot;;
System.out.println(&quot;********************&quot;
ParameterField newParameter = new ParameterField();
ParameterField newField = null;
System.out.println(&quot;@@@@@@@@@@@@@@@@@@@@@@@@@&quot;
ParameterFieldDiscreteValue newValue = null;
System.out.println(&quot;^^^^^^^^^^^^^^^^^^^^^^^^^^&quot;
try{
ReportClientDocument rptClientDoc = new ReportClientDocument();

//System.out.println(&quot;11111111111111111111111111&quot;

/* Change DCWKS0241AB to the name of Machine where RAS is installed for ex like DCWKS0237 */
rptClientDoc.setReportAppServer(&quot;DCWKS0241AB&quot;
System.out.println(&quot;22222222222222222222222222&quot;
/* Change this E:\\Crystal\\Reports\\ to the path where your reports are kept */
String reportPath=&quot;E:\\RAS\\Reports\\Percentages.rpt&quot;;

rptClientDoc.open (reportPath, 0);
rptClientDoc.getDatabaseController().logon(&quot;bbva&quot;,&quot;bbva&quot;
System.out.println(&quot;After Creating the Client Document on the Report&quot;
/* folowing Code remove any default value to the report and append the request number in the input parameter*/
newField = (ParameterField)rptClientDoc.getDataDefinition().getParameterFields().getField(0);
newField.copyTo(newParameter,true);
newParameter.getCurrentValues().removeAllElements();
newValue=new ParameterFieldDiscreteValue();
newValue.setValue(requestNumber);
newParameter.getCurrentValues().add(newValue);
/* Just for Testing Purpose
Values v=newParameter.getCurrentValues();
IValue iv=v.getValue(0);
System.out.println(&quot;---> &quot;+iv.computeText());
*/
rptClientDoc.getDataDefController().getParameterFieldController().modify(newField, newParameter);

/* Specifying the Format */
PDFExportFormatOptions PDFExpOpts = new PDFExportFormatOptions();

//Create the ExportOptions object, set the PDF export options, and set the format type to PDF.
ExportOptions exOpts = new ExportOptions();
exOpts.setFormatOptions(PDFExpOpts);
exOpts.setExportFormatType(ReportExportFormat.from_int(ReportExportFormat._PDF));
System.out.println(&quot;After Setting the format&quot;
System.out.println(&quot;Before getting source&quot;
//Create the ReportExportControl object and set the report source to the report that will be exported to PDF.
ReportExportControl expViewer = new ReportExportControl();
System.out.println(&quot;Before getting source&quot;
expViewer.setReportSource (rptClientDoc.getReportSource());
System.out.println(&quot;3&quot;

//Set the export options to the ReportExportControl object.
expViewer.setExportOptions(exOpts);
System.out.println(&quot;After Setting the Export Options to the ReportExportControl object.&quot;
//Set the exported report to display in the browser.
//The setExportAsAttachment method is set to false by default. If it is set to true the user will be presented with the File Download dialog box to save the exported report to disk.
expViewer.setExportAsAttachment(false);

//Export and view the report.
expViewer.processHttpRequest(request, response, (getServletConfig()).getServletContext(),null);
System.out.println(&quot;After Exporting and viewing the report back in the Browser.&quot;
//Destroy the control.
expViewer.dispose();
}
catch (Exception e)
{
out.write(&quot;Error: Open&quot; + e.toString() + &quot;\n&quot;
}

%>

Exception

[11/21/02 15:27:49:465 GMT+05:30] 2c89cb91 SystemOut U $$$$$$$$$$$$$$$$$$$$$$$$
[11/21/02 15:27:51:325 GMT+05:30] 2c89cb91 SystemOut U 22222222222222222222222222
[11/21/02 15:27:55:669 GMT+05:30] 2c89cb91 SystemOut U After Creating the Client Document on the Report
[11/21/02 15:27:55:715 GMT+05:30] 2c89cb91 SystemOut U After Setting the format
[11/21/02 15:27:55:715 GMT+05:30] 2c89cb91 SystemOut U Before getting source
[11/21/02 15:27:55:715 GMT+05:30] 2c89cb91 WebGroup X Servlet Error: javax/servlet/ServletRequest: java.lang.Exception: javax/servlet/ServletRequest
at jsp._testExport_jsp_2._jspService(_testExport_jsp_2.java:286)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:142)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:312)
at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:487)
at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:620)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java:827)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java:167)
at com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleServlet.java:297)
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java:110)
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java:472)
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java:1012)
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java:913)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:678)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:331)
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:117)
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:134)
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:239)
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:67)
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:151)
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java:315)
at com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnection.java:60)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:323)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:252)
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:137)

 

[jojo69]

Hi,

I try to do the same thing but I have an error when WSAD wants to import crystal classes.
Can you please tell me how you have setup SDK on your project.
I add classes in my classpath but it seems it's not enougth.
error:
****************
JSPG0059E: Unable to compile class for JSP nullC:\Program Files\IBM\Application Developer\workspace\.metadata\.plugins\com.ibm.etools.server.tools\tmp3\cache\localhost\Default_Server\CRTest\CRTestWeb.war\JSP\_Report_jsp_0.java:26: Package com.crystaldecisions.sdk.occa.report.data not found in import. import com.crystaldecisions.sdk.occa.report.data.*
*******************

Thanks for your help.