katherine.vierra

Thanks for the responses. I will use the descriptions with the 250 word limit.

I know you can enter tooltips inside a report and on the input controls, etc, but was hoping to be able to enter a tooltip on the report name as shown on the main Reports menu which lists all reports. For example, you would mouse over a report name from the list and it would give you a tooltip regarding the report contents to help the user better select the report they need to run. I realize I could use the description field for this, but thought tooltips may allow more characters. I am using Studio and JS 6.1 Thanks.

Hello, Thanks for the reply. 1) The number of options will vary. They are db queries, so it depends on what a particular customer has built in their database. I can see a way to do a hidden input control to capture that though. I could do the same query that gets the list, except do a count. 2) The input control data type is string. For some reason, java seems to have an issue with the jasper collection type. Regards, Katherine

We dynamically create our queries inside a java class. Long story short, the way our queries are constructed, we do not want the user to be able to 'select all'. What I'm looking for is a way to turn off the 'Select All' option in the input control. Any ideas how or if this can be done? Thanks

I am having an odd issue that did not happen until we upgraded Jasperserver from 5.0.1 to 5.6.0 and switched from using jetty to tomcat. Some background: We support MSSQL 2008 & 2012. We use a jndi connection to connect to the jasperserver SQL database and the reporting database. I have tried various versions of jtds drivers. JasperServer opens and seems to perform correctly except for when it comes to create a scheduled report. After entering all of the necessary information to schedule a report and clicking 'save', I am stuck. I'm not returned to the list of scheduled instances. I just remain on the screen where I setup scheduling no matter how many times I click 'Save'. I have to hit 'Cancel' to get out. No scheduled instance is created or executed. The error that occurs when I try to save a scheduled report seems quite odd. Please see below. 2015-10-22 13:03:54,292 ERROR ReportJobsQuartzScheduler,http-apr-8081-exec-2:198 - Error scheduling Quartz joborg.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. [see nested exception: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR.] at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:157) at org.quartz.impl.jdbcjobstore.DBSemaphore.obtainLock(DBSemaphore.java:113) at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:238) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3722) at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1047) at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:840) at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:250) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportJobsQuartzScheduler.scheduleJob(ReportJobsQuartzScheduler.java:191) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy69.scheduleJob(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.ReportSchedulingFacade.scheduleJob(ReportSchedulingFacade.java:493) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) at com.sun.proxy.$Proxy74.scheduleJob(Unknown Source) at com.jaspersoft.jasperserver.remote.services.impl.JobsServiceImpl.scheduleJob(JobsServiceImpl.java:88) at com.jaspersoft.jasperserver.jaxrs.job.JobsJaxrsService$5.call(JobsJaxrsService.java:229) at com.jaspersoft.jasperserver.jaxrs.job.JobsJaxrsService$5.call(JobsJaxrsService.java:227) at com.jaspersoft.jasperserver.jaxrs.job.JobsServiceCallTemplate.callRemoteService(JobsServiceCallTemplate.java:55) at com.jaspersoft.jasperserver.jaxrs.job.JobsServiceCallTemplate.callRemoteService(JobsServiceCallTemplate.java:44) at com.jaspersoft.jasperserver.remote.common.RemoteServiceWrapper.callRemoteService(RemoteServiceWrapper.java:44) at com.jaspersoft.jasperserver.jaxrs.job.JobsJaxrsService.scheduleJobWithProcessedParameters(JobsJaxrsService.java:227) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1483) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1414) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1363) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1353) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:708) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.StaticFilesCacheControlFilter.doFilter(StaticFilesCacheControlFilter.java:163) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) 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:411) 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:411) 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:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:148) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:94) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:179) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at com.jaspersoft.jasperserver.war.NullFilter.doFilterHttp(NullFilter.java:44) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:79) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:104) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:43) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:612) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2466) at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2455) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Unknown Source)Caused by: java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.quartz.impl.jdbcjobstore.StdRowLockSemaphore.executeSQL(StdRowLockSemaphore.java:96) ... 146 more

