fachhoch

Please help me with this In my report I have this field expression <textFieldExpression class="java.lang.String"><![CDATA[$F{FINDING_NUMBER}]]></textFieldExpression> for this texfieldexpression can I call a method from my own java class passsing it some input parameters like $F{FINDING_NUMBER} and something else , please help me. Code:<textFieldExpression class="java.lang.String"><![CDATA[$F{FINDING_NUMBER}]]></textFieldExpression>

I have a subreport which uses report query , this report query returns multiple rows so my subreport also repeates . Now a new requirement I have to add a new filed to this report and the value of this field comes from a java class not from the query and if query return multiple rows this field value has to computed for each row. what I want is for each row returned by the query my java class should be called passing some field value as input parameter so that this can return computed value , please advice me how?

<textField isBlankWhenNull="true"> <reportElement positionType="Float" x="136" y="57" width="120" height="12"/> <textElement> <font fontName="Microsoft Sans Serif" size="8" pdfFontName="Microsoft Sans Serif" isPdfEmbedded="true"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$P{FOLLOW_UP}.equals("noSelection")?"Yes[ ] No[ ]":$P{FOLLOW_UP}.equals("selectYes")?"Yes[X] No[ ]" :"Yes[ ] No[X]" ]]></textFieldExpression> I am using this java code for the value textfiled. Whne I tested this in iReport it worksbut when I try it from java the value is blank ,is ther any way to debug this?

