Categories

JAVA DATEBASE
Technology Network Community
Oracle Database
Fusion Middleware
Development Tools
Java
Desktop
Server & Storage Systems
Enterprise Management
Berkeley DB Family
Cloud Computing
Big Data
Business Intelligence
Architecture
Migration and Modernization
E-Business Suite
Siebel
PeopleSoft Enterprise
JD Edwards World
Industries
JD Edwards EnterpriseOne
User Productivity Kit Pro (UPK) and Tutor
Governance, Risk & Compliance (GRC)
Master Data Management (MDM)
Oracle CRM On Demand
On Demand: SaaS and Managed Applications
AutoVue Enterprise Visualization
Primavera
ATG
Agile PLM
Endeca Experience Management
Fusion Applications
Archived Forums

 



Tags

JDeveloper and ADF


Has any body work with Crystal Report XI and JDeveloper 10.1.3 ?


Hi All,  We want to use Crystal Report XI as our reporting tools and integrate it with our jsp/jspx application developed with JDeveloper 10.1.3.  Has any body succesfully done this kind of integration ? Could you please share it with me ?  Thank you for your info, xtanto

Hi   I am doing crystal report 10 with Jdeveloper 10.1.3. I was able to create a jsp page to call the report (without parameter) and the report disply nicely.  But I have two problems:  1. when I print the report, the tool bar is on the report. I do not know how to get rid of it.  2. I got 500 internal error when calling report with parameter.  ******************************************* Exception: java.lang.IllegalStateException: Writer already retrieved at com.evermind.server.http.EvermindHttpServletResponse.getOutputStream(Evermin dHttpServletResponse.java:882) at javax.servlet.ServletResponseWrapper.getOutputStream(ServletResponseWrapper. java:147) at javax.servlet.ServletResponseWrapper.getOutputStream(ServletResponseWrapper. java:147) at com.evermind.server.http.EvermindJSPWriter.initServletOut(EvermindJSPWriter. java:482) at com.evermind.server.http.EvermindJSPWriter.writeOut(EvermindJSPWriter.java:4 92) at com.evermind.server.http.EvermindJSPWriter.jspflush(EvermindJSPWriter.java:3 91) at com.evermind.server.http.EvermindJSPWriter.close(EvermindJSPWriter.java:361) at oracle.jsp.runtime.OracleJspRuntime.extraHandlePCFinally(OracleJspRuntime.ja va:1574) at _app._report._facilityParamTest._jspService(_facilityParamTest.java:135) [/app/report/facilityParamTest.jsp] at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:60) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:416) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.ja va:64) at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:332 ) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispa tcher.java:629) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletReq uestDispatcher.java:376) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(Servl etRequestDispatcher.java:298) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestD ispatcher.java:42) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDi spatcher.java:205) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDisp atcher.java:209) at com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java: 322) at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:13 0) at oracle.adfinternal.view.faces.application.ViewHandlerImpl.renderView(ViewHan dlerImpl.java:157) at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java :87) at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200) at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.ja va:64) at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfF acesFilterImpl.java:367) at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFac esFilterImpl.java:336) at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFil terImpl.java:196) at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:87) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.ja va:15) at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:332 ) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.ja va:17) at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:332 ) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispa tcher.java:627) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletReq uestDispatcher.java:376) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHand ler.java:870) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandle r.java:451) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandl er.java:218) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:119) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketRea dHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableRe sourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)   ****************************************************************************************  If you have found any solutions to the above problems, please let me know.   Anna

Hi, Currently I run Crystal XI with JDev 10.1.3 without any problem.  I don't understand the question (1).  For question number 2, I got that error too if I don't set the parameter correctly, for example : I send the parameter with value with different data type that defined in the report. Just make sure you set the parameter with correct data type.  HTH, xtanto

I am having the problem with the "Writer already retrieved" being displayed under my reports, even though the report runs just fine. I am using CR 11 R2 and Oracle App Sever 10.3.  Thanks  Larry

HI  Do you use Java reporting Component SDK of crystal report 10 to create your report? IF so , how do you do the database connection? How do you use JDeveloper database connection in the crystal report?   Do you have a document or steps of creating crystal report and integrated with Jdevloper?  Thanks

