manicarina

Hi , I have created a one main report and two many subreports , while integrating that with ADF. The Subreports were not opening because of the file pathg while creting the subreport. I have tried passing the sub report directory as an parameter. I'm getting the below error. net.sf.jasperreports.engine.JRException: Resource not found at : D1SubReport.jasper at net.sf.jasperreports.repo.RepositoryUtil.getResourceFromLocation(RepositoryUtil.java:255) at net.sf.jasperreports.repo.RepositoryUtil.getReport(RepositoryUtil.java:208) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:336) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:369) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:294) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:259) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:455) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2044) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:778) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:288) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:151) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:909) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:822) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:61) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:446) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:849) at com.bosch.eightd.view.Reports.runReport(Reports.java:779) at com.bosch.eightd.view.Reports.generatePDFReport(Reports.java:854) 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:597) at com.sun.el.parser.AstValue.invoke(Unknown Source) at com.sun.el.MethodExpressionImpl.invoke(Unknown Source) ........................................................................... I'm not using any jasper server..... Please help me in solving the error.

Convert the 2 rows into columns by using LEA/LAG funcation or the PIVOT table funcation in oracle as follows CREATE TABLE EMPLOYEE ( ID NUMBER, ENAME VARCHAR2 (15), SALARY NUMBER, VERSION NUMBER ); INSERT INTO EMPLOYEE ( ENAME, ID, SALARY, VERSION)VALUES ( 'WULFRIC', 100, 5000, 1); INSERT INTO EMPLOYEE ( ENAME, ID, SALARY, VERSION)VALUES ( 'WULFRIC', 100, 6000, 2); COMMIT; SELECT B.ID, B.ENAME, B.SALARY, B.OLD_SALARY, ROWNUM RN FROM (SELECT A.*, ROWNUM RN, LEAD (SALARY) OVER (ORDER BY VERSION DESC) AS OLD_SALARY FROM (SELECT ENAME, ID, SALARY, VERSION FROM EMPLOYEE WHERE ID = 100 AND VERSION = 2 UNION SELECT ENAME, ID, SALARY, VERSION FROM EMPLOYEE WHERE ID = 100 AND VERSION = 1 ORDER BY VERSION DESC) A WHERE ROWNUM <= 2) B WHERE ROWNUM <= 1; IDENAMESALARYOLD_SALARYRN100WULFRIC6,0005,0001You'll get the above result and use conditional style formatting in IReport. Thank you.

I have an employee record when evere a value is changed for example if the salary of the employee is changed a new version of the employee record is created in the table as given below EMPLOYEE TABLEEMP IDENAMESALARYVERSION100WULFRIC50001100WULFRIC60002SELECT * FROM EMPLOYEE WHERE EMP_ID = $P{P_KOMBINATIONSNR} SELECT * FROM EMPLOYEE WHERE EMP_ID = 100 AND VERSION = (($F{VERSION}-1)) In the intial report i'll be showing the highest version record and I need to higlight the Changed salary value as Red color. Please Give me solution to do this in Ireport.