I am trying to use design table using ireport version 3.5.2 I managed to create a table using static text label as header and textfiled for rows please tell me If I can add border to the report so that it will look like a real table , please advice me below is my jrxml 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="report name" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <style name="Crosstab Data Text" isDefault="false" hAlign="Center"/> <queryString> <![CDATA[select * from ea_audit_general]]> </queryString> <field name="EIN" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <background> <band splitType="Stretch"/> </background> <title> <band height="113" splitType="Stretch"/> </title> <pageHeader> <band height="35" splitType="Stretch"> <staticText> <reportElement x="231" y="0" width="100" height="20"/> <textElement/> <text><![CDATA[Audits-Report]]></text> </staticText> </band> </pageHeader> <columnHeader> <band height="61" splitType="Stretch"> <staticText> <reportElement x="0" y="0" width="55" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[Audit Resolution]]></text> </staticText> <staticText> <reportElement x="55" y="0" width="84" height="61"/> <textElement/> <text><![CDATA[Audit Number]]></text> </staticText> <staticText> <reportElement x="214" y="0" width="42" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[Audit Received by OPDIV on]]></text> </staticText> <staticText> <reportElement x="178" y="0" width="36" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[Audit Period Begin Date]]></text> </staticText> <staticText> <reportElement x="256" y="0" width="57" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[Grantee Name]]></text> </staticText> <staticText> <reportElement x="422" y="0" width="46" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[Grant Program]]></text> </staticText> <staticText> <reportElement x="313" y="0" width="31" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[EIN]]></text> </staticText> <staticText> <reportElement x="344" y="0" width="38" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[DUNS]]></text> </staticText> <staticText> <reportElement x="468" y="0" width="39" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[Grant Identifier]]></text> </staticText> <staticText> <reportElement x="507" y="0" width="48" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[Findings Count]]></text> </staticText> <staticText> <reportElement x="382" y="0" width="40" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[state]]></text> </staticText> <staticText> <reportElement x="139" y="0" width="39" height="61" isPrintWhenDetailOverflows="true"/> <textElement/> <text><![CDATA[Audit Period End Date]]></text> </staticText> </band> </columnHeader> <detail> <band height="50"> <textField isStretchWithOverflow="true"> <reportElement x="55" y="0" width="84" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{FORMATTED_AUDIT_NUMBER}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement isPrintRepeatedValues="false" x="0" y="0" width="55" height="20" isPrintWhenDetailOverflows="true"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{AUDIT_REVIEW_CODE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="139" y="0" width="39" height="20"/> <textElement/> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{AUDIT_BEGIN_DATE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="178" y="0" width="36" height="20" isPrintWhenDetailOverflows="true"/> <textElement/> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{AUDIT_END_DATE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="214" y="0" width="42" height="20" isPrintWhenDetailOverflows="true"/> <textElement/> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{AUDIT_BATCH_RECEIVED_DATE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="256" y="0" width="57" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{AUDITEE_NAME}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="313" y="0" width="31" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{EIN}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="344" y="0" width="38" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{DUNS}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="382" y="0" width="40" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{STATE}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="422" y="0" width="46" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{AUDITEE_NAME}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="468" y="0" width="39" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{AUDITEE_NAME}]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true"> <reportElement x="507" y="0" width="48" height="20"/> <textElement/> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{AS_USER_ID}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary></jasperReport>

I want to convert html to excel dynamically ,I have an old HTML-generating servlet , I want to read the servlet and create excel , can jasper or any other tool help me , please suggest me .

can jasper create pdf files from html?

Thank you for your reply.It worked. now a new doubt, with this approach can I test my reports with preview button using Ireport ? the problen is how can I tell Ireport about the SubreportsMap parameter ? Post Edited by fachhoch at 02/05/2010 13:31

I will place all my compiled reports in a hashMap, its not inside a jar file or not in classpath. In this case please tell me how can I tell the main report where to find the subreport ?

Ok I will put in other words. My reports have subreports , any report with subreport have to tell where to find subreport. In my case all my compiled jasper objects are in a HashMap . Please tell me what should be the subreport expression? I have Report A and a subreport B In A I have to provide subreport expression to find B please tell me what should the expression for B .

If I transfer the .jasper from database into a object instance at startup , so the . jasper is not in filesytem but it is in memory, in an instance object , and this report uses sub-report and this also gets loaded into an object instance , till now I was placing my .jasper inside my jar file , so I used the subreport expression <subreportExpression class="java.lang.String"><![CDATA["com/tnt/acf/document/ClearanceDocument_1.jasper"]]></subreportExpression> if the subreport is not in a package and is within an object instance , what should be the subreport expression?

we use tinymce rich text editor and the text from these editors goes to jasperreports pdf, it displays all html code in generated pdf , isthere a way jasper can translate the html to pdf format?

Please tell me the jasper reports version to generate reports from .jasper files created by ireport version 3.5.2

I am getting this exception java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException I am sure I am not using anything from grrovy , does jasper neds this ? here stack trace java.lang.NoClassDefFoundError: org/codehaus/groovy/control/CompilationFailedException at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389) at java.lang.Class.getConstructor0(Class.java:2699) at java.lang.Class.newInstance0(Class.java:326) at java.lang.Class.newInstance(Class.java:308) at net.sf.jasperreports.engine.JasperCompileManager.getCompiler(JasperCompileManager.java:476) at net.sf.jasperreports.engine.JasperCompileManager.loadEvaluator(JasperCompileManager.java:242) at net.sf.jasperreports.engine.fill.JRFillDataset.createCalculator(JRFillDataset.java:420) at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:411) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:78) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:60) at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:147) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:57) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:382) at gov.hhs.acf.document.JasperFillManagerWrapper.getJasperPrint(JasperFillManagerWrapper.java:29) at gov.hhs.acf.document.AuditDocumentService.generateMemo(AuditDocumentService.java:62) at gov.hhs.acf.document.AuditDocumentService.generateAdl(AuditDocumentService.java:79) 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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) 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 org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy47.generateAdl(Unknown Source) at gov.hhs.acf.ea.service.DefaultEaAuditProgramService.createAdl(DefaultEaAuditProgramService.java:200) 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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310) 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 org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy49.createAdl(Unknown Source) 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 org.apache.wicket.proxy.LazyInitProxyFactory$JdkHandler.invoke(LazyInitProxyFactory.java:416) at org.apache.wicket.proxy.$Proxy77.createAdl(Unknown Source) at gov.hhs.acf.web.pages.auditprogram.AdlListPage.createDocument(AdlListPage.java:33) at gov.hhs.acf.web.pages.auditprogram.DocumentsListPage$1.onClick(DocumentsListPage.java:50) at org.apache.wicket.ajax.markup.html.AjaxFallbackLink$1.onEvent(AjaxFallbackLink.java:73) at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:177) at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:299) at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:113) at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1428) at org.apache.wicket.RequestCycle.request(RequestCycle.java:545) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:456) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:289) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1112) at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363) at org.mortbay.jetty.security.ConstraintsSecurityHandler.handle(ConstraintsSecurityHandler.java:220) at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:822) at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:305) at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:229) at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:113) at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) at org.mortbay.jetty.Server.handle(Server.java:324) at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:550) at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:876) at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:535) at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:209) at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:407) at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:421) at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520) Caused by: java.lang.ClassNotFoundException: org.codehaus.groovy.control.CompilationFailedException at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at java.lang.ClassLoader.loadClass(ClassLoader.java:252) at org.codehaus.plexus.classworlds.realm.ClassRealm.loadRealmClass(ClassRealm.java:174) at org.codehaus.plexus.classworlds.strategy.DefaultStrategy.loadClass(DefaultStrategy.java:67) at org.codehaus.plexus.classworlds.strategy.ForeignStrategy.loadClass(ForeignStrategy.java:39) at org.codehaus.plexus.classworlds.realm.ClassRealm.loadClass(ClassRealm.java:201) at org.codehaus.plexus.classworlds.strategy.DefaultStrategy.loadClass(DefaultStrategy.java:73) at org.codehaus.plexus.classworlds.realm.ClassRealm.loadClass(ClassRealm.java:201) at org.mortbay.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:326) at org.mortbay.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:279) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) ... 86 more