Hi friends,  I use Crystal Reoprt XI (release 1) with JDev 10.1.3, never try Crystal 10 with JDev.  Here is what I do :  1. Install CR XI on the same machine with JDev 10.1.3. 2. Modify CRConfig.XML on folder : C:\Program Files\Common Files\Business Objects\3.0\java on three places :      <JavaDir>D:\JDev1013\jdk\bin</JavaDir>      <Classpath>D:\JDev1013\jdbc\lib\ocrs12.jar;D:\JDev1013\jdbc\lib\ojdbc14.jar;D:\JDev1013\jdbc\lib\ojdbc14dms.jar;D:\JDev1013\jdbc\lib\orai18n.jar; .... [original classpath] ..... <JDBCURL>jdbc:oracle:thin:@oracle.sas.co.id:1521:ORCL</JDBCURL> <JDBCClassName>oracle.jdbc.driver.OracleDriver</JDBCClassName> <JDBCUserName>myuserid</JDBCUserName>	<JNDIURL></JNDIURL>  ....  3. Create the report using Crystal XI, USE JDBC CONNECTION, and it takes about 12-20 minutes to connect, don'y know why   ( now the integration part )  4. Create a project for the report in our apps workspace (e.d : ViewController)  5. Copy these jar files below to D:\..\ViewController\public_html\WEB-INF\lib  (I got the files from Crystal Installation) 04/03/2006  09:27 AM           666,774 CrystalCharting.jar 03/26/2006  12:23 AM             2,163 CrystalCommon.jar 04/03/2006  09:27 AM            94,137 CrystalContentModels.jar 04/03/2006  09:30 AM           519,003 CrystalExporters.jar 04/03/2006  09:27 AM            60,468 CrystalExportingBase.jar 04/03/2006  09:26 AM           561,021 CrystalFormulas.jar 04/03/2006  09:26 AM           390,049 CrystalQueryEngine.jar 04/03/2006  09:28 AM         1,934,849 CrystalReportEngine.jar 04/03/2006  09:25 AM           413,455 CrystalReportingCommon.jar 09/08/2003  02:42 PM         3,915,966 icu4j.jar 04/03/2006  09:29 AM           135,232 jrcerom.jar 02/10/2006  10:39 AM           698,542 jsf-impl.jar 03/26/2006  12:23 AM             8,680 keycodeDecoder.jar 05/11/2004  07:22 PM           352,668 log4j.jar 03/26/2006  08:33 AM           474,429 MetafileRenderer.jar 04/03/2006  08:47 AM           369,503 rasapp.jar 04/03/2006  08:46 AM           784,065 rascore.jar 03/16/2006  09:35 AM           699,443 ReportViewer.jar 04/03/2006  09:25 AM            95,381 rpoifs.jar 04/03/2006  08:46 AM            21,128 serialization.jar 06/17/2006  01:41 PM           393,259 standard.jar 10/02/2003  06:29 PM             3,777 URIUtil.jar 02/28/2006  10:01 AM            48,279 webreporting-jsf.jar 03/07/2006  08:50 AM           778,348 webreporting.jar 02/20/2004  02:01 PM         1,010,806 xercesImpl.jar 02/20/2004  02:01 PM           124,724 xml-apis.jar  6. Right click the project, project properties,  Libraries, Add Jar / Directories,     Add all the jar files from previous step.  7. Copy CRConfig.XML to folder D:\..\ViewController (project folder)     ( this CRConfig.XML is the one that I have not modified, the original one. )     Please check, you must have this on the file :    <reportlocation>.</reportlocation>  8. Then create a Folder e.g : reports under WEB-INF :     D:\..\ViewController\public_html\WEB-INF\reports, then copy all reports created on step 3 on to this folder.  9. create a jsp to call the report, here is sample of my JSP : <%@ page  contentType="text/html;charset=windows-1252"  isELIgnored="true" %>  <%@page import="com.crystaldecisions.reports.sdk.*"%> <%@page import="com.crystaldecisions.sdk.occa.report.lib.*"%> <%@page import="com.crystaldecisions.sdk.occa.report.exportoptions.*"%> <%@page import="com.crystaldecisions.report.web.viewer.*"%> <%@page import="com.crystaldecisions.sdk.occa.report.reportsource.*" %> <%@page import="com.crystaldecisions.sdk.occa.report.data.*" %>  <%@page import = "java.util.*" %> <%@page import = "view.util.JSFUtils" %> <%@page import = "oracle.jbo.domain.Number" %>  <% //Use the relative path to the report; the physical or full qualified URL cannot be used. //String reportName = "D:/DemoCrystal/Project/public_html/WEB-INF/Report/OrderID2.rpt"; //String reportName = "D:/DemoCrystal/Project/public_html/WEB-INF/Report/test2.rpt"; //String reportName = "D:/DemoCrystal/Project/public_html/WEB-INF/Report/invoice.rpt"; String reportName = "../reports/invoice.rpt"; String userName = "myuserid"; String password = "mypassword";  String compId = (String)JSFUtils.getFromSession("compId"); String docId = (String)JSFUtils.getFromSession("docId"); Number noDokumen = (Number)JSFUtils.getFromSession("noDokumen"); String status = (String)JSFUtils.getFromSession("status"); System.out.println("from rptInvoice.jsp " +compId+docId + " " + noDokumen.toString()+status);  try {         //Open report.         ReportClientDocument reportClientDoc = new ReportClientDocument();         reportClientDoc.open(reportName, 0); 	session.setAttribute("reportSource", reportClientDoc.getReportSource());          // Conn info         ConnectionInfos oConnectionInfos = new ConnectionInfos();         ConnectionInfo oConnectionInfo = new ConnectionInfo();                 oConnectionInfo.setUserName(userName); //Set username and password for the report's database         oConnectionInfo.setPassword(password);                 oConnectionInfos.add(oConnectionInfo); //Add object to collection                  //Create a Fields collection object to store the parameter fields in.         Fields oFields = new Fields();         // THE PARAMETERs.           //Integer numberValue = new Integer(2166);         //String stringValue = "IV";          //Set all of the parameter values using the utility function.          setDiscreteParameterValue(oFields, "Nomor_Invoice", "", new Integer(noDokumen.intValue()));         setDiscreteParameterValue(oFields, "Kode_Invoice", "", docId);                 setDiscreteParameterValue(oFields, "Compid", "", compId);                         setDiscreteParameterValue(oFields, "Status", "", status);                                  //System.out.println("from view-controller report jsp v2.2");         //Set the export options to export to the format of choice.           ExportOptions oExportOptions = new ExportOptions();         oExportOptions.setExportFormatType(ReportExportFormat.PDF);                 ReportExportControl oReportExportControl = new ReportExportControl();         oReportExportControl.setExportOptions(oExportOptions);         oReportExportControl.setExportAsAttachment(false);         Object reportSource = session.getAttribute("reportSource");         oReportExportControl.setReportSource(reportSource);          oReportExportControl.setDatabaseLogonInfos(oConnectionInfos);  	oReportExportControl.setParameterFields(oFields);           //Export the report         oReportExportControl.processHttpRequest(            request, response, getServletConfig().getServletContext(), null); } catch(ReportSDKException e) {     out.print(e); }     %>  <%! /*  * Utility function to set values for the discrete parameters in the report.  The report parameter value is set  * and added to the Fields collection, which can then be passed to the viewer so that the user is not prompted  * for parameter values.    */ private void setDiscreteParameterValue(Fields oFields, String paramName, String reportName, Object value) {	     //Create a ParameterField object for each field that you wish to set.       ParameterField oParameterField = new ParameterField();      //You must set the report name.      //Set the report name to an empty string if your report does not contain a     //subreport; otherwise, the report name will be the name of the subreport     oParameterField.setReportName(reportName);      //Create a Values object and a ParameterFieldDiscreteValue object for each      //object for each parameter field you wish to set.     //If a ranged value is being set, a ParameterFieldRangeValue object should      //be used instead of the discrete value object.     Values oValues = new Values();     ParameterFieldDiscreteValue oParameterFieldDiscreteValue = new ParameterFieldDiscreteValue();      //Set the name of the parameter.  This must match the name of the parameter as defined in the     //report.     oParameterField.setName(paramName);     oParameterFieldDiscreteValue.setValue(value);      //Add the parameter field values to the Values collection object.     oValues.add(oParameterFieldDiscreteValue);      //Set the current Values collection for each parameter field.     oParameterField.setCurrentValues(oValues);      //Add parameter field to the Fields collection.  This object is then passed to the     //viewer as the collection of parameter fields values set.      oFields.add(oParameterField);         } %>  10. have a try and HTH   xtanto.