I have an odd problem I'm seeing in production installs that I'm not seeing in development. I have one theory that it could be jasperdb related, since we upgraded our jasper version from 5.01 to 5.6.0 recently. Without getting into all the particulars of the issue - Is there a way to tell what version the jasperserver database itself is? Is there a version field or possibly new tables/fields that were introduced in 5.6.0 that were not present in 5.0.1? I know how to tell what version of JasperServer I'm running, I'm talking strictly from the database side. Thanks for any help!

I did get the install doc from support. So, I'm following along with that. I think I have it setup right, but still getting the error when importing and cannot open the JasperServer url. I get 404 not found error. However I can get the tomcat welcome page by going to 127.0.0.1:8081 (we're using 8081 instead of 8080)

I cannot seem to locate this anywhere. On the support portal is a copy of the 6.0 guide, but when I go back to prior versions I cannot get a copy of the 5.6.0 guide (which we are using) or even the 5.6.1 guide. Is there anyone that can get me a copy of that guide? I have gotten past the postgressql message by editing the js.jdbc file in buildomaticconf_sourceiePro to point to sql. However, now I am getting an error stating that the 'PREPARESQL statement was not initiated properly' when trying to import via buildomatic. I have reverted the changes in context.xml. The problem is likely the driver issue, but without the proper version of the install guide I'm a bit lost. Thanks!

We do not use postgres, instead we use MSSQL 2008. Recently we have switched to using a stand alone tomcat install. Previously we used jetty and had no problems, but we're also trying to switch from Jasper 5.0 to 5.6 so there could be some snags there as well. I have created a default_master.properties file in the buildomatic folder by copying the sql example from the sample_conf folder and editing it to point to our sql jasperserver database. I have also changed the context.xml file in META-INF to point to the correct sql database, however whenever I try to import something from the command line I always get: Cannot load driver class: org.postgressql.driver I don't want to use postgress. I've searched for any config files that refer to that and it seems to point to sql. Is there a config file I am missing? Thanks!

This did help. It's a bit quirky when the top level of a cascading input control is multiselect. The trick was in the query for the top level control. Previously I used. Select uo.unitorgid as organization from unitorg uo However, I descovered that the "as unitorgid" had to be changed to "as unitorg" since 'unitorg' is the id of the corresponding input control/parameter. I also had to put 'unitorg' as the value/display field for the input control. Previously when the organization control was single select, I used the database field name as the value field in the input control and it seemed to work fine.

Hello, I am using JasperServer 5.6.0 and iReport. I am trying to create a cascading input control where the first input control (organization) is multi-select. That input control seems to work properly. The problem comes in when I try to create the 2nd level input control (unit). 1st Level parameter = organization (mult-select input control) 2nd Level parameter (cascading from organization) = unit (multi-select input control) This is the basic syntax I'm using for the query to populate the 2nd level (unit) input control. select distinct UnitId, Name from Unit where $X{IN,unit.unitorgid,organization} When I execute the report on the server, I get no input controls. When I look in the jasperserver.log, it is blank. I've tried restarting my services but doesn't seem to trigger any logging. Hopefully someone can tell me what I'm doing wrong. Thanks

James, Thanks for the info. I knew you could mess with the javascript, but didn't know a lot about doing that. I did find a section in the applicationContext-rest-services.xml file with the comment 'Video Tutorials' above it. I commented those lines and restarted the service just to see what would happen. I still see the 'Popular Resources' header and below it says 'you have nothing to show'. So, the links are gone, but that's not quite as clean as I'd prefer for sending into a production environment. You can also comment out the links to the tutorials for reports, adhoc, data sources, etc. I've not decided yet, but that may be something we wish to remove as well. We don't provide users with all the functionality that tutorials and videos promise. So, I find it's best to hide that info than offer false promises. I agree it seems like there should be a simple option to turn it off, but so far I've found that to customize anything I have to go to various xml and properties files. Currently I'm at nearly a dozen I've customized to hide one thing or another. I will post if I find anything else. Thanks!

