simonabertozzi

Sorry to post in an old discussion, but my problem is pretty similar... Following the instructions above, my users are now able to create a new domain (with the new role ROLE_DOMAIN), however when they want to edit it, they can't: even giving "administrator" permission on the folder, the only options that seem available are copy, paste and delete. Is there something else we need to do? Thank you, Simona

Hi all, I have embedded a report from Jasperserver in a iframe, and I have published it on my site using anonymous authentication. The problem is, when I want to export in pdf the report, Jasperserver tries to open a new browser window and then launches the error "Access Denied" (because anonymous users can't access directly my Jasperserver). This doesn't happen with the other exporter formats, since I get the popup window asking me if I want to open or save my file on my pc. How can I disable the view in browser for the pdf exporter, too? I already tried to work with browser options (by disabling adobe plugins and setting to "always ask" Adobe Acrobat Documents content in Firefox) but it doesn't seem to work. Why is that? Best regards, Simona

Hello everyone, I'm trying to limit the list of possible exporters available to an anonymous user (which accesses a list of reports published on my Jasperserver). I found that tinkering with the code on "DefaultJasperserverViewerState.jsp" and using the variable exporterKey, I am able to filter the list for every user on Jasperserver. My question is: since I identify the anonymous accesses because the always use link with "decorate=no" parameter, is there a way to retrieve this parameter from inside "DefaultJasperserverViewerState.jsp"? I already tried String decorateParam = (String) request.getParameter("decorate") but it doesn't seem to work. Thank you all, Simona

I finally managed to solve it. The error I got was in the GROUP BY clause: if I write the query like this SELECT CASE WHEN ($P{period} = 'MONTH') THEN "MONTH" WHEN ($P{period} = 'QUARTER') THEN "QUARTER" WHEN ($P{period} = 'YEAR') THEN "YEAR" END AS PERIOD, SUM("QTY_GOOD") AS TEU, SUM("QTY_TON_GOOD") AS TON FROM "APV_DM"."APV_F_GOODS" A INNER JOIN "APV_DM". "APV_L_GOODS" B ON (A."IDS_GOOD" = B."IDS_GOOD") INNER JOIN "APV_DM"."APV_L_TIME" C ON (A."IDS_TIME_START_OP" = C."IDS_DAY_TIME") GROUP BY PERIOD ORDER BY PERIOD using the renaming, everything works! It still seems a bit strange to me as to why this error shows up at all (if the renaming works, why can't I specify the whole CASE WHEN clause?), but thank you everyone who tried to help. Best regards, Simona

Hi Ajinkya, it seems it's not possible to use variables in query: I get a syntax error at or near "$" SELECT $V{variable1} AS PERIOD, SUM("QTY_GOOD") AS TEU, SUM("QTY_TON_GOOD") AS TON FROM "APV_DM"."APV_F_GOODS" A INNER JOIN "APV_DM". "APV_L_GOODS" B ON (A."IDS_GOOD" = B."IDS_GOOD") INNER JOIN "APV_DM"."APV_L_TIME" C ON (A."IDS_TIME_START_OP" = C."IDS_DAY_TIME") GROUP BY $V{variable1} ORDER BY PERIOD Thanks, Simona

Hello, I was wondering if it's possible using iReport parameters in a GROUP BY clause? I need to do something like this: SELECT CASE WHEN ($P{period} = 'MONTH') THEN "MONTH" WHEN ($P{period} = 'QUARTER') THEN "QUARTER" WHEN ($P{period} = 'YEAR') THEN "YEAR" END AS PERIOD, SUM("QTY_GOOD") AS TEU, SUM("QTY_TON_GOOD") AS TON FROM "APV_DM"."APV_F_GOODS" A INNER JOIN "APV_DM". "APV_L_GOODS" B ON (A."IDS_GOOD" = B."IDS_GOOD") INNER JOIN "APV_DM"."APV_L_TIME" C ON (A."IDS_TIME_START_OP" = C."IDS_DAY_TIME") GROUP BY CASE WHEN ($P{period} = 'MONTH') THEN "MONTH" WHEN ($P{period} = 'QUARTER') THEN "QUARTER" WHEN ($P{period} = 'YEAR') THEN "YEAR" END ORDER BY PERIOD But I keep getting the error: "MONTH" must appear in the GROUP BY clause or be used in an aggregate function If I remove che CASE WHEN everything works. Best regards, Simona

It works! Thank you very much.

Hi all, I've created a subreport that calls another subreport (creating a sort of three-level hierarchy). In iReport everything works fine. Now I want to deploy these 3 reports on Jasperserver, but I'm facing a problem: if I deploy the master report, Jasperserver recognizes and uploads only the first subreport. What is the right way to do a deploy in this case? Thanks, Simona

Changed Assigned User from @User_306070 to @anonymous Yes, it works. Thank you! I come from iReport, where this issue was really an inconvenience

After a bit of work I managed to solve my problem, so I'm posting it here for future reference. I simply needed to add the following NetBeans jars (I found them on my ireport installation) in this order: - boot.jar - org-openide-filesystems.jar - core.jar And the error disappeard! Best regards, Simona

Hello, I managed to successfully set up a web service that calls, executes and exports reports with parameters in pdf. However, I always get this warning: org.openide.util.NbPreferences getPreferencesProviderWARNING: NetBeans implementation of Preferences not found: java.lang.Exceptionat org.openide.util.NbPreferences.getPreferencesProvider(NbPreferences.java:110)at org.openide.util.NbPreferences.forModule(NbPreferences.java:75)at com.jaspersoft.ireport.designer.IReportManager.getPreferences(IReportManager.java:1267)at com.jaspersoft.ireport.jasperserver.ws.WSClient.getManagementService(WSClient.java:649)at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:399) It's a simple warning so the web service actually works, but I was wondering how can I remove it? Is it maybe some jar library I'm missing? Here is my list of current import: com-jaspersoft-ireport-jasperserver.jar js_activation-1.1.jar js_axis-1.4patched.jar commons-logging-1.1.jar js_commons-codec-1.3.jar js_commons-discovery-0.2.jar js_commons-httpclient-3.1.jar js_jasperserver-common-ws-4.7.1.ja js_jaxrpc.jar js_mail-1.4.jar js_saaj-api-1.3.jar js_wsdl4j-1.5.1.jar jasperreports-5.0.0.jar com-jaspersoft-ireport.jar org-openide-modules.jar org-openide-util.jar log4j-1.2.15.jar xercesImpl-2.9.0.jar jasperreports-fonts-5.0.0.jar Any help would be greatly appreciated! Best regards, Simona

Thank you for sharing the code... I had the same problem and didn't think about this simple solution!

If you have already implemented drill-down in reports, then you have already done it; just add the master report in a dashboard, and you'll be able to drill to the detail one. Dashboard in JasperReports Server are report containers, they don't add functionality to the single reports. Best regards, Simona

Unfortunately I think both options are available only in the commercial edition of JasperReports Server. Best regards, Simona

Hi all, I am experiencing some problems when trying to use a .accdb file as a datasource to a report. What I did was to create a new System DSN on my local machine (I am running win 7 professional) specifying as a driver "Microsoft Access Driver (*.mdb, *.accdb)", and then I created a new connection on iReport using the JDBC-ODBC Bridge. On iReport everything works fine, and i am able to see a preview of my report. But when I upload the same report on JasperServer I get the following error: java.lang.NullPointerException at org.apache.catalina.loader.WebappClassLoader.findResources(WebappClassLoader.java:1150) at java.lang.ClassLoader.getResources(ClassLoader.java:1041) at org.springframework.core.io.support.PropertiesLoaderUtils.loadAllProperties(PropertiesLoaderUtils.java:103) at org.springframework.beans.factory.xml.PluggableSchemaResolver.getSchemaMapping(PluggableSchemaResolver.java:128) at org.springframework.beans.factory.xml.PluggableSchemaResolver.resolveEntity(PluggableSchemaResolver.java:107) at org.springframework.beans.factory.xml.DelegatingEntityResolver.resolveEntity(DelegatingEntityResolver.java:85) at org.springframework.beans.factory.xml.ResourceEntityResolver.resolveEntity(ResourceEntityResolver.java:73) at org.apache.xerces.util.EntityResolverWrapper.resolveEntity(Unknown Source) at org.apache.xerces.impl.XMLEntityManager.resolveEntity(Unknown Source) at org.apache.xerces.impl.xs.XMLSchemaLoader.resolveDocument(Unknown Source) at org.apache.xerces.impl.xs.XMLSchemaValidator.findSchemaGrammar(Unknown Source) at org.apache.xerces.impl.xs.XMLSchemaValidator.handleStartElement(Unknown Source) at org.apache.xerces.impl.xs.XMLSchemaValidator.startElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl$NSContentDispatcher.scanRootElementHook(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.DOMParser.parse(Unknown Source) at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source) at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:75) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:396) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:342) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:310) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:143) at org.springframework.webflow.engine.builder.model.FlowModelFlowBuilder.createFlowApplicationContext(FlowModelFlowBuilder.java:348) at org.springframework.webflow.engine.builder.model.FlowModelFlowBuilder.initLocalFlowContext(FlowModelFlowBuilder.java:303) at org.springframework.webflow.engine.builder.model.FlowModelFlowBuilder.doInit(FlowModelFlowBuilder.java:148) at org.springframework.webflow.engine.builder.support.AbstractFlowBuilder.init(AbstractFlowBuilder.java:46) at org.springframework.webflow.engine.builder.FlowAssembler.assembleFlow(FlowAssembler.java:90) at org.springframework.webflow.engine.builder.DefaultFlowHolder.assembleFlow(DefaultFlowHolder.java:109) at org.springframework.webflow.engine.builder.DefaultFlowHolder.getFlowDefinition(DefaultFlowHolder.java:84) at org.springframework.webflow.definition.registry.FlowDefinitionRegistryImpl.getFlowDefinition(FlowDefinitionRegistryImpl.java:61) at org.springframework.webflow.executor.FlowExecutorImpl.launchExecution(FlowExecutorImpl.java:138) at sun.reflect.GeneratedMethodAccessor282.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 $Proxy40.launchExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:193) 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:394) 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:406) 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:406) 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:406) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:110) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:96) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) 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:406) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:184) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:406) 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:406) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:185) 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:558) 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.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619) It doesn't matter whether I import the connection from iReport or I create a new one on the server, the result is the same. I also tried the option "Run JasperServer report" from iReport, and the stacktrace was: 1 - com/jaspersoft/jasperserver/api/metadata/xml/domain/impl/Argument java.lang.Exception: 1 - com/jaspersoft/jasperserver/api/metadata/xml/domain/impl/Argument at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Can anyone help me? What am I doing wrong? Best regards, Simona Post Edited by simonabertozzi at 02/07/2012 15:53 Post Edited by simonabertozzi at 02/07/2012 16:00