Hello !  I have problems when pass params to the report, that use stored procedure on Oracle and return ref cursor with report data...  The error is always same "Invalid parameter name: {0} " I even try to cut off code, that pass params and JRC show me html form, where I enter that values manually, but error the same.  xtanto, please send to me your files 5. Copy these jar files below to D:\..\ViewController\public_html\WEB-INF\lib  (I got the files from Crystal Installation) 04/03/2006 09:27 AM 666,774 CrystalCharting.jar 03/26/2006 12:23 AM 2,163 CrystalCommon.jar 04/03/2006 09:27 AM 94,137 CrystalContentModels.jar 04/03/2006 09:30 AM 519,003 CrystalExporters.jar 04/03/2006 09:27 AM 60,468 CrystalExportingBase.jar 04/03/2006 09:26 AM 561,021 CrystalFormulas.jar 04/03/2006 09:26 AM 390,049 CrystalQueryEngine.jar 04/03/2006 09:28 AM 1,934,849 CrystalReportEngine.jar 04/03/2006 09:25 AM 413,455 CrystalReportingCommon.jar 09/08/2003 02:42 PM 3,915,966 icu4j.jar 04/03/2006 09:29 AM 135,232 jrcerom.jar 02/10/2006 10:39 AM 698,542 jsf-impl.jar 03/26/2006 12:23 AM 8,680 keycodeDecoder.jar 05/11/2004 07:22 PM 352,668 log4j.jar 03/26/2006 08:33 AM 474,429 MetafileRenderer.jar 04/03/2006 08:47 AM 369,503 rasapp.jar 04/03/2006 08:46 AM 784,065 rascore.jar 03/16/2006 09:35 AM 699,443 ReportViewer.jar 04/03/2006 09:25 AM 95,381 rpoifs.jar 04/03/2006 08:46 AM 21,128 serialization.jar 06/17/2006 01:41 PM 393,259 standard.jar 10/02/2003 06:29 PM 3,777 URIUtil.jar 02/28/2006 10:01 AM 48,279 webreporting-jsf.jar 03/07/2006 08:50 AM 778,348 webreporting.jar 02/20/2004 02:01 PM 1,010,806 xercesImpl.jar 02/20/2004 02:01 PM 124,724 xml-apis.jar  to email ruslan at intraline.ru since all my files is 2004-2005 year dated, you have more fresh version, I think it'll solve the problem.  Thanks a lot.

