[SQL timeout configuration]

You could try to switch to a jndi datasource

[Vertical Line over section from detail band to page footer band]

Hi, did you try to reduce the band height ?

[iReport Query tool and DATEDIFF]

Hello,

Did you check the version of the jdbc driver ?

 

Regards

[jasperServer MySQL Connection failed]

Hi, did you check if the Mysql JDBC Driver is installed  ?

It isn't shipped anymore with JasperReportServer 4.2.1 and you need to get it from your own.

 

[JasperServer Role]

Hi,

 

You need to create a second role for all the other users, except the new one, and assign all the reports to this second role, and not to ROLE_USER

 

 

[problem with InputControls mandatory]

What I need is :

- All input-controls prompted

- None of the input-controls mandatory

But whatever I check or unckeck (even mandatory) , the DATE Input-controls are always mandatory and the user has no way to leave them blank.

Do you know a way to get around this ?

Thanks

[passing parameters to an Olap Analysis View]

Hi,

I'm using JasperServer CE 3.7.1

Is it possible to use a parameter when launching an analysis view ?

Thanks

[problem with InputControls mandatory]

Hi,

Thanks for your reply.

Yes, 'always prompt' is checked, but if I don't check it the input controls aren't displayed at all because none is mandatory and the report works with the default values of the parameters.

In my case, all the input controls are not mandatory and only the 'Date' InputControls are required but not the 'number' or 'string' input controls.

 

 

[Olap Analysis View with parameter]

Hi,

I'm using JasperServer CE 3.7.1

Is it possible to use a parameter when launching an analysis view ?

Thanks

[problem with InputControls mandatory]

Hi,

Im using JasperServer 3.7.1 and all my InputControls with type DATE are requested thow I unchecked 'Mandatory' in the input control properties.

Any idea ?

Thanks

 

[Report with table component not running on JasperServer]

Hi,

 

What is the version of your JasperServer ? I think it should be at least 3.7.6.

 

 

[multiselect input control + stored procedure]

Hi,

If you have a PARAMETER1 as Collection, you can create a second parameter (not promptable) PARAMETER2 as STRING with  expression $P{PARAMETER1}

At this point you get a String and you can use java string methods like replace() to get away the brackets

[Scheduling a rolling date]

Hi,

Maybe you can try to set a default value to your date parameter in the report : new Date()

Post Edited by mespub at 02/16/2011 07:11

[how to use jasperreport 3.7.6 with jasperserver 3.7.1 ?]

Yes, it works

 

Thanks

[input-control date : Mandatory not checked but I have to input a value]

I'm using JasperServer CE 3.7.1

I have an input-control date with mandatory not checked, but when I launch the report with JasperServer, the date parameter is always required.

Is that a bug ?

Thanks

[Checkbox \'Include Subfolders\' unckecked by default]

Great, it works fine.

 

Thank You

[how to use jasperreport 3.7.6 with jasperserver 3.7.1 ?]

Yes, when I copy all \lib\*.jar from JasperReport 3.7.6 to \lib\*.jar in JasperServer 3.7.1 then the xls export is working fine.

It works but it's a little basic. So I will copy the jars one by one to find out which of them I really need.

Thanks

[Checkbox \'Include Subfolders\' unckecked by default]

Hello,

I'm using JasperServer 3.7.1 CE

On the first screen showing the repository folders, is it possible to make the checkbox 'Include subfolders'  unchecked by default ?

Thanks

[how to use jasperreport 3.7.6 with jasperserver 3.7.1 ?]

Hello,

I'm using jasperserver 3.7.1 CE and I'd like to use the new functionnalities of  jasperreport 3.7.6.

So I replaced jasperreport 3.7.1.1.jar by jasperreport 3.7.6.jar in Tomcat 6.0webappsjasperserverWEB-INFlib

but I'm getting the following error message while exporting report results into XLS.

Did I miss something ?

Thanks for your help

Etat HTTP 500 -

---

type Rapport d'exception

message

description Le serveur a rencontré une erreur interne () qui l'a empêché de satisfaire la requête.

exception

org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoSuchMethodError: jxl.WorkbookSettings.setUseTemporaryFileDuringWrite(Z)V	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:924)	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)	javax.servlet.http.HttpServlet.service(HttpServlet.java:637)	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)	com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)	com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:146)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)	org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)	org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)	com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

cause mère

java.lang.NoSuchMethodError: jxl.WorkbookSettings.setUseTemporaryFileDuringWrite(Z)V	net.sf.jasperreports.engine.export.JExcelApiExporter.openWorkbook(JExcelApiExporter.java:282)	net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:530)	net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:299)	com.jaspersoft.jasperserver.war.action.ReportExcelExporter.export(ReportExcelExporter.java:106)	com.jaspersoft.jasperserver.war.action.AbstractReportExporter.exportBuffered(AbstractReportExporter.java:140)	com.jaspersoft.jasperserver.war.action.AbstractReportExporter.export(AbstractReportExporter.java:89)	com.jaspersoft.jasperserver.war.action.ReportExporterAction.export(ReportExporterAction.java:89)	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)	java.lang.reflect.Method.invoke(Unknown Source)	org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98)	org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123)	org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)	org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145)	org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)	org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79)	org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188)	org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145)	org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51)	org.springframework.webflow.engine.ActionList.execute(ActionList.java:155)	org.springframework.webflow.engine.State.enter(State.java:193)	org.springframework.webflow.engine.Transition.execute(Transition.java:227)	org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391)	org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214)	org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119)	org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555)	org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386)	org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210)	org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:105)	org.springframework.webflow.engine.State.enter(State.java:194)	org.springframework.webflow.engine.Transition.execute(Transition.java:227)	org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391)	org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214)	org.springframework.webflow.engine.Flow.handleEvent(Flow.java:560)	org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386)	org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210)	org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:230)	org.springframework.webflow.engine.ViewState.resume(ViewState.java:196)	org.springframework.webflow.engine.Flow.resume(Flow.java:545)	org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259)	org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:163)	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)	java.lang.reflect.Method.invoke(Unknown Source)	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)	org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66)	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)	$Proxy17.resumeExecution(Unknown Source)	org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183)	org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174)	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511)	javax.servlet.http.HttpServlet.service(HttpServlet.java:637)	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)	com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)	com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:146)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)	org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)	org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)	org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)	org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175)	org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)	com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)	org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)	org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

Post Edited by mespub at 01/31/2011 09:06

[How to customize the display of the repository list]

Thanks for your reply, but we'll still use JS 3.7.1 CE for a moment.

Is there a way to customize this screen with that version ?

[How to customize the display of the repository list]

Hi,

I'm using JS 3.7.1 CE and I'm looking for the way to customize the repository list (first screen in JasperServer).

I need to enlarge the report title  column and decrease the description column.

Thanks for your help

[How to put totally different two reports into one?]

Hi,

 

The band in wich you put the subreport depends on the query of the main report.

If you need to display 2 subreports for each row, you'll use the detail band, but if you wish 2 subreport once in the main report, you can place them in the summary.

 

For your second question, you can specify in the properties of each group if you want to have a page break.

 

Regards

 

[Schema Locations]

hi,

 

you can put your schemas wherever you want, and you have to load them in the repository

 

Regards

[How to hide rows in analysis view -JasperServer CE]

hi,

 

you have to specify for the hierarchy in your schema :

hasAll="false"

 

regards

[Single select input control with "All" option]

did you create the input control in the report unit as a string ?