Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: list parameter jasperreports

  1. #1
    Join Date
    Oct 2006
    Posts
    4

    Default list parameter jasperreports

    Hello Everyone,

    I am trying to pass list of strings using pentaho SecurePrompFilter to jasperreports parameterized query. I am getting following error . I had the same error when i tried passing an integer too. It works fine if use string as the input parameter.

    I have posted a similar error and i have not received and replies. Any help is greatly appreciated
    Attaching a zip file of .xaction, .jrxml, .properties


    net.sf.jasperreports.engine.JRException: Incompatible java.lang.String value assigned to parameter values in the MultiplePartRequ
    at net.sf.jasperreports.engine.fill.JRFillDataset.setParameter(JRFillDataset.java:782)
    at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(JRFillDataset.java:607)
    at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:563)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:878)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:689)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:647)
    at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
    at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234)
    at org.pentaho.plugin.jasperreports.JasperReportsComponent.executeAction(JasperReportsComponent.java:491)
    at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:421)
    at org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeContext.java:989)
    at org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.java:961)
    at org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext.java:877)
    at org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.java:833)
    at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:739)
    at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:655)
    at org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngine.java:265)
    at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:209)
    at org.pentaho.core.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:140)
    at org.pentaho.ui.servlet.ViewAction.doGet(ViewAction.java:153)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    at java.lang.Thread.run(Thread.java:534) http://forums.pentaho.org/archived_a...mscreports.zip

  2. #2

    Default

    I have the same problem... someone that can help us? thanks

  3. #3

    Default

    Hello !

    You tried to pass a "list" as a parameter to the report. I believe, but I'm not sure, that it is a javascript list in the Xaction mecanism not a java.lang.List, this is why you got a message about String.

    Please try to send get a List with your jasperreport and split it on comma.

    Regards,

    Cedric
    Cedric CLAIDIERE
    Aprolis
    www.aprolis.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.