jsturla

Hi I need to display two lists of values (from queries) to colect the parameters of a report. The values displayed in de second list depends on the value selected in the first one. Can I do it in JasperServer ? Example: List one, countries (Japan, Brasil, USA...) List two, cities of the selected country in list one. Tanks in advance J.

I had a set of label reports published in JasperServer. The users login JasperServer and pickup the report they need. The These reports should be sent directily to the printer after the user enter the parameters, without the need of see them on the browser to be able to print. Can I control the output of a report via a parameter or some thing like that if the report is consumed in the JasperServer Web application ? Tanks

Ok, published (Artifact artf3194) Tanks again!!

The files... [file name=jasper-16ccf3aefd080ddf5606e645f725ae57.zip size=1960]

I have tried combinations of references to "repo" resources and some works fine. The combination that is not working for me is when the "linked" resources (templates) are both defined as resources in the report unit. For the 3 files that I am attaching I defined the folowing in JasperServer: A report unit named test created uploading the file test.jrxml (attached). This report unit has 2 resources defined: 1) "estilos" a resource type style template that was created uploading the file estilo.jrtx (attached) 2) "estilos_basicos" a resource type style template that was created uploading the file estilos_basicos.jrtx As you can see in the file estilos.jrtx there are a reference to estilos_basicos resource (<template><![CDATA[repo:estilos_basicos]]></template>) in the repository of Jasperserver When I try to run the report unit test I get the folowing error: net.sf.jasperreports.engine.JRRuntimeException: Circular dependency found for template at location repo:estilos_basicos Tanks for your time Jony Post edited by: jsturla, at: 2008/04/25 15:57

Hi, I am trying to use a jasper template of styles (jrtx) file that uses anoteh jrtx file (<template><![CDATA[ttt...ttt]]></template>). The idea is that the report (jrxml) and both template files are saved in the jasperserver repository. I have a report that references a template file and that template file references other template file. Something like this: rpt->template A->template B In the repository of jasperserver I have a resource at root level named "estilos_basicos" that corresponds to template B. In the report unit published in the jasperserver I have a resource named "estilos" that corresponds to template A in the above example. In the report (jrxml) I have a tag: <template><![CDATA["repo:estilos"]]></template>, again template A in the above example. In the template file identified as "estilos" resource in the report unit there are a tag: <template><![CDATA[repo:/estilos_basicos]]></template>. That is, a reference to the template B in the above example. All this gives me the error: net.sf.jasperreports.engine.JRRuntimeException: Circular dependency found for template at location repo:/estilos_basicos... Any sugestion ? Tanks

Hi, I am trying to use a jasper template of styles (jrtx) file that uses anoteh jrtx file (ttt...ttt). The idea is that the report (jrxml) and both template files are saved in the jasperserver repository. I have a report that references a template file and that template file references other template file. Something like this: rpt->template A->template B In the repository of jasperserver I have a resource at root level named "estilos_basicos" that corresponds to template B. In the report unit published in the jasperserver I have a resource named "estilos" that corresponds to template A in the above example. In the report (jrxml) I have a tag: "repo:estilos", again template A in the above example. In the template file identified as "estilos" resource in the report unit there are a tag: repo:/estilos_basicos. That is, a reference to the template B in the above example. All this gives me the error: net.sf.jasperreports.engine.JRRuntimeException: Circular dependency found for template at location repo:/estilos_basicos... Any sugestion ? Tanks

Hi, in my organization we are developping reports in iReport 2.0.4 and have many styles defined in a jaspertemplate file (.jrtx) that uses border properties. After installing the 2.0.5 version of iReport the borders not work as expected. Someone can give me some help on what are the changes about stiles and borders and how they work in iReport/jeasperReports 2.0.5 ? Tanks

The URI is: http://192.168.164.91:8080/jasperserver/xmla. I had changed localhost by my jboss server's IP address. the other relevant parameters of the xmla client connection are: catalog: Foodmart data source: Provider=Mondrian;DataSource=Foodmart; The other samples, that are based on Mondrian client connections, worked after I changed the reference to a JNDI data source by a JDBC datasource reference. Any sugestion ?

The URI is: http://192.168.164.91:8080/jasperserver/xmla. I had changed localhost by my jboss server's IP address. the other relevant parameters of the xmla client connection are: catalog: Foodmart data source: Provider=Mondrian;DataSource=Foodmart; The other samples, that are based on Mondrian client connections, worked after I changed the reference to a JNDI data source by a JDBC datasource reference. Any sugestion ?

I am having problem to use xmla connections in jasperserver 2.0.1 that is running in jboss 4.2.1 GA I try to open the sample analysis view SugarCRM_xmla_sample and got the error below I tried the same in the boundled instalation (with Tomcat) and it works fine. Some idea ? Tanks ... 15:21:33,566 ERROR JSErrorPage_jsp,http-127.0.0.1-8080-1:326 - javax.xml.soap.SOAPException: Unable to create message factory for SOAP: org.jboss.ws.core.soap.MessageFactoryImpl at javax.xml.soap.MessageFactory.newInstance(MessageFactory.java:119) at com.tonbeller.jpivot.xmla.XMLA_SOAP.init(XMLA_SOAP.java:139) at com.tonbeller.jpivot.xmla.XMLA_SOAP.<init>(XMLA_SOAP.java:110) at com.tonbeller.jpivot.xmla.XMLA_Model.initialize(XMLA_Model.java:147) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.PageStateManager.initializeAndShow(PageStateManager.java:42) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:179) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.initializeAndShow(OlapConnectionServiceImpl.java:335) at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:396) at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:178) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:434) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:372) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:140) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:267) 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.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)

I am having problem to use xmla connections in jasperserver 2.0.1 that is running in jboss 4.2.1 GA I try to open the sample analysis view SugarCRM_xmla_sample and got the error below I tried the same in the boundled instalation (with Tomcat) and it works fine. Some idea ? Tanks ... 15:21:33,566 ERROR JSErrorPage_jsp,http-127.0.0.1-8080-1:326 - javax.xml.soap.SOAPException: Unable to create message factory for SOAP: org.jboss.ws.core.soap.MessageFactoryImpl at javax.xml.soap.MessageFactory.newInstance(MessageFactory.java:119) at com.tonbeller.jpivot.xmla.XMLA_SOAP.init(XMLA_SOAP.java:139) at com.tonbeller.jpivot.xmla.XMLA_SOAP.<init>(XMLA_SOAP.java:110) at com.tonbeller.jpivot.xmla.XMLA_Model.initialize(XMLA_Model.java:147) at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:132) at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:77) at com.tonbeller.jpivot.tags.PageStateManager.initializeAndShow(PageStateManager.java:42) at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:179) at com.jaspersoft.jasperserver.api.metadata.olap.service.impl.OlapConnectionServiceImpl.initializeAndShow(OlapConnectionServiceImpl.java:335) at com.jaspersoft.jasperserver.war.control.OlapModelController.getOlapSession(OlapModelController.java:396) at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:178) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:434) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:372) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:140) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:267) 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.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:136) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:131) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) 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:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 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:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) Post edited by: jsturla, at: 2007/09/04 20:19

I found the solution to my problem changing the oracle jdbc drivers by a new version the one in ojdbc14.jar (http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html)

Any new about this ? I am having the same error message

Any new about this ? I am having the same error message