Jump to content
Changes to the Jaspersoft community edition download ×

katherine.vierra

Members
  • Posts

    26
  • Joined

  • Last visited

katherine.vierra's Achievements

Contributor

Contributor (5/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges

0

Reputation

  1. Thanks for the responses. I will use the descriptions with the 250 word limit.
  2. 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.
  3. 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
  4. 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
  5. 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
  6. 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!
  7. 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)
  8. 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!
  9. 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!
  10. 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.
  11. 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
  12. 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!
  13. 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*$
  14. 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.
×
×
  • Create New...