Passing list of Parameters from java to iReport

[amatti]

Hi Everyone,

I am using Jasper along with the Spring (Java.).

I am trying to pass parameter in the form of list. I hav used $X{}. in the iReport tool.

My problem is,

When I select multiple locations from the front end. The parameter can be fetched & set as the parameter but while filling the report, its throwing me the error saying,

net.sf.jasperreports.engine.JRException: Error retrieving field value from bean : atPureWeightat net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:123)at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:96)at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:100)at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:895)at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:860)at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:837)at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1434)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:836)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:765)at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:84)at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624)at org.springframework.web.servlet.view.jasperreports.AbstractJasperReportsView.fillReport(AbstractJasperReportsView.java:669)at org.springframework.web.servlet.view.jasperreports.AbstractJasperReportsView.renderMergedOutputModel(AbstractJasperReportsView.java:559)at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:262)at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1157)at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:927)at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:594)at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1365)at com.tf.retail.catalog.core.filters.SecurityDeligatingFilter.doFilter(SecurityDeligatingFilter.java:72)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524)at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:233)at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1065)at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:412)at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:192)at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:999)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)at org.eclipse.jetty.server.Server.handle(Server.java:351)at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:454)at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:900)at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:954)at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:857)at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:76)at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:609)at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:45)at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:599)at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:534)at java.lang.Thread.run(Thread.java:619)Caused by: java.lang.NoSuchMethodException: Unknown property 'atPureWeight' on class 'class java.lang.Integer'at org.apache.commons.beanutils.PropertyUtilsBean.getSimpleProperty(PropertyUtilsBean.java:1322)at org.apache.commons.beanutils.PropertyUtilsBean.getNestedProperty(PropertyUtilsBean.java:770)at org.apache.commons.beanutils.PropertyUtilsBean.getProperty(PropertyUtilsBean.java:846)at org.apache.commons.beanutils.PropertyUtils.getProperty(PropertyUtils.java:426)at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getBeanProperty(JRAbstractBeanDataSource.java:111)at net.sf.jasperreports.engine.data.JRAbstractBeanDataSource.getFieldValue(JRAbstractBeanDataSource.java:96)at net.sf.jasperreports.engine.data.JRBeanCollectionDataSource.getFieldValue(JRBeanCollectionDataSource.java:100)at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:895)at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:860)at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:837)at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1434)at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:126)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:836)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:765)at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:84)at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:624)at org.springframework.web.servlet.view.jasperreports.AbstractJasperReportsView.fillReport(AbstractJasperReportsView.java:669)at org.springframework.web.servlet.view.jasperreports.AbstractJasperReportsView.renderMergedOutputModel(AbstractJasperReportsView.java:559)at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:262)at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1157)at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:927)at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827)at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:594)at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1365)at com.tf.retail.catalog.core.filters.SecurityDeligatingFilter.doFilter(SecurityDeligatingFilter.java:72)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:311)at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:101)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:323)at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:173)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:483)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524)at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:233)at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1065)at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:412)at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:192)at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:999)at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:250)at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111)at org.eclipse.jetty.server.Server.handle(Server.java:351)at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:454)at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:900)at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:954)at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:857)at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:76)at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:609)at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:45)at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:599)at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:534)at java.lang.Thread.run(Thread.java:619)[/code]

"atPureWeight" is one of the fields of my report & its datatype is java.lang.double. I cudn't figure out the cause plz help me in dis regard.  And I am able to set the parameter from the front end properly. My code is as below;

Connection connection = dataSource.getConnection(); parameterMap.put("REPORT_CONNECTION", connection);parameterMap.put("buId", bulist);[/code]

Plz help me its very much needed.

Any help is appreciable. 

Thank you.

[amatti]

I resolved the above issue.

Actually it was throwing error for the fields that were there in the MainReport. So I deleted the fields from the Main Report, & issue got resolved.

[amatti]

Hi all,

I got one more problem while generating report in the HTML format i.e., I am unable to display the image in the HTML format report.

But I am able to get the report generated along with the image both in PDF & Excel format.

Plz help me ion this Regard, I am workin on the Static Report.

Thank u