migunov

Reinstall of the Tomcat doesn't help me. Try to find another way. Who knows, maybe it is a conflict with libraries or something else?

I think, it's might be a problem with tomcat 6. I use such conditions to create report on local, without tomcat and it works. Then I deploy my application to GlassFish Server and it works too. Will investigate the problem. Maybe try to reinstall tomcat to new tomcat7.

I have created a HashMap with parameter PARAM, in which I have putted a List wish HashMaps whic I created after some SQL requests. The HashMap is: [{}, {REGUL_DOCUMENT_NUMBER=3213245, BRANCH_NAME=??????????? ????????, DOCUMENT_ISSUER_POSITION=jkdlkhflkjdshf, BRANCH_TELEPHONE_NUMBER=(), REGUL_DOCUMENT_DATE=1111111, BRANCH_ADDRESS=?.???????????????, DOCUMENT_ISSUER=, DOCUMENT_ISSUER_POSITION_R=, DOCUMENT_ISSUER_R=}] If I insert in report $P{PARAMS}.get(1) it write the full HashMap in report without an errors: {REGUL_DOCUMENT_NUMBER=3213245, BRANCH_NAME=??????????? ????????, DOCUMENT_ISSUER_POSITION=jkdlkhflkjdshf, BRANCH_TELEPHONE_NUMBER=(), REGUL_DOCUMENT_DATE=1111111, BRANCH_ADDRESS=?.???????????????, DOCUMENT_ISSUER=, DOCUMENT_ISSUER_POSITION_R=, DOCUMENT_ISSUER_R=} When I try to take a parameter in report it fails. $P{PARAMS}.get(1).get("REGUL_DOCUMENT_NUMBER") The Error is: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. The method containsParameter(String) is undefined for the type Object value = ""+((java.util.List)parameter_PARAMS.getValue()).get(1).containsParameter("REGUL_DOCUMENT_NUMBER"); //$JR_EXPR_ID=9$ <---------------> 2. The method containsParameter(String) is undefined for the type Object value = ""+((java.util.List)parameter_PARAMS.getValue()).get(1).containsParameter("REGUL_DOCUMENT_NUMBER"); //$JR_EXPR_ID=9$ <---------------> 3. The method containsParameter(String) is undefined for the type Object value = ""+((java.util.List)parameter_PARAMS.getValue()).get(1).containsParameter("REGUL_DOCUMENT_NUMBER"); //$JR_EXPR_ID=9$ <---------------> 3 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:204) at net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:240) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:496) at net.sf.jasperreports.engine.JasperCompileManager.compile(JasperCompileManager.java:173) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:454) at com.equation.report.server.servlets.GetReport.processRequest(GetReport.java:131) at com.equation.report.server.servlets.GetReport.doGet(GetReport.java:213) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) 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.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) 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:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Unknown Source) Can You help me, how I can to use a HashMap parameters. Thank You

I found a way: I create a some sql requests on server, collect to datasources and pass it like a parameters to my report. Thank You all!

Hello, everyone! Please, help with my issue: I need to create a selection with more than one SQL to create the report. In menu "Report Query" I can insert only one SQL. I have tried to insert a second SQL in XML file of report, but it appears to an error. Maybe it is possible to fill the report with JasperFillReport, but how I can create a DataSource with data from different selections? Do you know, what way to insert a more than one SQL statement in report, or it's not possible? thanks.

Thank You wery much! It Works!

I need to add a different driver for access to a AS400 DataBase. I have added a JAR in tools->Options->ClassPath But it didn't appears in drivers List. I try to create in Connections/Datasource the new JDBC Database Connection DataSource. Can You Describe, how I can if it possible to add the new Connection Driver to List? Thanks.