hi all, is there any  documented example available online for using CRXI with jdeve 1013? if not then can anyone send any guiding material to rabia.tahir@yahoo.co.uk  much regards RT

What JARs are these imports coming from?  <%@page import = "view.util.JSFUtils" %> <%@page import = "oracle.jbo.domain.Number" %>

Ruslan, the jar files is too big to send too email, I get the jar file when I install CR XI and some of them come from CR Enterprise installation  RT, my reply above is all documentation I have, which step that you dont understand ?  Larry, JSFUtils comes from SRDemo app. oracle.jbo.domain.Number ? this is oracle package.  Thanks, xtanto

Where you ever able to get the reportviewer working with this method? I see you are exporting to PDF.  Thanks  larry

I switched from a JSP to a servlet and it fixed most of my problems.  Larry


Related Links

Is it possible to update attributes in all tables in a multi entity view
Web Services
Application, Project And Work Space
compare number &#38; int
How To execute My Filter Before j_security_check
JDeveloper with JMS
doubled validation error message
Error after submitting the record 'Another user has changed the row'
Firing partialTrigger event of a field when onBlur event occurs on another
Add dinamically RichInputFile on page (Jdev 1.1.1.3.0)
Formatting Date Parameter
return button in task flow
Problem: nothing happens after returnListener of button on popup
CSS Background-color not applying to InputText
Af:selectManyShuttle trailing list
ADF develope