dolm

I've seens ome issues with this error from back i the 3.x versions of iReport. I'm using iReport 4.7.0, Jasperserver Product Version: 4.0.0 Build: 20110202_0654. When I try to publish a report created in iReport 4.0.0, i get this error: Error: ; nested exception is: org.xml.sax.SAXException: Bad envelope tag: html Anyone know what's causing this and how to resolve it? My respository is correct with http://localhost:8080/jasperserver/services/repository

Is it possible to suppply a query to jasper and retrieve an answer set via the webservice? If so is there any examples of this? I have a sharepoint that has no DSN to the data warehouse available, only SOAP/XML. We need to query for data from forms in real-time and the Jasperserver jdbc connection would be a fantastic solution. Is this possible?

I ran into a similar issue trying to supply a standard ISO date to Teradata using the java.util.date parameter. I needed to supply starting and ending date in format as '2012-09-01' but it kept passing the longer format and resulting in errors. The solution was to format the date in the where clause. In my case: SELECT * FROM VIEW.TAB WHERE Tab.Col = '$P{Start_Date}' (Date, Format 'yyyy-mm-dd')

Is the name of the parameter you created in iReport exactly the same as the ID of the control in the respository? I had this exact same problem starting out, and it was from using an underscore in the repo but not in the parameter name in iReport

Disregard, I got this woeking by just using the final parameter in my query, so the report is working... I'd still love to know whhy its failing when I try to use $X{param1,param2} with a collection type parameter

I'm trying to build a report with cascading paramters and my last parameter that would return a list of managers based on area-managers is causing some issues. I have a parameter Select_AD_Name_from_list which is populated on jasperserver by a query. This control is working fine in the report. The second parameter "Select_Manager" is causing issues. When I set it to a string, the dropdown is showing the correct names per the query (which uses $P{Select_AD_Name_from_list} as a filter in the query). The report will try to run if I set this parameter to string, but will fail in the query since it needs $X to populate. But if I set this parameter to a Collection and use the expression new ArrayList(Arrays.asList(new String[] {“a”})) It fails to compile with the error: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed: calculator_AD32Manager32Agent32Drill32Down_1307728316127_643967: 175: No expression for the array constructor call at line: 175 column: 76. File: calculator_AD32Manager32Agent32Drill32Down_1307728316127_643967 @ line 175, column 76. 1 error What am I doing wrong here?

I'm still struggling with this , is there anyone that can offer a suggestion?

Anyone able to offer any suggestions?

I've read through the forum posts I could find and followed posted instructions but I'm not able to get a hyperlinked field to work correctly. I have a dashboard that contains a subreport. in the subreport I've set a field $F{agent_id} as a hyperlink to point to another report that will serve as a drilldown. In the subreport I've added the parameter $P{AGENT_ID_PARAM}. My drill down report has a matching parameter. The drilldown works fine on its own, I can run it on the sever, it prompts for agent_id and runs fine. When I click the hyperlink in the subreport of the dashboard, I'm getting the below error. I've checked and double checked the repo: path to this drill down report and confirmed the XML shows it correctly. The xml in the subreport appears to be correct, showing the repo: path that the target report has when viewing the navigator. <detail> <band height="20" splitType="Stretch"> <textField hyperlinkType="ReportExecution"> <reportElement x="0" y="0" width="100" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{agent_id}]]></textFieldExpression> <hyperlinkParameter name="_report"> <hyperlinkParameterExpression><![CDATA["repo:/subreports/offenders_drill_down_files/offenders_drill_down_jrxml"]]></hyperlinkParameterExpression> </hyperlinkParameter> <hyperlinkParameter name="AGENT_ID_PARAM"> <hyperlinkParameterExpression><![CDATA[$P{AGENT_ID_PARAM}]]></hyperlinkParameterExpression> </hyperlinkParameter> </textField> <textField> The path from the Repository Navigator when viewing properties of the target report: /subreports/offenders_drill_down_files/offenders_drill_down_jrxml The xml from the target drill-down report appears to match: <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="Offenders Drill Down" language="groovy" pageWidth="2120" pageHeight="555" orientation="Landscape" columnWidth="2120" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="AGENT_ID_PARAM" class="java.lang.String"> <parameterDescription><![CDATA[Agent ID]]></parameterDescription> </parameter> <queryString> Any suggestions or ideas ? Post Edited by dolm at 06/07/2011 14:34 Code:The server has encountered an error. Please excuse the inconvenience. Error Messagejava.lang.IllegalArgumentException: No matching action map for resource class offenders_drill_down_jrxmlError Tracejava.lang.IllegalArgumentException: No matching action map for resource class offenders_drill_down_jrxml at com.jaspersoft.jasperserver.war.action.ResourceTypeMappingAction.doPreExecute(ResourceTypeMappingAction.java:51) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:186) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Flow.start(Flow.java:535) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:364) at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:234) at org.springframework.webflow.engine.SubflowState.doEnter(SubflowState.java:101) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:560) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:230) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:163) at sun.reflect.GeneratedMethodAccessor195.invoke(Unknown Source) 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:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy17.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) 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 com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) 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:390) 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:390) 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:390) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) 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:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) 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:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) 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:563) 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:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) About JasperReports Server Copyright © 2000-2011 Jaspersoft Corpora Post Edited by dolm at 06/07/2011 14:35

