<![CDATA[Latest Hot Topics]]> http://jasperforge.org/ <![CDATA[Latest Hot Topics]]> http://jasperforge.org/ http://jasperforge.org/themes/jasper/images/tools/logo.gif Sat, 11 Feb 2012 15:11:48 +0000 <![CDATA[Error compiling report design :inconvertible types]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94913 Sat, 11 Feb 2012 09:11:48 +0000 Hi

 

I got this jasper project which used to compile and what not. Then i had to switch my pc and workspace and started to have tons of issues.

 

I started to get an error when tried to compile the reports saying language = null expecting java. but when in iReport I would chose other language for the report in xml it would show up in the xml but if i switch the language to java it would remove it from its xml header. then I manually typed in language="java" where it was showing up for the other language and started to get the bellow errors.

 

 [jrc] File : C:Dataworkspacegateway-jasper-reportsreportssplgatewayecommercestate-detail-xls.jrxml ... FAILED.
      [jrc] Error compiling report design : C:Dataworkspacegateway-jasper-reportsreportssplgatewayecommercestate-detail-xls.jrxml
      [jrc] net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:
      [jrc] C:Dataworkspacegateway-jasper-reportsstate45detail45xls_1326810975718_28406.java:1516: inconvertible types
      [jrc] found   : java.math.BigDecimal
      [jrc] required: java.lang.String
      [jrc]                 value = (java.lang.String)(((java.math.BigDecimal)field_AMOUNT.getValue()));//$JR_EXPR_ID=252$
      [jrc]                                           ^
      [jrc] C:Dataworkspacegateway-jasper-reportsstate45detail45xls_1326810975718_28406.java:1526: inconvertible types
      [jrc] found   : java.math.BigDecimal
      [jrc] required: java.lang.String
      [jrc]                 value = (java.lang.String)(((java.math.BigDecimal)field_AMOUNT.getValue()));//$JR_EXPR_ID=254$
      [jrc]                                           ^
      [jrc] C:Dataworkspacegateway-jasper-reportsstate45detail45xls_1326810975718_28406.java:1536: inconvertible types
      [jrc] found   : java.math.BigDecimal
      [jrc] required: java.lang.String
      [jrc]                 value = (java.lang.String)(((java.math.BigDecimal)field_AMOUNT.getValue()));//$JR_EXPR_ID=256$
      [jrc]                                           ^
      [jrc] C:Dataworkspacegateway-jasper-reportsstate45detail45xls_1326810975718_28406.java:1546: inconvertible types
      [jrc] found   : java.math.BigDecimal
      [jrc] required: java.lang.String
      [jrc]                 value = (java.lang.String)(((java.math.BigDecimal)field_AMOUNT.getValue()));//$JR_EXPR_ID=258$
      [jrc]                                           ^
      [jrc] C:Dataworkspacegateway-jasper-reportsstate45detail45xls_1326810975718_28406.java:1556: inconvertible types
      [jrc] found   : java.math.BigDecimal
      [jrc] required: java.lang.String
      [jrc]                 value = (java.lang.String)(((java.math.BigDecimal)field_AMOUNT.getValue()));//$JR_EXPR_ID=260$
      [jrc]                                           ^
      [jrc] C:Dataworkspacegateway-jasper-reportsstate45detail45xls_1326810975718_28406.java:1566: inconvertible types
      [jrc] found   : java.math.BigDecimal
      [jrc] required: java.lang.String
      [jrc]                 value = (java.lang.String)(((java.math.BigDecimal)field_AMOUNT.getValue()));//$JR_EXPR_ID=262$
      [jrc]                                           ^

 

Now this same report was compiling before and i didn't made any changes on them (other than typing the language thing).

 