I know this is probably far too late to help the OP, but thought I'd post the solution I am using in case anyone else has this issue. Jasper will not accept the SET TRANSACTION ISOLATION LEVEL REPEATABLE READ in the query window. (we use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED). In either case, Jasper will not accept that. Any statement must return a dataset. To get around this we created a SQL stored procedure which sets the transaction isolation level before accepting the parameters from Jasper and returning a dataset. In the report jrxml/query window you would have a statement like: EXEC storedProcedureName $P{param1}, $P{param2} You will have to change a config file to allow the execution of a stored procedure as it is not by allowed by default in Jasper. You can do that in WEB-INF/classes/esapi/validation.properties Look for the line: Validator.ValidSQL= Mine now looks like the following: Validator.ValidSQL=(?is)^\s*(select|call|exec(ute)?)\s+[^;]+;?\s*$

We are implementing the use of relative dates (JasperServer 5.6) with our jrxml reports so that customers can schedule reports to run daily with date parameters that are relative to the current date. In order to do this, per (http://community.jaspersoft.com/wiki/how-use-relative-dates-jrxml-static-reports) we have changed all of our date input parameter classes to 'Timestamp Range' (previously used java.sql.Timestamp). And have begun using the syntax $X{BETWEEN, field, begindate, enddate} in our queries. We have some reports which call a SQL stored procedure to get the report dataset. The problem is, I cannot seem to get those reports to accept the new date class. If I try to send it via a standard: EXEC storedproc $P{begin_date}, $P{end_date}, param3, param4, etc... I get an error that $P is not supported for that class (which is true). I just don't know how else to get it to my stored procedure. In the case of these reports the sql is quite complex and built dynamically based on the various input parameters. We may use different tables/joins depending on what the user chooses and a stored procedure seemed to be the way to go with that. Also, we need to be able to set the dbase to READ UNCOMMITTED and Jasper won't accept that in their query window. I did attempt to copy the value of the date params to two new params of a different class(java.sql.timestamp) that could be sent to the stored proc, but I always get a null value in the second set of params (See Below) DATE PARAMETERS ENTERED BY USER <parameter name="begin_date" class="net.sf.jasperreports.types.date.TimestampRange"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="end_date" class="net.sf.jasperreports.types.date.TimestampRange"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> MY FAILED ATTEMPT TO COPY THE VALUE OF THOSE PARAMETERS TO SOMETHING I CAN SEND TO THE STORED PROC <parameter name="beginTime" class="java.sql.Timestamp" isForPrompting="false"> <defaultValueExpression><![CDATA[$P{begin_date}.getStart()]]></defaultValueExpression> </parameter> <parameter name="endTime" class="java.sql.Timestamp" isForPrompting="false"> <defaultValueExpression><![CDATA[$P{end_date}.getStart()]]></defaultValueExpression> </parameter> <queryString> Any suggestions would be greatly appreciated.

PLEASE SOMEONE ANSWER THIS QUESTION!!!

hozawa, Thanks, but that's not what I'm trying to do in this instance. I've already eliminated the nulls issue. I just want to auto select all the results of the query that builds the input control. I think I've figured out a way to do it with a really involved nested SQL query in my helper class, so I may not need to get the values from the parameter after all. But, it would be nice to know how...

I won't get into the reasons why - because we'd be here all day - but I need to be able to automatically select all the results of a multi-select input parameter without input from a user. I have the parameter working fine as far as the result set goes, using the following multi-select query: Select iau.unitorgid from iauser_unitorg iau where iau.IaUserId = 'USER_ID' and iau.unitorgid is not null and iau.unitorgid <> '' This gives me the list of valid unitorgid values. Problem is, nothing is selected unless you click 'All' (or set the properties to mandatory, which will auto select the first field only). I need it to select ALL the values returned programatically. This Input Parameter is set to invisible, so I don't even want the user to see it much less have to click 'All'. There has to be a way to do this, I just can't seem to figure out what it is. I've even tried giving the parameter a default value of All but that does nothing. Thanks in advance for any help.

Jasper Server 5.0 - We have text fields in our database that contain html markup. When we export a adhoc view to any format, the html tags are shown rather than rendered. In the AdHoc Viewer itself, everything displays as it should, but when you export the tags show. I would expect that pdf, rtf, and docx - at the least - would be able to render the html. Is there some configuration setting I am missing?

I am receiving an error when hyperlinking from one report to the other (see below). I have repeatedly checked the virtual path to the report in JasperServer and the path below is correct. I was also logged in under the correct organization. When I tested this in my dev environment, it works fine. It is only when I deploy to a multitenant production environment that I receive the error. We are using JasperServer 5.0 com.jaspersoft.jasperserver.multipleTenancy.MTResourceNotVisibleException: Path /Default/Interact Reports/Reports/CAD Detail is not visible in organization context Multitenancy context: organization PK:T:Default at com.jaspersoft.jasperserver.multipleTenancy.DefaultPathTransformer.toExternalPath(DefaultPathTransformer.java:147) I believe this has something to do with the multitenant environ, but haven't been able to find any info on this particular issue. Any ideas would be greatly appreciated.

We are using iReport 4.7.1. When the reports are deployed from JasperServer, there is a delay in picking up any data changes/ new data. I've tried the refresh button at the top and have also tried adding the following line to the mondarian.properities file (as suggested in another post): mondrian.rolap.star.disableCaching=true I realize there is a 'clear adhoc cache' feature in JasperServer, but am unsure if that also applies to iReports?? Also, we have disabled acccess to 'Manage Server' for our customers (Jasper is being used to create reports within the software package my company sells.) I know the customers will whine if they have to go in and manually clear the cache even if we did give them access. Any ideas?

Using JasperServer 5.0, there is always a 'Error on Page' at the bottom of the IE8 screen. I tried FireFox and was not able to duplicate. Here is the text of the error: 'this._dom' is null or not an object components.searchBox.js Line: 44 Code: 0 Char: 5 URI: http://localhost:9081/JasperServer/scripts/components.searchBox.js The error doesn't appear to be causing issues, but our QA folks are asking about it. Thanks.

We are using JasperServer 4.7. We need to override the value of the REPORT_TIME_ZONE parameter. I have tried doing in this 2 different ways and jasperserver seems to be ignoring any new values and always going with the default time zone of the jasperserver. The report runs without error and there is nothing in the jasperserver log to indicate any errors. Below are the methods I've tried. 1. From a java class using java.util.TimeZone I sent reportParameters.put( "REPORT_TIME_ZONE", TimeZone.getDefault() );reportParameters.put( "testparam", TimeZone.getDefault() ); /** this is just to see if it is sending the correct param. ** the information is being sent to the report, because testparam displays correctly on the report screen. The format is also appropriate as well. See below. This is the EXACT value of REPORT_TIME_ZONE if I set the timezone to EST at login. However, if I set the timezone to PST at login and then run the report - the REPORT_TIME_ZONE still displays as eastern, even though testparam correctly displays the info for PST timezone. sun.util.calendar.ZoneInfo[id="America/New_York" ,offset=-18000000,dstSavings=3600000 ,useDaylight=true,transitions=235 ,lastRule=java.util.SimpleTimeZone[id=America/New_York ,offset=-18000000,dstSavings=3600000 ,useDaylight=true,startYear=0 ,startMode=3,startMonth=2 ,startDay=8,startDayOfWeek=1 ,startTime=7200000,startTimeMode=0 ,endMode=3,endMonth=10 ,endDay=1,endDayOfWeek=1 ,endTime=7200000,endTimeMode=0] ] 2. I know the following has no practical use, but wanted to test -- I added a new single select inputcontrol called timezone that linked to the id REPORT_TIME_ZONE. I entered the ZoneInfo for several different time zones. Once again the test completes without error, but the REPORT_TIME_ZONE remains set to the default regardless of what is chosen in the dropdown.

Thanks for the reply. It sounds like this 'userTimezone' info would be passed as part of the url the user is directed to when we log them in to JRS. Is that correct?

Our times are stored in the database as GMT. Our users will not necessarily be in the same timezone as the jasperserver, so we need to able to pass the local browser's timezone to jasperserve so that the dates in reports will reflect the user's local time. I realize this can be done when logging in to jasperserver, however, we are logging the customer in from a separate webapp. We don't want them to have to specify their local timezone each time they login. How would we pass this in our login token?