I ran the buildomatic script which after figuring out some of the correct setup worked ok, after running it a couple times. There was some issues with it failing on database creation..it would drop the db after prompting to do so, then build it, then fail saying it wasnt found. Ran the script again and it installed completely. No idea what was going on there. I used an existing MySQL5 installation, existing Tomcat6. Make sure you have updated your Ubuntu install (specificaly check that you have Ant 1.8.x) With iReport (4.0.2), my biggest issue is the fact you can't use it very well if you're not a coder/developer type. I'm no coder and don't plan to be. Why have a beautiful GUI and still require script/code and 4 hours of hammering to accomplish what I can do in Excel in 10 minutes? (Just my opinion, bear in mind I'm not a coder) Also, publishing to your Jasper instance is a serious pain when it comes to subreports. Working with them locally, the subreport dir path and path to each referenced subreport is entered as either a direct path, or relative with a parameter in the XML. No where could I find this documented, so I had to scour half-explained posts to figure out how to change the path info to get subreports to work on the server. That brings to point another issue with these forums. If you search for a phrase with more than a couple of words you'll get no results.

Sorry.. were running 10.0.4 64 bit.seemed stable enough but a data set of more than 75 rows or so will choke IE. We've since started testing Pentaho BI due to limitations with the iReport software and the messed up way subreports work.

This is still messed up. My bar chart is showing all centers, with 2 bars for each, showing valid and invalid, but it looks like all lines are scaled to the max value. For example, one center that only has a total of 4 rows in my query result is scaled showing 36 and 6 on the bars values. What gives?

I figured out my issue but now i need to figure out how to change the color of the bars..anyone know?

I figured out part of my problem, I changed Category to $F{DISPATCH_VALIDITY} == "Valid" And the value expression to $V{REPORT_COUNT} but this gives me two categories with multiple series of True / False Post Edited by dolm at 05/30/2011 14:00

I'm trying to build simple charts and I cant seem to get these expressions to work. My data has a field DISPATCH_VALIDITY that has a value of either Valid or Invalid. I need a bar chart that has each center name, with two series (total count) for "Valid" and "Invalid". My first series is --- Series expression: $F{AGENT_CENTER} Category expression: $F{AGENT_CENTER} Value expression: $F{DISPATCH_VALIDITY} == "Valid" This fails with the error: Error filling print... Error evaluating expression : Source text : $F{DISPATCH_VALIDITY} == "Valid" What am I doing wrong? Is there a tutorial somewhere to help with learning Groovy expressions?