Can some one help me to figure out what I need to do here so that the compiler understands the java code?

 


]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94913 <![CDATA[An error has occurred. (6632) - SQL validation of stored procedure in 4.5 breaks all report queries?]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94923 Sat, 11 Feb 2012 09:11:48 +0000 Hey

I think I can interpret the problem but not sure where to start for a solution.

The problem is for all reports having upgrade from 4.2.1 to 4.5.0. The UI says "An error has occurred. Please contact your system administrator. (6632)" and the stack trace is below.

Key cause appears to be:

 

Caused by: org.owasp.esapi.errors.ValidationException: SQL_Query_Executor_context: Invalid input. Please conform to regex ^s*((?i)select)s+[^;]+$ with a maximum length of 50000

Because all my queries are in the form

CALL Up_Reporting_GetSomethingUseful($P{StartDate}, $P{EndDate});

 

So I think I need to disable org.owasp.esapi query validation but I cannot find any documentation about this sort of configuration. Where do I start?

Code:
2012-01-18 15:50:03,354 ERROR ManagementServiceImpl,http-9123-3:1259 - caught Throwable exception: An error has occurred. Please contact your system administr
ator. (6632)
com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632)
        at com.jaspersoft.jasperserver.api.security.validators.ValidatorImpl.validateSQL(ValidatorImpl.java:394)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:166)
        at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:731)
        at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:629)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1159)
        at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:802)
        at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:118)
        at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:773)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:731)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:389)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReport(EngineServiceImpl.java:890)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:57)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:320)
        at com.jaspersoft.jasperserver.ws.axis2.ManagementServiceImpl.runReport(ManagementServiceImpl.java:1167)
        at com.jaspersoft.jasperserver.ws.axis2.ManagementService.runReport(ManagementService.java:240)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)
        at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
        at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
        at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
        at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
        at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
        at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
        at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:453)
        at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
        at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)
        at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
        at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
        at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
        at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
        at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.j
ava:139)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
        at com.jaspersoft.jasperserver.api.metadata.user.service.impl.PasswordExpirationProcessingFilter.doFilter(PasswordExpirationProcessingFilter.java:85)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
        at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
        at com.jaspersoft.jasperserver.api.metadata.user.service.impl.JIPortletAuthenticationProcessingFilter.doFilter(JIPortletAuthenticationProcessingFilter
.java:81)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
        at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
        at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)
        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)
        at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188)
        at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
        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:191)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
        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:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
        at java.lang.Thread.run(Thread.java:636)
Caused by: org.owasp.esapi.errors.ValidationException: SQL_Query_Executor_context: Invalid input. Please conform to regex ^s*((?i)select)s+[^;]+$ with a max
imum length of 50000
        at org.owasp.esapi.reference.validation.StringValidationRule.checkWhitelist(StringValidationRule.java:144)
        at org.owasp.esapi.reference.validation.StringValidationRule.checkWhitelist(StringValidationRule.java:160)
        at org.owasp.esapi.reference.validation.StringValidationRule.getValid(StringValidationRule.java:284)
        at org.owasp.esapi.reference.DefaultValidator.getValidInput(DefaultValidator.java:213)
        at org.owasp.esapi.reference.DefaultValidator.getValidInput(DefaultValidator.java:185)
        at com.jaspersoft.jasperserver.api.security.validators.ValidatorImpl.validateSQL(ValidatorImpl.java:388)
        ... 77 more