I can create the document using ireport but If I do this with java it fails and here is the error message Caused by: java.lang.ClassNotFoundException: org.codehaus.groovy.control.CompilationFailedException at java.net.URLClassLoader$1.run(URLClassLoader.java:200) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:188) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at java.lang.ClassLoader.loadClass(ClassLoader.java:252) at org.codehaus.plexus.classworlds.realm.ClassRealm.loadRealmClass(ClassRealm.java:174) at org.codehaus.plexus.classworlds.strategy.DefaultStrategy.loadClass(DefaultStrategy.java:67) at org.codehaus.plexus.classworlds.strategy.ForeignStrategy.loadClass(ForeignStrategy.java:39) at org.codehaus.plexus.classworlds.realm.ClassRealm.loadClass(ClassRealm.java:201) at org.codehaus.plexus.classworlds.strategy.DefaultStrategy.loadClass(DefaultStrategy.java:73) at org.codehaus.plexus.classworlds.realm.ClassRealm.loadClass(ClassRealm.java:201) at org.mortbay.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:326) at org.mortbay.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:279) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320) I am surprised why is it asking for groovy , does jasper reports needs grrovy in classpath , I did not add grovy to ireport classpath but still it works there

is there any settin in ireport which prompts user to save the complied .jasper file to desired location , I am using ireport3.5.2 every time I complie ireport saves the .jasper in the same location of .jrxml , intstead can I configure ireport to prompt user where to save the .jasper file ?

We put all our compiled reports inside a package and this package is indside a jar file. here is spring bean configration <bean id="documentFillManagerWrapper" class="gov.fema.JasperFillManagerWrapper"> <property name="sourceFile" value="gov/fema/document//Document1.jasper"/> <property name="dataSource" ref="dataSource"/> </bean> here the sourceFile is the path to my jasper report . Inside this wrapper JasperFillManager.fillReport(getClass().getClassLoader().getResourceAsStream(sourceFile) , parameters, con) I pass the Inputstream of the .jasper file to JasperFillManager , i also pass other parameters , but I have this SUBREPORT_DIR parameter which is the directory path where my sub reports arre located , because all my compiled reports are in a jar file and directory for the contents of the jar file does not make sense , please suggest me how can I pass the value to SUBREPORT_DIR ?

We are using Ireport to create .jrxml .Ireport creates the parameter SUBREPORT_DIR , Our application we place all the jrxml files inside one package , Is there any value which tells jasper reports the subreport_dir is the same directory where the parent report is ?

We are creating jasper report using sql query .One of our column is clob which contains html markup language, so just wondering will there be any problems in creating pdf ? This column get populated by rich text editor tinymce , please suggest me what problems will I come across ?