aruninvitesu Posted December 11, 2009 Share Posted December 11, 2009 Hi,I created a jrxml file using iReport 3.5.0 . in that jrxml file i applied some style condition. while loading that jrxml from java code i get error. but if i run a jrxml without style property jrxml file loaded and compiled in java. i get the following error while running jrxml with style property java.lang.ClassCastException: net.sf.jasperreports.engine.design.JRDesignStyle cannot be cast to net.sf.jasperreports.engine.JRBox at net.sf.jasperreports.engine.xml.JRBoxFactory.createObject(JRBoxFactory.java:49) at org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:390) at org.apache.commons.digester.Digester.startElement(Digester.java:1453) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.startElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.apache.commons.digester.Digester.parse(Digester.java:1745) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:238) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:225) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:213) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:167) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:151) at net.sf.jasperreports.engine.JasperManager.loadXmlDesign(JasperManager.java:971) at com.radaptive.rdpv.runtime.service.triggeraction.JasperReportTriggerAction.execute(JasperReportTriggerAction.java:35) at com.radaptive.rdpv.runtime.service.impl.TriggerHandler.applyAttachedTriggers(TriggerHandler.java:232) at com.radaptive.rdpv.runtime.service.impl.FormServiceImpl.postFormProcess(FormServiceImpl.java:310) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.radaptive.common.ExceptionInterceptor.invoke(ExceptionInterceptor.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy58.postFormProcess(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy59.postFormProcess(Unknown Source) at com.radaptive.rdpv.runtime.service.impl.FormServiceImpl.createForm(FormServiceImpl.java:211) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at com.radaptive.common.ExceptionInterceptor.invoke(ExceptionInterceptor.java:59) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy58.createForm(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy59.createForm(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:301) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy59.createForm(Unknown Source) at com.radaptive.webapp.action2.runtime.FormAction.saveForm(FormAction.java:1908) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.radaptive.webapp.action2.common.BaseAction.execute(BaseAction.java:89) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:434) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:273) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:235) at com.radaptive.webapp.interceptor.ParamMapInterceptor.intercept(ParamMapInterceptor.java:64) at com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:230) at com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:229) at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:456) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:227) at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:170) at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86) at com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:230) at com.opensymphony.xwork2.DefaultActionInvocation$1.doProfiling(DefaultActionInvocation.java:229) at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:456) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:227) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:477) at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:467) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229) at com.radaptive.webapp.filter.UserPreferencesAwareFilter.doFilter(UserPreferencesAwareFilter.java:45) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) any suggestions,Thanks in advance ,Arun Link to comment Share on other sites More sharing options...
Teodor Danciu Posted December 12, 2009 Share Posted December 12, 2009 Hi, Post the JRXML here and tell us what version of JasperReports are you using in your application when you try to load it.Also, make sure you need to compile JRXML at runtime. Usually you don't, as you can deploy already compiled *.jasper files with your application:http://jasperforge.org/uploads/publish/jasperreportswebsite/trunk/faq.html?group_id=252#FAQ22 I hope this helps.Teodor Link to comment Share on other sites More sharing options...
aruninvitesu Posted December 12, 2009 Author Share Posted December 12, 2009 HI Thanks for your replyi used iReport 3.5.0 for designing jrxml. and used jasperreports1.3.1.jar in my application if i load and compile simple jrxml file its working fine but getting error for style applied jrxml file. below i mentioned my java implementation and jrxml file.String fileName="F:\\test.jrxml"; File file=new File(fileName); System.out.println("ifile exist"+file.exists()); JasperDesign jasperDesign = JRXmlLoader.load(file); System.out.println("design"+jasperDesign.getName()); jasperReport = JasperCompileManager.compileReport(jasperDesign); Map parameters = new HashMap(); String pdfPath = triggerContext.getServices().getJasperService().getJasperReportasPDF(jasperReport,parameters); here's my java code. any more ideas Thanks in advancearun Code:<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="test" pageWidth="612" pageHeight="792" columnWidth="552" leftMargin="30" rightMargin="30" topMargin="20" bottomMargin="20"> <property name="com.jaspersoft.ji.adhoc" value="1"/> <property name="net.sf.jasperreports.export.pdf.tagged" value="true"/> <property name="net.sf.jasperreports.export.pdf.tag.language" value="EN-US"/> <style name="ReportDefault" isDefault="true" mode="Transparent" forecolor="#111133" backcolor="#FFFFFF" hAlign="Left" vAlign="Middle" fontName="Arial" fontSize="11" pdfFontName="Helvetica"> <box> <pen lineColor="#003399"/> </box> </style> <style name="PageHeaderFooter" isDefault="false" style="ReportDefault" forecolor="#666666" vAlign="Top" fontName="Arial" fontSize="9"> <pen lineWidth="1.0" lineStyle="Solid"/> </style> <style name="Group1HeaderFooter" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#FCFBDF" fontName="Arial" fontSize="12" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="Group1Header" isDefault="false" style="Group1HeaderFooter"/> <style name="Group1Footer" isDefault="false" style="Group1HeaderFooter"/> <style name="Group2HeaderFooter" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#DEEBFF" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="Group2Header" isDefault="false" style="Group2HeaderFooter"/> <style name="Group2Footer" isDefault="false" style="Group2HeaderFooter"/> <style name="Group3HeaderFooter" isDefault="false" style="ReportDefault" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="Group3Header" isDefault="false" style="Group3HeaderFooter"/> <style name="Group3Footer" isDefault="false" style="Group3HeaderFooter"/> <style name="ColumnHeaderFooter" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#000000" backcolor="#FFFFFF" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> <topPen lineWidth="0.5" lineStyle="Solid"/> <leftPen lineWidth="0.5" lineStyle="Solid"/> <bottomPen lineWidth="0.5" lineStyle="Solid"/> <rightPen lineWidth="0.5" lineStyle="Solid"/> </box> </style> <style name="TableSummaries" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#E5E5E4" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> <topPen lineWidth="0.5" lineStyle="Solid"/> <bottomPen lineWidth="0.5" lineStyle="Solid"/> </box> </style> <style name="Title" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#FFFFFF" backcolor="#18397B" hAlign="Center" fontName="Arial" fontSize="14" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> <topPen lineWidth="0.0" lineStyle="Solid"/> </box> </style> <style name="Details" isDefault="false" style="ReportDefault" mode="Opaque"> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{PRIORITY}.equals("Severity 0"))]]></conditionExpression> <style isDefault="false" style="Details" forecolor="#000000" backcolor="#FE7352"/> </conditionalStyle> </style> <style name="colorCode" isDefault="false" style="Details" mode="Opaque"> <box> <pen lineColor="#003399"/> <leftPen lineWidth="0.5" lineStyle="Solid"/> <bottomPen lineWidth="0.5" lineStyle="Solid"/> <rightPen lineWidth="0.5" lineStyle="Solid"/> </box> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{PRIORITY}.equals("Severity 3"))]]></conditionExpression> <style isDefault="false" style="colorCode" forecolor="#000000" backcolor="#A3C29C"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{PRIORITY}.equals("Severity 2"))]]></conditionExpression> <style isDefault="false" style="colorCode" forecolor="#000000" backcolor="#BDE8FC"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{PRIORITY}.equals("Severity 1-E"))]]></conditionExpression> <style isDefault="false" style="colorCode" forecolor="#1B0F0F" backcolor="#F4F08A"/> </conditionalStyle> <conditionalStyle> <conditionExpression><![CDATA[new Boolean($F{PRIORITY}.equals("Severity 1"))]]></conditionExpression> <style isDefault="false" style="colorCode" forecolor="#1E1515" backcolor="#FFAFAF"/> </conditionalStyle> </style> <style name="CrosstabDefaults" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#111133" vAlign="Middle" fontName="Arial" fontSize="11" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabTitleStyle" isDefault="false" style="ReportDefault" mode="Transparent" forecolor="#003399" hAlign="Center" vAlign="Middle" fontName="Arial" fontSize="13" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabColumn1" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#FFFFFF" backcolor="#4D7DDE" hAlign="Center" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabColumn2" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#E5E5E4" hAlign="Center" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabColumn3" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#F3F7FD" hAlign="Center" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabRow1" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#FCFBDF" hAlign="Left" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabRow2" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#DEEBFF" hAlign="Left" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabRow3" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#3366CC" backcolor="#F3F7FD" hAlign="Left" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabGrandTotal" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#FFFFFF" backcolor="#4D7DDE" hAlign="Center" vAlign="Middle" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabColumnWidth" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#111133" vAlign="Middle" fontName="Arial" fontSize="11" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabRowWidth" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#111133" vAlign="Middle" fontName="Arial" fontSize="11" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="CrosstabMeasureCell" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#111133" backcolor="#FFFFFF" vAlign="Middle" fontName="Arial" fontSize="10" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> </box> </style> <style name="ChartReportTitle" isDefault="false" style="ReportDefault" mode="Opaque" forecolor="#FFFFFF" backcolor="#4D7DDE" hAlign="Center" fontName="Arial" fontSize="18" isBold="true" pdfFontName="Helvetica-Bold"> <box> <pen lineColor="#003399"/> <topPen lineWidth="0.0" lineStyle="Solid"/> </box> </style> <style name="ChartTitle" isDefault="false" forecolor="#003399" fontName="Arial" fontSize="12" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="ChartSubtitle" isDefault="false" forecolor="#111133" fontName="Arial" fontSize="9" isBold="false" pdfFontName="Helvetica"/> <style name="ChartLegend" isDefault="false" forecolor="#111133" backcolor="#FFFFFF" fontName="Verdana" fontSize="9" isBold="false" pdfFontName="Helvetica"/> <style name="ChartSeriesColor0" isDefault="false" backcolor="#CCE0FF"/> <style name="ChartSeriesColor1" isDefault="false" backcolor="#003399"/> <style name="ChartSeriesColor2" isDefault="false" backcolor="#FCFBDF"/> <style name="ChartSeriesColor3" isDefault="false" backcolor="#4D7DDE"/> <style name="ChartSeriesColor4" isDefault="false" backcolor="#E5E5E4"/> <style name="ChartSeriesColor5" isDefault="false" backcolor="#FCDBCF"/> <style name="ChartSeriesColor6" isDefault="false" backcolor="#FFFFFF"/> <style name="ChartSeriesColor7" isDefault="false" backcolor="#E8FCCA"/> <style name="ChartCategoryAxisLabelFormat" isDefault="false" forecolor="#3366CC" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="ChartCategoryAxisTickFormat" isDefault="false" forecolor="#111133" fontName="Verdana" fontSize="9" isBold="false" pdfFontName="Helvetica"/> <style name="ChartValueAxisLabelFormat" isDefault="false" forecolor="#3366CC" fontName="Arial" fontSize="11" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="ChartValueAxisTickFormat" isDefault="false" forecolor="#111133" fontName="Verdana" fontSize="9" isBold="false" pdfFontName="Helvetica"/> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["/home/arun/Desktop/reports/final reports/Reports for Motorolo/"]]></defaultValueExpression> </parameter> <queryString> <![CDATA[sELECT (SELECT COUNT(RTC.ID) FROM CORE RTC ,PROBLEM RTP WHERE RTC.ID=RTP.ID AND RTC.ROLLUP_STATUS ='Open' total_count, RTC.ID,RTC.TITLE,RTC.PRIORITY,RTC.ASSIGNEE,RTC.MODIFIEDTIME FROM CORE RTC , PROBLEM RTP WHERE ASSIGNEDGROUP ='' ORDER BY PRIORITY LIMIT 8]]> </queryString> <field name="total_count" class="java.lang.Long"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="ID" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="TITLE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PRIORITY" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="ASSIGNEE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="MODIFIEDTIME" class="java.sql.Timestamp"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <variable name="InnerRowCount" class="java.lang.Integer" resetType="None"> <variableExpression><![CDATA[$V{REPORT_COUNT}]]></variableExpression> </variable> <variable name="COUNT(RTC.ID)_1" class="java.lang.Long" calculation="Sum"> <variableExpression><![CDATA[]]></variableExpression> </variable> <title> <band height="55"> <staticText> <reportElement x="0" y="0" width="125" height="30"/> <textElement> <font isBold="true"/> </textElement> <text><![CDATA[Total Incidents Open:]]></text> </staticText> <staticText> <reportElement key="staticText" style="Title" x="0" y="30" width="552" height="25"/> <box> <pen lineWidth="0.5" lineColor="#130707"/> <topPen lineWidth="0.5" lineColor="#130707"/> <leftPen lineWidth="0.5" lineColor="#130707"/> <bottomPen lineWidth="0.5" lineColor="#130707"/> <rightPen lineWidth="0.5" lineColor="#130707"/> </box> <textElement textAlignment="Center"/> <text><![CDATA[incident - NOC/Open]]></text> </staticText> <textField> <reportElement x="128" y="0" width="229" height="30"/> <textElement> <font isBold="true"/> </textElement> <textFieldExpression class="java.lang.Long"><![CDATA[$F{total_count} == null ? new Long (0) : $F{total_count}]]></textFieldExpression> </textField> </band> </title> <pageHeader> <band/> </pageHeader> <columnHeader> <band height="25"> <frame> <reportElement style="ColumnHeaderFooter" isPrintRepeatedValues="false" mode="Opaque" x="0" y="0" width="552" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.table" value="start"/> <property name="net.sf.jasperreports.export.pdf.tag.tr" value="full"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#170707"/> <topPen lineWidth="0.5" lineColor="#170707"/> <leftPen lineWidth="0.5" lineColor="#170707"/> <bottomPen lineWidth="0.5" lineColor="#170707"/> <rightPen lineWidth="0.5" lineColor="#170707"/> </box> <textField isBlankWhenNull="true"> <reportElement style="ColumnHeaderFooter" positionType="Float" x="0" y="0" width="80" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/> </reportElement> <box> <pen lineWidth="0.0" lineColor="#0D0909"/> <topPen lineWidth="0.0" lineColor="#0D0909"/> <leftPen lineWidth="0.0" lineColor="#0D0909"/> <bottomPen lineWidth="0.0" lineColor="#0D0909"/> <rightPen lineWidth="0.0" lineColor="#0D0909"/> </box> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA["Id"]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement style="ColumnHeaderFooter" x="81" y="0" width="197" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/> </reportElement> <box> <pen lineWidth="0.0" lineColor="#150909"/> <topPen lineWidth="0.0" lineColor="#150909"/> <leftPen lineWidth="0.0" lineColor="#150909"/> <bottomPen lineWidth="0.0" lineColor="#150909"/> <rightPen lineWidth="0.0" lineColor="#150909"/> </box> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA["Title"]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement style="ColumnHeaderFooter" x="279" y="0" width="74" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/> </reportElement> <box> <pen lineWidth="0.0" lineColor="#0A0303"/> <topPen lineWidth="0.0" lineColor="#0A0303"/> <leftPen lineWidth="0.0" lineColor="#0A0303"/> <bottomPen lineWidth="0.0" lineColor="#0A0303"/> <rightPen lineWidth="0.0" lineColor="#0A0303"/> </box> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA["Priority"]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement style="ColumnHeaderFooter" x="354" y="0" width="81" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/> </reportElement> <box> <pen lineWidth="0.0" lineColor="#0C0A0A"/> <topPen lineWidth="0.0" lineColor="#0C0A0A"/> <leftPen lineWidth="0.0" lineColor="#0C0A0A"/> <bottomPen lineWidth="0.0" lineColor="#0C0A0A"/> <rightPen lineWidth="0.0" lineColor="#0C0A0A"/> </box> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA["Assignee"]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement style="ColumnHeaderFooter" x="436" y="0" width="116" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.th" value="full"/> </reportElement> <box> <pen lineWidth="0.0" lineColor="#0B0707"/> <topPen lineWidth="0.0" lineColor="#0B0707"/> <leftPen lineWidth="0.0" lineColor="#0B0707"/> <bottomPen lineWidth="0.0" lineColor="#0B0707"/> <rightPen lineWidth="0.0" lineColor="#0B0707"/> </box> <textElement textAlignment="Center"/> <textFieldExpression class="java.lang.String"><![CDATA["Modified Time"]]></textFieldExpression> </textField> <line> <reportElement x="80" y="0" width="1" height="25"/> </line> <line> <reportElement x="278" y="0" width="1" height="25"/> </line> <line> <reportElement x="353" y="0" width="1" height="25"/> </line> <line> <reportElement x="435" y="0" width="1" height="25"/> </line> </frame> </band> </columnHeader> <detail> <band height="25"> <frame> <reportElement style="colorCode" positionType="Float" isPrintRepeatedValues="false" mode="Opaque" x="0" y="0" width="552" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.tr" value="full"/> </reportElement> <box> <pen lineWidth="0.5" lineColor="#100606"/> <topPen lineWidth="0.5" lineColor="#100606"/> <leftPen lineWidth="0.5" lineColor="#100606"/> <bottomPen lineWidth="0.5" lineColor="#100606"/> <rightPen lineWidth="0.5" lineColor="#100606"/> </box> <textField isStretchWithOverflow="true" isBlankWhenNull="true" hyperlinkType="Reference" hyperlinkTarget="Blank"> <reportElement key="textField" x="0" y="0" width="80" height="25" forecolor="#0000FF"> <property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/> </reportElement> <box leftPadding="5"> <pen lineWidth="0.0" lineColor="#090404"/> <topPen lineWidth="0.0" lineColor="#090404"/> <leftPen lineWidth="0.0" lineColor="#090404"/> <bottomPen lineWidth="0.0" lineColor="#090404"/> <rightPen lineWidth="0.0" lineColor="#090404"/> </box> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{ID}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement key="textField" mode="Transparent" x="81" y="0" width="197" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/> </reportElement> <box leftPadding="5"> <pen lineWidth="0.0" lineColor="#0E0707"/> <topPen lineWidth="0.0" lineColor="#0E0707"/> <leftPen lineWidth="0.0" lineColor="#0E0707"/> <bottomPen lineWidth="0.0" lineColor="#0E0707"/> <rightPen lineWidth="0.0" lineColor="#0E0707"/> </box> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.String"><![CDATA[$F{TITLE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="textField" x="354" y="0" width="81" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/> </reportElement> <box leftPadding="5"> <pen lineWidth="0.0" lineColor="#120808"/> <topPen lineWidth="0.0" lineColor="#120808"/> <leftPen lineWidth="0.0" lineColor="#120808"/> <bottomPen lineWidth="0.0" lineColor="#120808"/> <rightPen lineWidth="0.0" lineColor="#120808"/> </box> <textElement textAlignment="Left"/> <textFieldExpression class="java.lang.String"><![CDATA[$F{ASSIGNEE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement key="textField" x="436" y="0" width="116" height="25"> <property name="net.sf.jasperreports.export.pdf.tag.td" value="full"/> </reportElement> <box leftPadding="5"> <pen lineWidth="0.0" lineColor="#060404"/> <topPen lineWidth="0.0" lineColor="#060404"/> <leftPen lineWidth="0.0" lineColor="#060404"/> <bottomPen lineWidth="0.0" lineColor="#060404"/> <rightPen lineWidth="0.0" lineColor="#060404"/> </box> <textElement textAlignment="Left"/> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{MODIFIEDTIME}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="279" y="0" width="74" height="25"/> <box leftPadding="5"> <pen lineWidth="0.0" lineColor="#0D0909"/> <topPen lineWidth="0.0" lineColor="#0D0909"/> <leftPen lineWidth="0.0" lineColor="#0D0909"/> <bottomPen lineWidth="0.0" lineColor="#0D0909"/> <rightPen lineWidth="0.0" lineColor="#0D0909"/> </box> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{PRIORITY}]]></textFieldExpression> </textField> <line> <reportElement x="80" y="0" width="1" height="25"/> </line> <line> <reportElement x="278" y="0" width="1" height="25"/> </line> <line> <reportElement x="353" y="0" width="1" height="25"/> </line> <line> <reportElement x="435" y="0" width="1" height="25"/> </line> </frame> </band> </detail> <columnFooter> <band/> </columnFooter> <summary> <band/> </summary></jasperReport> Link to comment Share on other sites More sharing options...
lucianc Posted December 14, 2009 Share Posted December 14, 2009 aruninvitesuWrote: i used iReport 3.5.0 for designing jrxml. and used jasperreports1.3.1.jar in my application JR 1.3.1 does not work with reports designed by iReport 3.5.0. Use JR 3.5.0 or newer.Regards,Lucian Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now