com.jaspersoft.jasperserver.api.JSSecurityException: An error has occurred. Please contact your system administrator. (6632)
]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94923 <![CDATA[Display everything on the page.]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94973 Sat, 11 Feb 2012 09:11:48 +0000 Hi,

I have one question.

How to display all reports on the page.
Jaspersoft generate the report with pagination. I would like using the mouse scroll the page of the report. And do not click on every page.

 

 

]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94973 <![CDATA[JasperReports including blank page at the end of the PDF]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=95159 Sat, 11 Feb 2012 09:11:48 +0000 Hello!

 I'm generating a PDF using JasperReports from Java. I finally succeeded in making Jasper correctly paginate the report. The problem is that now I'm getting a blank page at the end of the report (the headers are printed, but the detail band is blank). The information passed for the detail band is all displayed, so there is no need for that page (what is more, there is an empty space at the end of the last page). I will attach the JXML at the end of the question, any help appreciated.

Thanks!

 

Code:
REPORT:

 
http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="tintoreria" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true">
    
    
    
    
        
    
    
    
    
    
    
    
    
    
    
        
    
    
        
            
                
                
                    
                
            
            
                
                
                    
                
                
            
            
                
                
                    
                
                
            
            
                
                
                    
                
                
            
            
                
                
                    
                
                
            
            
                
                
                    
                
                
            
            
                
                
                    
                
                
            
            
                
                
                    
                
                
            
        
    
    
        
            
                
                
                
            
        
    
    
        
            
                
                
                    
                
            
            
                
                
                    
                
                
            
            
                
                
                
            
            
                
                
                
            
        
    


SUBREPORT:


http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="tintoreria_subreport1" pageWidth="540" pageHeight="600" whenNoDataType="NoDataSection" columnWidth="540" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isFloatColumnFooter="true" whenResourceMissingType="Empty">
]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=95159 <![CDATA[Error by filling a report with a htmlcomponent hc:html]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94862 Sat, 11 Feb 2012 09:11:48 +0000 Hello,

I'm getting an error by fillling (JasperFillManager.fillReport(jasperInputStream, parameters, connection);  )my report with html content. Had someone an idea to solve this?
I'm using jasperreports-4.1.1  with the jasperreports-htmlcomponent-4.1.1.jar extension.

Best regards
Daniel

.....
 
    
    http://jasperreports.sourceforge.net/htmlcomponent" xsi:schemaLocation="http://jasperreports.sourceforge.net/htmlcomponent http://jasperreports.sourceforge.net/xsd/htmlcomponent.xsd" scaleType="RetainShape" horizontalAlign="Center" verticalAlign="Middle">
     
    
   
.....

 

net.sf.jasperreports.engine.JRRuntimeException: No components bundle registered for namespace http://jasperreports.sourceforge.net/htmlcomponent
 at net.sf.jasperreports.engine.component.ComponentsEnvironment.getComponentsBundle(ComponentsEnvironment.java:120)
 at net.sf.jasperreports.engine.component.ComponentsEnvironment.getComponentManager(ComponentsEnvironment.java:138)
 at net.sf.jasperreports.engine.fill.JRFillComponentElement.(JRFillComponentElement.java:65)
 at net.sf.jasperreports.engine.fill.JRFillObjectFactory.visitComponentElement(JRFillObjectFactory.java:1592)
 at net.sf.jasperreports.engine.base.JRBaseComponentElement.visit(JRBaseComponentElement.java:80)
 

]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94862 <![CDATA[Jasper Reports Very Slow In Internet Explorer]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94884 Sat, 11 Feb 2012 09:11:48 +0000 I have several Jasper reports that run blindingly fast in Eclipse, and just about that fast in Firefox, but when I run them in IE (which almost all of my users use; sigh) they run very slowly.  A report that takes one or two seconds in Eclipse, and 2 or 3 seconds in Firefox, takes easily 20 seconds in IE.  It varies a bit from computer to computer (some are better than others, maybe 5-10 seconds).

 
Any ideas what could be causing this, or how to remedy it?
 
I have narrowed down the place in the code where the delay occurs and it is definitely in this function call:
 
JasperCompileManager.compileReport
 
which of course is compiled code that can't be diagnosed further.
 
Please help if you can!  Much thanks.
 
Darel
]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94884 <![CDATA[Lines are mirrored which have line direction 'Buttom Up (/)']]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94907 Sat, 11 Feb 2012 09:11:48 +0000 Hi, 

I created a report with iReport 4.5.0 including two lines which have definded a different line direction (see attachment left side).

After compiling and printing the report the second line (line direction 'Buttom Up') is mirrored (see attachment right side).

I use jasperreport 4.5.0 and I don't have this problem with earlier versions.

Has anyone the same problem as me? Any ideas?

Thanks,

Matze

 

]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=94907 <![CDATA[Loading byte array from database and displaying it as image!!]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=95013 Sat, 11 Feb 2012 09:11:48 +0000  Hi all,

               I wish to display images on my report. These are stored in SQL server as varbinary fields. Can anyone here please tell me the procedure of how to display images (in byte[]).

I did exactly what is mentioned in

http://rgauss.com/category/interface/---getting no such method exception...

and  http://vmustafayev4en.blogspot.com/2011/08/read-alfresco-node-to-byte-array-in.html-- here I am getting java.lang.ArrayIndexOutOfBoundsException: -77.

 

Thanks,

Vivekanand Alampally.

 

 

]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=95013 <![CDATA[Export Jasper to image]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=95086 Sat, 11 Feb 2012 09:11:48 +0000 Hi,

Is it posible to export a jasper object to an image (bmp, jpg...)?. Until now I've been able to export it to different formats (pdf, xls, doc...) but finding in Google about an image exporter didn't get any succesfull result. Does anybody know how could I do it?

Thanks in advance.

Regards.

]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=95086 <![CDATA[Java Reports. Shrink the font size of the texfield. ]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=95150 Sat, 11 Feb 2012 09:11:48 +0000 Hello,

I am working with Jasper Reports. I want User Comments to come it to report.

Problem is if the Comments are bigger then it take more vertical space. But I want that its font size should reduce to fit into that area.

I hope you understand

Please reply

Thanks

Venkat

]]> http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=95150