ahmedkamal86

Hi, i want get Day Of Week for date field , and how import my java classes to use in jasper report . thanks.

Hi , I create master report and five sub reports , for any simple report in my project i used JRResultDataSource to fill report as query SELECT EMPLOYEEDATA_VIEW."EMP_CODE" AS EMP_CODE, EMPLOYEEDATA_VIEW."EMP_FULLNAMEAR" AS EMP_FULLNAMEAR, EMPLOYEEDATA_VIEW."EMP_BIRTHDATE" AS EMP_BIRTHDATE, EMPLOYEEDATA_VIEW."EMP_SERIAL" AS EMP_SERIAL FROM "HRMS"."EMPLOYEEDATA_VIEW" EMPLOYEEDATA_VIEW where emp_code in ($P{emp_codes}) my problem in sub report how fill sub reports for more employees . and how make report connection in sub reports as datasource or report connection . i attach the master report is employee detail and sub reports .

hi , how r u ? my question how pass rounding and decimal and appear numbers in rounding and decimal . such as in crystal reports . thanks .

hi , how r u ? i make report with only one band for page footer , this report is two pages with page break , i make page break and anothers components in another page with print when expression, this page if print when expression is false , this report appear very simple in paper print . my question how make report and page height is variable ? thanks .

thanks for reply me . i download jfreechart and jcommon . and add it to lib . but there are another runtime exception that chart theme"simple" not found . thanks.

hi, how r u , when fill report with chart , i get exception that javax.faces.el.EvaluationException: java.lang.NoClassDefFoundError: Lorg/jfree/chart/plot/PlotOrientation; Caused by: java.lang.NoClassDefFoundError: Lorg/jfree/chart/plot/PlotOrientation; what problem ? please help me . thanks . Code:javax.faces.el.EvaluationException: java.lang.NoClassDefFoundError: Lorg/jfree/chart/plot/PlotOrientation; at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:150) at oracle.adf.view.faces.component.UIXComponentBase.__broadcast(UIXComponentBase.java:1087) at oracle.adf.view.faces.component.UIXCommand.broadcast(UIXCommand.java:234) at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:269) at javax.faces.component.UIViewRoot.processDecodes(UIViewRoot.java:327) at com.sun.faces.lifecycle.ApplyRequestValuesPhase.execute(ApplyRequestValuesPhase.java:99) at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:245) at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:110) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:213) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.webcache.adf.filter.PageCachingFilter.doFilter(PageCachingFilter.java:274) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._invokeDoFilter(AdfFacesFilterImpl.java:233) at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl._doFilterImpl(AdfFacesFilterImpl.java:202) at oracle.adfinternal.view.faces.webapp.AdfFacesFilterImpl.doFilter(AdfFacesFilterImpl.java:123) at oracle.adf.view.faces.webapp.AdfFacesFilter.doFilter(AdfFacesFilter.java:103) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)Caused by: java.lang.NoClassDefFoundError: Lorg/jfree/chart/plot/PlotOrientation; at java.lang.Class.getDeclaredFields0(Native Method) at java.lang.Class.privateGetDeclaredFields(Class.java:2232) at java.lang.Class.getDeclaredField(Class.java:1852) at java.io.ObjectStreamClass.getDeclaredSUID(ObjectStreamClass.java:1555) at java.io.ObjectStreamClass.access$600(ObjectStreamClass.java:47) at java.io.ObjectStreamClass$2.run(ObjectStreamClass.java:381) at java.security.AccessController.doPrivileged(Native Method) at java.io.ObjectStreamClass.<init>(ObjectStreamClass.java:373) at java.io.ObjectStreamClass.lookup(ObjectStreamClass.java:268) at java.io.ObjectStreamClass.initNonProxy(ObjectStreamClass.java:504) at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1546) at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1460) at java.io.ObjectInputStream.readNonProxyDesc(ObjectInputStream.java:1546) at java.io.ObjectInputStream.readClassDesc(ObjectInputStream.java:1460) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1693) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1912) at java.io.ObjectInputStream.defaultReadObject(ObjectInputStream.java:468) at net.sf.jasperreports.engine.base.JRBaseChart.readObject(JRBaseChart.java:1270) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:919) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1813) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:339) at java.util.ArrayList.readObject(ArrayList.java:591) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeReadObject(ObjectStreamClass.java:919) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1813) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1912) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1836) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1912) at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1836) at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1713) at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1299) at java.io.ObjectInputStream.readObject(ObjectInputStream.java:339) at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:92) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:515) at hardtaskHR.userInterface.backing.jsp.JasperReportBean.fillReport(JasperReportBean.java:226) at hardtaskHR.userInterface.backing.jsp.Reports.EN.AdminReports.AdminReportsPage.openReport(AdminReportsPage.java:1735) at hardtaskHR.userInterface.backing.jsp.Reports.EN.AdminReports.AdminReportsPage.btnReturnSearch_action(AdminReportsPage.java:630) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:146) ... 25 more

hi, how get day and month and year and dayWeek of field Date . and how use calendar class to get these variables . thanks.

please give me actual example for my problem because i try to use unicode code but give me unicode character such as احمد equl to u0627....... thanks. Post Edited by ahmed kamal at 03/16/09 17:29

hi, i put static text in my report and write in it arabic name , this is code , <staticText> <reportElement mode="Opaque"> <textElement> <font size="12" pdfFontName="ARIAL.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/> <text><![CDATA[احمد]]></text> </staticText> when close report and open again appear arabic name as ???????? . i didn't know what problem ? please help me . thanks. Code:<staticText><reportElement mode="Opaque"><textElement><font size="12" pdfFontName="ARIAL.TTF" pdfEncoding="Identity-H" isPdfEmbedded="true"/><text><![CDATA[احمد]]></text></staticText>

Code:hi , how are you ? please i want make report with jasper report based on stroed procedure , this procedure make by oracle pl/sql . thanks .

hello, i am begin in jasper report and i want please change background of group based on my parameters for examlpe i am make parameter for color called p_color , when pass it as string "#ffffff" change background of color . thanks.