Jump to content
Changes to the Jaspersoft community edition download ×

cameron_1

Members
 View Profile  See their activity

  • Posts

    75

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by cameron_1

  1. cameron_1
    Yeah, right... As if Jaspersoft listens to their customers with support contracts. Also, it's not exclusive to customers with support contracts, it's available on the AWS versions, without support.
  2. cameron_1
    Not sure if this will still work on 6.2... It was written for 5.2, and updated again with 5.5, but that's the latest version I have, so I've not been able to test/port to 6.2 unfortunately. I have had a quick look at 6.2 and there did appear to be some changes in the way the input controls were rendered, so I suspect it may break this code in the process...
  3. cameron_1
    It's in the same location in Jaspersoft Studio 6 as it was in 5.5/5.6.
  4. cameron_1
    Hi All, I've just upgraded our test server to 6.0, and no the MS SQL Server 2005 Driver (com.microsoft.sqlserver.jdbc.SQLServerDriver) no longer works. Whenever you try to connect to the server it just returns this error - The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server key".[/code]Anyone else experiencing this problem? This is running on SQL Server 2014. I think the JVM installed with jaspersoft may be contributing here (I loathe to play with it though, for fear of breaking things further), thats on version 1.6.0_18. Full stack trace is here - com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Server key".ClientConnectionId:2153df67-6305-42e4-ba3b-39c2dfee6b3batcom.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)atcom.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1668)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1323)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)atcom.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)atcom.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)at java.sql.DriverManager.getConnection(DriverManager.java:582)at java.sql.DriverManager.getConnection(DriverManager.java:185)atorg.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:48)atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(JdbcDriverManagerConnectionFactory.java:36)atorg.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)atorg.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:771)atorg.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.testConnection(JdbcDataSourceService.java:84)atcom.jaspersoft.jasperserver.remote.connection.JdbcConnectionStrategy.createConnection(JdbcConnectionStrategy.java:73)atcom.jaspersoft.jasperserver.remote.connection.JdbcConnectionStrategy.createConnection(JdbcConnectionStrategy.java:44)atcom.jaspersoft.jasperserver.remote.connection.ConnectionsManager.createConnection(ConnectionsManager.java:71)atcom.jaspersoft.jasperserver.jaxrs.connection.ConnectionsJaxrsService.createConnection(ConnectionsJaxrsService.java:84)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)atcom.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)atcom.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205)atcom.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)atcom.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302)atcom.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)atcom.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)atcom.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)atcom.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1483)atcom.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1414)atcom.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1363)atcom.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1353)atcom.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414)atcom.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)atcom.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:708)at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)atorg.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)atorg.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)atorg.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.jaspersoft.jasperserver.war.StaticFilesCacheControlFilter.doFilter(StaticFilesCacheControlFilter.java:163)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399)atorg.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)atorg.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atorg.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atorg.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:103)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:94)atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)atorg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:179)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)atorg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atorg.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.war.NullFilter.doFilterHttp(NullFilter.java:44)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)atorg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:210)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:83)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:80)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:150)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atorg.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)atorg.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atcom.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:85)atorg.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411)atorg.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188)atorg.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:104)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.jaspersoft.jasperserver.war.util.SessionDecoratorFilter.doFilter(SessionDecoratorFilter.java:63)atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)atorg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67)atorg.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)atorg.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atcom.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43)atorg.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)atorg.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)atorg.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)atorg.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)atorg.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558)atorg.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)atorg.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)atorg.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)atorg.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)atorg.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)atorg.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)atorg.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)at java.lang.Thread.run(Thread.java:619)Caused by: javax.net.ssl.SSLException: Server keyatcom.sun.net.ssl.internal.ssl.Handshaker.throwSSLException(Handshaker.java:850)atcom.sun.net.ssl.internal.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:187)atcom.sun.net.ssl.internal.ssl.Handshaker.processLoop(Handshaker.java:516)atcom.sun.net.ssl.internal.ssl.Handshaker.process_record(Handshaker.java:454)atcom.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:884)atcom.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1112)atcom.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1139)atcom.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1123)atcom.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1618)... 123 moreCaused by: java.security.spec.InvalidKeySpecException: key spec notrecognisedatorg.bouncycastle.jcajce.provider.asymmetric.util.BaseKeyFactorySpi.engineGeneratePublic(UnknownSource)atorg.bouncycastle.jcajce.provider.asymmetric.ec.KeyFactorySpi.engineGeneratePublic(UnknownSource)at java.security.KeyFactory.generatePublic(KeyFactory.java:304)atcom.sun.net.ssl.internal.ssl.HandshakeMessage$ECDH_ServerKeyExchange.(HandshakeMessage.java:904)at com.sun.net.ssl.internal.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:183)... 130 more [/code]
  5. cameron_1
    Did you ever find a solution to this? I'm having the same problem with 6.0, I can't get rid of the language="groovy" parameter as I'm actually using expressions written in Groovy (if I get rid of it, it seems to default back to Java, causing expression compilation errors).
  6. cameron_1
    When will this "future release" arrive? It's been 2 years now! It's a very critical missing feature, as you've provided mechanisms to copy input controls, yet no way to rename them, when the input control recourse ID *HAS* to match the report parameter, it's critical that you provide the functionality to rename it, and not just half implement a feature.
  7. cameron_1
    Changed Severity from Minor to Major Changed Assigned User from @User_306070 to @anonymous Couldn't agree more. There are far too many instances where the technical support team have replied to an issue with a rather simple work around or cause, only to leave me scratch my head as to why on earth it wasn't documented in the first place. Paying for support is a joke when all you seem to get back is canned answers, that honestly should be made available to the public.
  8. cameron_1
    I'm getting the same issue here. Did you ever resolve this?
  9. cameron_1
    Many business have their own internal calendars in use, calendars for financial years, manufacturing periods, taxation requirements, etc. Often, as a result of these internal use calendars, reports are needed to be run in alignment. Reports may be required to be run on the first day of each financial month, or once a quarter, for the taxation year. The standard scheduler functionality within Jaspersoft Server is built on top of the Quartz Scheduler, which in turn adopts similar functionality of the *nix cron scheduler. Unfortunately, even with these 3 levels of different scheduling implementations, there isn't really a direct way to schedule reports to run at irregular intervals, or intervals not based directly off the Gregorian calendar. There is one place where we can specify specific dates to apply to a schedule. That is the report exclusions. Schedule ExclusionsThe Quartz Scheduler implements functionality known as "Calendars". These calendars are pre-defined dates or days where a report should not run. Within Quartz there are many different types of calendars available, Annual, Cron, Daily, Holiday, Monthly and Weekly. In the Jaspersoft Server interface, the only calendar type available to use is Holiday calendars. Holiday calendars are used to specify specific dates where reports should not run. eg, don't run on public holidays. Inverse CalendarsKnowing that Jaspersoft Server can use these calendars to exclude specific dates, we can use this to create our schedule for our irregular timed reports. What we need to do, is create an inverse of the calendar we wish the report to run against. We need to list every single day of the year, and remove the dates we do want to report to run. See appendix below for an example exclusion calendar XML. ImplementationThere are a number of different documented ways of implementing a new holiday calendar with Jaspersoft. Adding a Holiday Exclusion Calendar Limiting Scheduled Reports Against Holiday Dates in JasperServer Adding or Updating an Exclusion Calendar Any of these should result in the creation of a new calendar. As of version 5.5 there is a bug in the creation of calendars using the REST API. This bug causes timezones to be applied twice, resulting in exclusion dates never matching. The work around is to exclude ALL timezone information from the XML submitted via this API. (See appendix for more information on this bug.) UsageWhen scheduling a report using these types of exclusion calendars, we use a simple recurrence schedule and set it to run every day. The exclusion calendar we've created will ensure the report does not run every day, only the days we desire. Alternate MethodsIt's possible to alter the idea of exclusion calendars as needed. The daily exclusion calendar described above allows for the most flexibility, where you can select very specific dates to run a report. Sometimes this may not be needed. For example, to schedule a report for the first Monday of each quarter, you can create a calendar recurrence to happen on the first month of each quarter, every Monday. Then create an exclusion calendar for every Monday of that month you don't want a report to run, reducing the number of dates needed in your calendar dramatically. AppendicesAppendix 1 - Example Exclusion CalendarThis calendar is for excluding every day, except the first day of a 445 financial calendar, with the year starting in October. Note the exclusion of the <timezone> details. <?xml version="1.0" encoding="UTF-8" standalone="yes"?><reportJobCalendar> <calendarType>holiday</calendarType> <description>All Days Except First Day of Financial Period</description> <excludeDays> <excludeDay>2013-09-30</excludeDay> <excludeDay>2013-10-01</excludeDay> <excludeDay>2013-10-02</excludeDay> <excludeDay>2013-10-03</excludeDay> <excludeDay>2013-10-04</excludeDay> <excludeDay>2013-10-05</excludeDay> <excludeDay>2013-10-06</excludeDay> <excludeDay>2013-10-07</excludeDay> <excludeDay>2013-10-08</excludeDay> <excludeDay>2013-10-09</excludeDay> <excludeDay>2013-10-10</excludeDay> <excludeDay>2013-10-11</excludeDay> <excludeDay>2013-10-12</excludeDay> <excludeDay>2013-10-13</excludeDay> <excludeDay>2013-10-14</excludeDay> <excludeDay>2013-10-15</excludeDay> <excludeDay>2013-10-16</excludeDay> <excludeDay>2013-10-17</excludeDay> <excludeDay>2013-10-18</excludeDay> <excludeDay>2013-10-19</excludeDay> <excludeDay>2013-10-20</excludeDay> <excludeDay>2013-10-21</excludeDay> <excludeDay>2013-10-22</excludeDay> <excludeDay>2013-10-23</excludeDay> <excludeDay>2013-10-24</excludeDay> <excludeDay>2013-10-25</excludeDay> <excludeDay>2013-10-26</excludeDay> <excludeDay>2013-10-27</excludeDay> <excludeDay>2013-10-28</excludeDay> <excludeDay>2013-10-29</excludeDay> <excludeDay>2013-10-30</excludeDay> <excludeDay>2013-10-31</excludeDay> <excludeDay>2013-11-01</excludeDay> <excludeDay>2013-11-02</excludeDay> <excludeDay>2013-11-04</excludeDay> <excludeDay>2013-11-05</excludeDay> <excludeDay>2013-11-06</excludeDay> <excludeDay>2013-11-07</excludeDay> <excludeDay>2013-11-08</excludeDay> <excludeDay>2013-11-09</excludeDay> <excludeDay>2013-11-10</excludeDay> <excludeDay>2013-11-11</excludeDay> <excludeDay>2013-11-12</excludeDay> <excludeDay>2013-11-13</excludeDay> <excludeDay>2013-11-14</excludeDay> <excludeDay>2013-11-15</excludeDay> <excludeDay>2013-11-16</excludeDay> <excludeDay>2013-11-17</excludeDay> <excludeDay>2013-11-18</excludeDay> <excludeDay>2013-11-19</excludeDay> <excludeDay>2013-11-20</excludeDay> <excludeDay>2013-11-21</excludeDay> <excludeDay>2013-11-22</excludeDay> <excludeDay>2013-11-23</excludeDay> <excludeDay>2013-11-24</excludeDay> <excludeDay>2013-11-25</excludeDay> <excludeDay>2013-11-26</excludeDay> <excludeDay>2013-11-27</excludeDay> <excludeDay>2013-11-28</excludeDay> <excludeDay>2013-11-29</excludeDay> <excludeDay>2013-11-30</excludeDay> <excludeDay>2013-12-02</excludeDay> <excludeDay>2013-12-03</excludeDay> <excludeDay>2013-12-04</excludeDay> <excludeDay>2013-12-05</excludeDay> <excludeDay>2013-12-06</excludeDay> <excludeDay>2013-12-07</excludeDay> <excludeDay>2013-12-08</excludeDay> <excludeDay>2013-12-09</excludeDay> <excludeDay>2013-12-10</excludeDay> <excludeDay>2013-12-11</excludeDay> <excludeDay>2013-12-12</excludeDay> <excludeDay>2013-12-13</excludeDay> <excludeDay>2013-12-14</excludeDay> <excludeDay>2013-12-15</excludeDay> <excludeDay>2013-12-16</excludeDay> <excludeDay>2013-12-17</excludeDay> <excludeDay>2013-12-18</excludeDay> <excludeDay>2013-12-19</excludeDay> <excludeDay>2013-12-20</excludeDay> <excludeDay>2013-12-21</excludeDay> <excludeDay>2013-12-22</excludeDay> <excludeDay>2013-12-23</excludeDay> <excludeDay>2013-12-24</excludeDay> <excludeDay>2013-12-25</excludeDay> <excludeDay>2013-12-26</excludeDay> <excludeDay>2013-12-27</excludeDay> <excludeDay>2013-12-28</excludeDay> <excludeDay>2013-12-30</excludeDay> <excludeDay>2013-12-31</excludeDay> <excludeDay>2014-01-01</excludeDay> <excludeDay>2014-01-02</excludeDay> <excludeDay>2014-01-03</excludeDay> <excludeDay>2014-01-04</excludeDay> <excludeDay>2014-01-05</excludeDay> <excludeDay>2014-01-06</excludeDay> <excludeDay>2014-01-07</excludeDay> <excludeDay>2014-01-08</excludeDay> <excludeDay>2014-01-09</excludeDay> <excludeDay>2014-01-10</excludeDay> <excludeDay>2014-01-11</excludeDay> <excludeDay>2014-01-12</excludeDay> <excludeDay>2014-01-13</excludeDay> <excludeDay>2014-01-14</excludeDay> <excludeDay>2014-01-15</excludeDay> <excludeDay>2014-01-16</excludeDay> <excludeDay>2014-01-17</excludeDay> <excludeDay>2014-01-18</excludeDay> <excludeDay>2014-01-19</excludeDay> <excludeDay>2014-01-20</excludeDay> <excludeDay>2014-01-21</excludeDay> <excludeDay>2014-01-22</excludeDay> <excludeDay>2014-01-23</excludeDay> <excludeDay>2014-01-24</excludeDay> <excludeDay>2014-01-25</excludeDay> <excludeDay>2014-01-26</excludeDay> <excludeDay>2014-01-27</excludeDay> <excludeDay>2014-01-28</excludeDay> <excludeDay>2014-01-29</excludeDay> <excludeDay>2014-01-30</excludeDay> <excludeDay>2014-01-31</excludeDay> <excludeDay>2014-02-01</excludeDay> <excludeDay>2014-02-03</excludeDay> <excludeDay>2014-02-04</excludeDay> <excludeDay>2014-02-05</excludeDay> <excludeDay>2014-02-06</excludeDay> <excludeDay>2014-02-07</excludeDay> <excludeDay>2014-02-08</excludeDay> <excludeDay>2014-02-09</excludeDay> <excludeDay>2014-02-10</excludeDay> <excludeDay>2014-02-11</excludeDay> <excludeDay>2014-02-12</excludeDay> <excludeDay>2014-02-13</excludeDay> <excludeDay>2014-02-14</excludeDay> <excludeDay>2014-02-15</excludeDay> <excludeDay>2014-02-16</excludeDay> <excludeDay>2014-02-17</excludeDay> <excludeDay>2014-02-18</excludeDay> <excludeDay>2014-02-19</excludeDay> <excludeDay>2014-02-20</excludeDay> <excludeDay>2014-02-21</excludeDay> <excludeDay>2014-02-22</excludeDay> <excludeDay>2014-02-23</excludeDay> <excludeDay>2014-02-24</excludeDay> <excludeDay>2014-02-25</excludeDay> <excludeDay>2014-02-26</excludeDay> <excludeDay>2014-02-27</excludeDay> <excludeDay>2014-02-28</excludeDay> <excludeDay>2014-03-01</excludeDay> <excludeDay>2014-03-03</excludeDay> <excludeDay>2014-03-04</excludeDay> <excludeDay>2014-03-05</excludeDay> <excludeDay>2014-03-06</excludeDay> <excludeDay>2014-03-07</excludeDay> <excludeDay>2014-03-08</excludeDay> <excludeDay>2014-03-09</excludeDay> <excludeDay>2014-03-10</excludeDay> <excludeDay>2014-03-11</excludeDay> <excludeDay>2014-03-12</excludeDay> <excludeDay>2014-03-13</excludeDay> <excludeDay>2014-03-14</excludeDay> <excludeDay>2014-03-15</excludeDay> <excludeDay>2014-03-16</excludeDay> <excludeDay>2014-03-17</excludeDay> <excludeDay>2014-03-18</excludeDay> <excludeDay>2014-03-19</excludeDay> <excludeDay>2014-03-20</excludeDay> <excludeDay>2014-03-21</excludeDay> <excludeDay>2014-03-22</excludeDay> <excludeDay>2014-03-23</excludeDay> <excludeDay>2014-03-24</excludeDay> <excludeDay>2014-03-25</excludeDay> <excludeDay>2014-03-26</excludeDay> <excludeDay>2014-03-27</excludeDay> <excludeDay>2014-03-28</excludeDay> <excludeDay>2014-03-29</excludeDay> <excludeDay>2014-03-31</excludeDay> <excludeDay>2014-04-01</excludeDay> <excludeDay>2014-04-02</excludeDay> <excludeDay>2014-04-03</excludeDay> <excludeDay>2014-04-04</excludeDay> <excludeDay>2014-04-05</excludeDay> <excludeDay>2014-04-06</excludeDay> <excludeDay>2014-04-07</excludeDay> <excludeDay>2014-04-08</excludeDay> <excludeDay>2014-04-09</excludeDay> <excludeDay>2014-04-10</excludeDay> <excludeDay>2014-04-11</excludeDay> <excludeDay>2014-04-12</excludeDay> <excludeDay>2014-04-13</excludeDay> <excludeDay>2014-04-14</excludeDay> <excludeDay>2014-04-15</excludeDay> <excludeDay>2014-04-16</excludeDay> <excludeDay>2014-04-17</excludeDay> <excludeDay>2014-04-18</excludeDay> <excludeDay>2014-04-19</excludeDay> <excludeDay>2014-04-20</excludeDay> <excludeDay>2014-04-21</excludeDay> <excludeDay>2014-04-22</excludeDay> <excludeDay>2014-04-23</excludeDay> <excludeDay>2014-04-24</excludeDay> <excludeDay>2014-04-25</excludeDay> <excludeDay>2014-04-26</excludeDay> <excludeDay>2014-04-27</excludeDay> <excludeDay>2014-04-28</excludeDay> <excludeDay>2014-04-29</excludeDay> <excludeDay>2014-04-30</excludeDay> <excludeDay>2014-05-01</excludeDay> <excludeDay>2014-05-02</excludeDay> <excludeDay>2014-05-03</excludeDay> <excludeDay>2014-05-05</excludeDay> <excludeDay>2014-05-06</excludeDay> <excludeDay>2014-05-07</excludeDay> <excludeDay>2014-05-08</excludeDay> <excludeDay>2014-05-09</excludeDay> <excludeDay>2014-05-10</excludeDay> <excludeDay>2014-05-11</excludeDay> <excludeDay>2014-05-12</excludeDay> <excludeDay>2014-05-13</excludeDay> <excludeDay>2014-05-14</excludeDay> <excludeDay>2014-05-15</excludeDay> <excludeDay>2014-05-16</excludeDay> <excludeDay>2014-05-17</excludeDay> <excludeDay>2014-05-18</excludeDay> <excludeDay>2014-05-19</excludeDay> <excludeDay>2014-05-20</excludeDay> <excludeDay>2014-05-21</excludeDay> <excludeDay>2014-05-22</excludeDay> <excludeDay>2014-05-23</excludeDay> <excludeDay>2014-05-24</excludeDay> <excludeDay>2014-05-25</excludeDay> <excludeDay>2014-05-26</excludeDay> <excludeDay>2014-05-27</excludeDay> <excludeDay>2014-05-28</excludeDay> <excludeDay>2014-05-29</excludeDay> <excludeDay>2014-05-30</excludeDay> <excludeDay>2014-05-31</excludeDay> <excludeDay>2014-06-02</excludeDay> <excludeDay>2014-06-03</excludeDay> <excludeDay>2014-06-04</excludeDay> <excludeDay>2014-06-05</excludeDay> <excludeDay>2014-06-06</excludeDay> <excludeDay>2014-06-07</excludeDay> <excludeDay>2014-06-08</excludeDay> <excludeDay>2014-06-09</excludeDay> <excludeDay>2014-06-10</excludeDay> <excludeDay>2014-06-11</excludeDay> <excludeDay>2014-06-12</excludeDay> <excludeDay>2014-06-13</excludeDay> <excludeDay>2014-06-14</excludeDay> <excludeDay>2014-06-15</excludeDay> <excludeDay>2014-06-16</excludeDay> <excludeDay>2014-06-17</excludeDay> <excludeDay>2014-06-18</excludeDay> <excludeDay>2014-06-19</excludeDay> <excludeDay>2014-06-20</excludeDay> <excludeDay>2014-06-21</excludeDay> <excludeDay>2014-06-22</excludeDay> <excludeDay>2014-06-23</excludeDay> <excludeDay>2014-06-24</excludeDay> <excludeDay>2014-06-25</excludeDay> <excludeDay>2014-06-26</excludeDay> <excludeDay>2014-06-27</excludeDay> <excludeDay>2014-06-28</excludeDay> <excludeDay>2014-06-30</excludeDay> <excludeDay>2014-07-01</excludeDay> <excludeDay>2014-07-02</excludeDay> <excludeDay>2014-07-03</excludeDay> <excludeDay>2014-07-04</excludeDay> <excludeDay>2014-07-05</excludeDay> <excludeDay>2014-07-06</excludeDay> <excludeDay>2014-07-07</excludeDay> <excludeDay>2014-07-08</excludeDay> <excludeDay>2014-07-09</excludeDay> <excludeDay>2014-07-10</excludeDay> <excludeDay>2014-07-11</excludeDay> <excludeDay>2014-07-12</excludeDay> <excludeDay>2014-07-13</excludeDay> <excludeDay>2014-07-14</excludeDay> <excludeDay>2014-07-15</excludeDay> <excludeDay>2014-07-16</excludeDay> <excludeDay>2014-07-17</excludeDay> <excludeDay>2014-07-18</excludeDay> <excludeDay>2014-07-19</excludeDay> <excludeDay>2014-07-20</excludeDay> <excludeDay>2014-07-21</excludeDay> <excludeDay>2014-07-22</excludeDay> <excludeDay>2014-07-23</excludeDay> <excludeDay>2014-07-24</excludeDay> <excludeDay>2014-07-25</excludeDay> <excludeDay>2014-07-26</excludeDay> <excludeDay>2014-07-27</excludeDay> <excludeDay>2014-07-28</excludeDay> <excludeDay>2014-07-29</excludeDay> <excludeDay>2014-07-30</excludeDay> <excludeDay>2014-07-31</excludeDay> <excludeDay>2014-08-01</excludeDay> <excludeDay>2014-08-02</excludeDay> <excludeDay>2014-08-04</excludeDay> <excludeDay>2014-08-05</excludeDay> <excludeDay>2014-08-06</excludeDay> <excludeDay>2014-08-07</excludeDay> <excludeDay>2014-08-08</excludeDay> <excludeDay>2014-08-09</excludeDay> <excludeDay>2014-08-10</excludeDay> <excludeDay>2014-08-11</excludeDay> <excludeDay>2014-08-12</excludeDay> <excludeDay>2014-08-13</excludeDay> <excludeDay>2014-08-14</excludeDay> <excludeDay>2014-08-15</excludeDay> <excludeDay>2014-08-16</excludeDay> <excludeDay>2014-08-17</excludeDay> <excludeDay>2014-08-18</excludeDay> <excludeDay>2014-08-19</excludeDay> <excludeDay>2014-08-20</excludeDay> <excludeDay>2014-08-21</excludeDay> <excludeDay>2014-08-22</excludeDay> <excludeDay>2014-08-23</excludeDay> <excludeDay>2014-08-24</excludeDay> <excludeDay>2014-08-25</excludeDay> <excludeDay>2014-08-26</excludeDay> <excludeDay>2014-08-27</excludeDay> <excludeDay>2014-08-28</excludeDay> <excludeDay>2014-08-29</excludeDay> <excludeDay>2014-08-30</excludeDay> <excludeDay>2014-09-01</excludeDay> <excludeDay>2014-09-02</excludeDay> <excludeDay>2014-09-03</excludeDay> <excludeDay>2014-09-04</excludeDay> <excludeDay>2014-09-05</excludeDay> <excludeDay>2014-09-06</excludeDay> <excludeDay>2014-09-07</excludeDay> <excludeDay>2014-09-08</excludeDay> <excludeDay>2014-09-09</excludeDay> <excludeDay>2014-09-10</excludeDay> <excludeDay>2014-09-11</excludeDay> <excludeDay>2014-09-12</excludeDay> <excludeDay>2014-09-13</excludeDay> <excludeDay>2014-09-14</excludeDay> <excludeDay>2014-09-15</excludeDay> <excludeDay>2014-09-16</excludeDay> <excludeDay>2014-09-17</excludeDay> <excludeDay>2014-09-18</excludeDay> <excludeDay>2014-09-19</excludeDay> <excludeDay>2014-09-20</excludeDay> <excludeDay>2014-09-21</excludeDay> <excludeDay>2014-09-22</excludeDay> <excludeDay>2014-09-23</excludeDay> <excludeDay>2014-09-24</excludeDay> <excludeDay>2014-09-25</excludeDay> <excludeDay>2014-09-26</excludeDay> <excludeDay>2014-09-27</excludeDay> <excludeDay>2014-09-29</excludeDay> <excludeDay>2014-09-30</excludeDay> <excludeDay>2014-10-01</excludeDay> <excludeDay>2014-10-02</excludeDay> <excludeDay>2014-10-03</excludeDay> <excludeDay>2014-10-04</excludeDay> <excludeDay>2014-10-05</excludeDay> <excludeDay>2014-10-06</excludeDay> <excludeDay>2014-10-07</excludeDay> <excludeDay>2014-10-08</excludeDay> <excludeDay>2014-10-09</excludeDay> <excludeDay>2014-10-10</excludeDay> <excludeDay>2014-10-11</excludeDay> <excludeDay>2014-10-12</excludeDay> <excludeDay>2014-10-13</excludeDay> <excludeDay>2014-10-14</excludeDay> <excludeDay>2014-10-15</excludeDay> <excludeDay>2014-10-16</excludeDay> <excludeDay>2014-10-17</excludeDay> <excludeDay>2014-10-18</excludeDay> <excludeDay>2014-10-19</excludeDay> <excludeDay>2014-10-20</excludeDay> <excludeDay>2014-10-21</excludeDay> <excludeDay>2014-10-22</excludeDay> <excludeDay>2014-10-23</excludeDay> <excludeDay>2014-10-24</excludeDay> <excludeDay>2014-10-25</excludeDay> <excludeDay>2014-10-26</excludeDay> <excludeDay>2014-10-27</excludeDay> <excludeDay>2014-10-28</excludeDay> <excludeDay>2014-10-29</excludeDay> <excludeDay>2014-10-30</excludeDay> <excludeDay>2014-10-31</excludeDay> <excludeDay>2014-11-01</excludeDay> <excludeDay>2014-11-03</excludeDay> <excludeDay>2014-11-04</excludeDay> <excludeDay>2014-11-05</excludeDay> <excludeDay>2014-11-06</excludeDay> <excludeDay>2014-11-07</excludeDay> <excludeDay>2014-11-08</excludeDay> <excludeDay>2014-11-09</excludeDay> <excludeDay>2014-11-10</excludeDay> <excludeDay>2014-11-11</excludeDay> <excludeDay>2014-11-12</excludeDay> <excludeDay>2014-11-13</excludeDay> <excludeDay>2014-11-14</excludeDay> <excludeDay>2014-11-15</excludeDay> <excludeDay>2014-11-16</excludeDay> <excludeDay>2014-11-17</excludeDay> <excludeDay>2014-11-18</excludeDay> <excludeDay>2014-11-19</excludeDay> <excludeDay>2014-11-20</excludeDay> <excludeDay>2014-11-21</excludeDay> <excludeDay>2014-11-22</excludeDay> <excludeDay>2014-11-23</excludeDay> <excludeDay>2014-11-24</excludeDay> <excludeDay>2014-11-25</excludeDay> <excludeDay>2014-11-26</excludeDay> <excludeDay>2014-11-27</excludeDay> <excludeDay>2014-11-28</excludeDay> <excludeDay>2014-11-29</excludeDay> <excludeDay>2014-12-01</excludeDay> <excludeDay>2014-12-02</excludeDay> <excludeDay>2014-12-03</excludeDay> <excludeDay>2014-12-04</excludeDay> <excludeDay>2014-12-05</excludeDay> <excludeDay>2014-12-06</excludeDay> <excludeDay>2014-12-07</excludeDay> <excludeDay>2014-12-08</excludeDay> <excludeDay>2014-12-09</excludeDay> <excludeDay>2014-12-10</excludeDay> <excludeDay>2014-12-11</excludeDay> <excludeDay>2014-12-12</excludeDay> <excludeDay>2014-12-13</excludeDay> <excludeDay>2014-12-14</excludeDay> <excludeDay>2014-12-15</excludeDay> <excludeDay>2014-12-16</excludeDay> <excludeDay>2014-12-17</excludeDay> <excludeDay>2014-12-18</excludeDay> <excludeDay>2014-12-19</excludeDay> <excludeDay>2014-12-20</excludeDay> <excludeDay>2014-12-21</excludeDay> <excludeDay>2014-12-22</excludeDay> <excludeDay>2014-12-23</excludeDay> <excludeDay>2014-12-24</excludeDay> <excludeDay>2014-12-25</excludeDay> <excludeDay>2014-12-26</excludeDay> <excludeDay>2014-12-27</excludeDay> <excludeDay>2014-12-29</excludeDay> <excludeDay>2014-12-30</excludeDay> <excludeDay>2014-12-31</excludeDay> <excludeDay>2015-01-01</excludeDay> <excludeDay>2015-01-02</excludeDay> <excludeDay>2015-01-03</excludeDay> <excludeDay>2015-01-04</excludeDay> <excludeDay>2015-01-05</excludeDay> <excludeDay>2015-01-06</excludeDay> <excludeDay>2015-01-07</excludeDay> <excludeDay>2015-01-08</excludeDay> <excludeDay>2015-01-09</excludeDay> <excludeDay>2015-01-10</excludeDay> <excludeDay>2015-01-11</excludeDay> <excludeDay>2015-01-12</excludeDay> <excludeDay>2015-01-13</excludeDay> <excludeDay>2015-01-14</excludeDay> <excludeDay>2015-01-15</excludeDay> <excludeDay>2015-01-16</excludeDay> <excludeDay>2015-01-17</excludeDay> <excludeDay>2015-01-18</excludeDay> <excludeDay>2015-01-19</excludeDay> <excludeDay>2015-01-20</excludeDay> <excludeDay>2015-01-21</excludeDay> <excludeDay>2015-01-22</excludeDay> <excludeDay>2015-01-23</excludeDay> <excludeDay>2015-01-24</excludeDay> <excludeDay>2015-01-25</excludeDay> <excludeDay>2015-01-26</excludeDay> <excludeDay>2015-01-27</excludeDay> <excludeDay>2015-01-28</excludeDay> <excludeDay>2015-01-29</excludeDay> <excludeDay>2015-01-30</excludeDay> <excludeDay>2015-01-31</excludeDay> <excludeDay>2015-02-02</excludeDay> <excludeDay>2015-02-03</excludeDay> <excludeDay>2015-02-04</excludeDay> <excludeDay>2015-02-05</excludeDay> <excludeDay>2015-02-06</excludeDay> <excludeDay>2015-02-07</excludeDay> <excludeDay>2015-02-08</excludeDay> <excludeDay>2015-02-09</excludeDay> <excludeDay>2015-02-10</excludeDay> <excludeDay>2015-02-11</excludeDay> <excludeDay>2015-02-12</excludeDay> <excludeDay>2015-02-13</excludeDay> <excludeDay>2015-02-14</excludeDay> <excludeDay>2015-02-15</excludeDay> <excludeDay>2015-02-16</excludeDay> <excludeDay>2015-02-17</excludeDay> <excludeDay>2015-02-18</excludeDay> <excludeDay>2015-02-19</excludeDay> <excludeDay>2015-02-20</excludeDay> <excludeDay>2015-02-21</excludeDay> <excludeDay>2015-02-22</excludeDay> <excludeDay>2015-02-23</excludeDay> <excludeDay>2015-02-24</excludeDay> <excludeDay>2015-02-25</excludeDay> <excludeDay>2015-02-26</excludeDay> <excludeDay>2015-02-27</excludeDay> <excludeDay>2015-02-28</excludeDay> <excludeDay>2015-03-02</excludeDay> <excludeDay>2015-03-03</excludeDay> <excludeDay>2015-03-04</excludeDay> <excludeDay>2015-03-05</excludeDay> <excludeDay>2015-03-06</excludeDay> <excludeDay>2015-03-07</excludeDay> <excludeDay>2015-03-08</excludeDay> <excludeDay>2015-03-09</excludeDay> <excludeDay>2015-03-10</excludeDay> <excludeDay>2015-03-11</excludeDay> <excludeDay>2015-03-12</excludeDay> <excludeDay>2015-03-13</excludeDay> <excludeDay>2015-03-14</excludeDay> <excludeDay>2015-03-15</excludeDay> <excludeDay>2015-03-16</excludeDay> <excludeDay>2015-03-17</excludeDay> <excludeDay>2015-03-18</excludeDay> <excludeDay>2015-03-19</excludeDay> <excludeDay>2015-03-20</excludeDay> <excludeDay>2015-03-21</excludeDay> <excludeDay>2015-03-22</excludeDay> <excludeDay>2015-03-23</excludeDay> <excludeDay>2015-03-24</excludeDay> <excludeDay>2015-03-25</excludeDay> <excludeDay>2015-03-26</excludeDay> <excludeDay>2015-03-27</excludeDay> <excludeDay>2015-03-28</excludeDay> <excludeDay>2015-03-30</excludeDay> <excludeDay>2015-03-31</excludeDay> <excludeDay>2015-04-01</excludeDay> <excludeDay>2015-04-02</excludeDay> <excludeDay>2015-04-03</excludeDay> <excludeDay>2015-04-04</excludeDay> <excludeDay>2015-04-05</excludeDay> <excludeDay>2015-04-06</excludeDay> <excludeDay>2015-04-07</excludeDay> <excludeDay>2015-04-08</excludeDay> <excludeDay>2015-04-09</excludeDay> <excludeDay>2015-04-10</excludeDay> <excludeDay>2015-04-11</excludeDay> <excludeDay>2015-04-12</excludeDay> <excludeDay>2015-04-13</excludeDay> <excludeDay>2015-04-14</excludeDay> <excludeDay>2015-04-15</excludeDay> <excludeDay>2015-04-16</excludeDay> <excludeDay>2015-04-17</excludeDay> <excludeDay>2015-04-18</excludeDay> <excludeDay>2015-04-19</excludeDay> <excludeDay>2015-04-20</excludeDay> <excludeDay>2015-04-21</excludeDay> <excludeDay>2015-04-22</excludeDay> <excludeDay>2015-04-23</excludeDay> <excludeDay>2015-04-24</excludeDay> <excludeDay>2015-04-25</excludeDay> <excludeDay>2015-04-26</excludeDay> <excludeDay>2015-04-27</excludeDay> <excludeDay>2015-04-28</excludeDay> <excludeDay>2015-04-29</excludeDay> <excludeDay>2015-04-30</excludeDay> <excludeDay>2015-05-01</excludeDay> <excludeDay>2015-05-02</excludeDay> <excludeDay>2015-05-04</excludeDay> <excludeDay>2015-05-05</excludeDay> <excludeDay>2015-05-06</excludeDay> <excludeDay>2015-05-07</excludeDay> <excludeDay>2015-05-08</excludeDay> <excludeDay>2015-05-09</excludeDay> <excludeDay>2015-05-10</excludeDay> <excludeDay>2015-05-11</excludeDay> <excludeDay>2015-05-12</excludeDay> <excludeDay>2015-05-13</excludeDay> <excludeDay>2015-05-14</excludeDay> <excludeDay>2015-05-15</excludeDay> <excludeDay>2015-05-16</excludeDay> <excludeDay>2015-05-17</excludeDay> <excludeDay>2015-05-18</excludeDay> <excludeDay>2015-05-19</excludeDay> <excludeDay>2015-05-20</excludeDay> <excludeDay>2015-05-21</excludeDay> <excludeDay>2015-05-22</excludeDay> <excludeDay>2015-05-23</excludeDay> <excludeDay>2015-05-24</excludeDay> <excludeDay>2015-05-25</excludeDay> <excludeDay>2015-05-26</excludeDay> <excludeDay>2015-05-27</excludeDay> <excludeDay>2015-05-28</excludeDay> <excludeDay>2015-05-29</excludeDay> <excludeDay>2015-05-30</excludeDay> <excludeDay>2015-06-01</excludeDay> <excludeDay>2015-06-02</excludeDay> <excludeDay>2015-06-03</excludeDay> <excludeDay>2015-06-04</excludeDay> <excludeDay>2015-06-05</excludeDay> <excludeDay>2015-06-06</excludeDay> <excludeDay>2015-06-07</excludeDay> <excludeDay>2015-06-08</excludeDay> <excludeDay>2015-06-09</excludeDay> <excludeDay>2015-06-10</excludeDay> <excludeDay>2015-06-11</excludeDay> <excludeDay>2015-06-12</excludeDay> <excludeDay>2015-06-13</excludeDay> <excludeDay>2015-06-14</excludeDay> <excludeDay>2015-06-15</excludeDay> <excludeDay>2015-06-16</excludeDay> <excludeDay>2015-06-17</excludeDay> <excludeDay>2015-06-18</excludeDay> <excludeDay>2015-06-19</excludeDay> <excludeDay>2015-06-20</excludeDay> <excludeDay>2015-06-21</excludeDay> <excludeDay>2015-06-22</excludeDay> <excludeDay>2015-06-23</excludeDay> <excludeDay>2015-06-24</excludeDay> <excludeDay>2015-06-25</excludeDay> <excludeDay>2015-06-26</excludeDay> <excludeDay>2015-06-27</excludeDay> <excludeDay>2015-06-29</excludeDay> <excludeDay>2015-06-30</excludeDay> <excludeDay>2015-07-01</excludeDay> <excludeDay>2015-07-02</excludeDay> <excludeDay>2015-07-03</excludeDay> <excludeDay>2015-07-04</excludeDay> <excludeDay>2015-07-05</excludeDay> <excludeDay>2015-07-06</excludeDay> <excludeDay>2015-07-07</excludeDay> <excludeDay>2015-07-08</excludeDay> <excludeDay>2015-07-09</excludeDay> <excludeDay>2015-07-10</excludeDay> <excludeDay>2015-07-11</excludeDay> <excludeDay>2015-07-12</excludeDay> <excludeDay>2015-07-13</excludeDay> <excludeDay>2015-07-14</excludeDay> <excludeDay>2015-07-15</excludeDay> <excludeDay>2015-07-16</excludeDay> <excludeDay>2015-07-17</excludeDay> <excludeDay>2015-07-18</excludeDay> <excludeDay>2015-07-19</excludeDay> <excludeDay>2015-07-20</excludeDay> <excludeDay>2015-07-21</excludeDay> <excludeDay>2015-07-22</excludeDay> <excludeDay>2015-07-23</excludeDay> <excludeDay>2015-07-24</excludeDay> <excludeDay>2015-07-25</excludeDay> <excludeDay>2015-07-26</excludeDay> <excludeDay>2015-07-27</excludeDay> <excludeDay>2015-07-28</excludeDay> <excludeDay>2015-07-29</excludeDay> <excludeDay>2015-07-30</excludeDay> <excludeDay>2015-07-31</excludeDay> <excludeDay>2015-08-01</excludeDay> <excludeDay>2015-08-03</excludeDay> <excludeDay>2015-08-04</excludeDay> <excludeDay>2015-08-05</excludeDay> <excludeDay>2015-08-06</excludeDay> <excludeDay>2015-08-07</excludeDay> <excludeDay>2015-08-08</excludeDay> <excludeDay>2015-08-09</excludeDay> <excludeDay>2015-08-10</excludeDay> <excludeDay>2015-08-11</excludeDay> <excludeDay>2015-08-12</excludeDay> <excludeDay>2015-08-13</excludeDay> <excludeDay>2015-08-14</excludeDay> <excludeDay>2015-08-15</excludeDay> <excludeDay>2015-08-16</excludeDay> <excludeDay>2015-08-17</excludeDay> <excludeDay>2015-08-18</excludeDay> <excludeDay>2015-08-19</excludeDay> <excludeDay>2015-08-20</excludeDay> <excludeDay>2015-08-21</excludeDay> <excludeDay>2015-08-22</excludeDay> <excludeDay>2015-08-23</excludeDay> <excludeDay>2015-08-24</excludeDay> <excludeDay>2015-08-25</excludeDay> <excludeDay>2015-08-26</excludeDay> <excludeDay>2015-08-27</excludeDay> <excludeDay>2015-08-28</excludeDay> <excludeDay>2015-08-29</excludeDay> <excludeDay>2015-08-31</excludeDay> <excludeDay>2015-09-01</excludeDay> <excludeDay>2015-09-02</excludeDay> <excludeDay>2015-09-03</excludeDay> <excludeDay>2015-09-04</excludeDay> <excludeDay>2015-09-05</excludeDay> <excludeDay>2015-09-06</excludeDay> <excludeDay>2015-09-07</excludeDay> <excludeDay>2015-09-08</excludeDay> <excludeDay>2015-09-09</excludeDay> <excludeDay>2015-09-10</excludeDay> <excludeDay>2015-09-11</excludeDay> <excludeDay>2015-09-12</excludeDay> <excludeDay>2015-09-13</excludeDay> <excludeDay>2015-09-14</excludeDay> <excludeDay>2015-09-15</excludeDay> <excludeDay>2015-09-16</excludeDay> <excludeDay>2015-09-17</excludeDay> <excludeDay>2015-09-18</excludeDay> <excludeDay>2015-09-19</excludeDay> <excludeDay>2015-09-20</excludeDay> <excludeDay>2015-09-21</excludeDay> <excludeDay>2015-09-22</excludeDay> <excludeDay>2015-09-23</excludeDay> <excludeDay>2015-09-24</excludeDay> <excludeDay>2015-09-25</excludeDay> <excludeDay>2015-09-26</excludeDay> <excludeDay>2015-09-28</excludeDay> <excludeDay>2015-09-29</excludeDay> <excludeDay>2015-09-30</excludeDay> <excludeDay>2015-10-01</excludeDay> <excludeDay>2015-10-02</excludeDay> <excludeDay>2015-10-03</excludeDay> <excludeDay>2015-10-04</excludeDay> <excludeDay>2015-10-05</excludeDay> <excludeDay>2015-10-06</excludeDay> <excludeDay>2015-10-07</excludeDay> <excludeDay>2015-10-08</excludeDay> <excludeDay>2015-10-09</excludeDay> <excludeDay>2015-10-10</excludeDay> <excludeDay>2015-10-11</excludeDay> <excludeDay>2015-10-12</excludeDay> <excludeDay>2015-10-13</excludeDay> <excludeDay>2015-10-14</excludeDay> <excludeDay>2015-10-15</excludeDay> <excludeDay>2015-10-16</excludeDay> <excludeDay>2015-10-17</excludeDay> <excludeDay>2015-10-18</excludeDay> <excludeDay>2015-10-19</excludeDay> <excludeDay>2015-10-20</excludeDay> <excludeDay>2015-10-21</excludeDay> <excludeDay>2015-10-22</excludeDay> <excludeDay>2015-10-23</excludeDay> <excludeDay>2015-10-24</excludeDay> <excludeDay>2015-10-25</excludeDay> <excludeDay>2015-10-26</excludeDay> <excludeDay>2015-10-27</excludeDay> <excludeDay>2015-10-28</excludeDay> <excludeDay>2015-10-29</excludeDay> <excludeDay>2015-10-30</excludeDay> <excludeDay>2015-10-31</excludeDay> <excludeDay>2015-11-02</excludeDay> <excludeDay>2015-11-03</excludeDay> <excludeDay>2015-11-04</excludeDay> <excludeDay>2015-11-05</excludeDay> <excludeDay>2015-11-06</excludeDay> <excludeDay>2015-11-07</excludeDay> <excludeDay>2015-11-08</excludeDay> <excludeDay>2015-11-09</excludeDay> <excludeDay>2015-11-10</excludeDay> <excludeDay>2015-11-11</excludeDay> <excludeDay>2015-11-12</excludeDay> <excludeDay>2015-11-13</excludeDay> <excludeDay>2015-11-14</excludeDay> <excludeDay>2015-11-15</excludeDay> <excludeDay>2015-11-16</excludeDay> <excludeDay>2015-11-17</excludeDay> <excludeDay>2015-11-18</excludeDay> <excludeDay>2015-11-19</excludeDay> <excludeDay>2015-11-20</excludeDay> <excludeDay>2015-11-21</excludeDay> <excludeDay>2015-11-22</excludeDay> <excludeDay>2015-11-23</excludeDay> <excludeDay>2015-11-24</excludeDay> <excludeDay>2015-11-25</excludeDay> <excludeDay>2015-11-26</excludeDay> <excludeDay>2015-11-27</excludeDay> <excludeDay>2015-11-28</excludeDay> <excludeDay>2015-11-30</excludeDay> <excludeDay>2015-12-01</excludeDay> <excludeDay>2015-12-02</excludeDay> <excludeDay>2015-12-03</excludeDay> <excludeDay>2015-12-04</excludeDay> <excludeDay>2015-12-05</excludeDay> <excludeDay>2015-12-06</excludeDay> <excludeDay>2015-12-07</excludeDay> <excludeDay>2015-12-08</excludeDay> <excludeDay>2015-12-09</excludeDay> <excludeDay>2015-12-10</excludeDay> <excludeDay>2015-12-11</excludeDay> <excludeDay>2015-12-12</excludeDay> <excludeDay>2015-12-13</excludeDay> <excludeDay>2015-12-14</excludeDay> <excludeDay>2015-12-15</excludeDay> <excludeDay>2015-12-16</excludeDay> <excludeDay>2015-12-17</excludeDay> <excludeDay>2015-12-18</excludeDay> <excludeDay>2015-12-19</excludeDay> <excludeDay>2015-12-20</excludeDay> <excludeDay>2015-12-21</excludeDay> <excludeDay>2015-12-22</excludeDay> <excludeDay>2015-12-23</excludeDay> <excludeDay>2015-12-24</excludeDay> <excludeDay>2015-12-25</excludeDay> <excludeDay>2015-12-26</excludeDay> <excludeDay>2015-12-28</excludeDay> <excludeDay>2015-12-29</excludeDay> <excludeDay>2015-12-30</excludeDay> <excludeDay>2015-12-31</excludeDay> <excludeDay>2016-01-01</excludeDay> <excludeDay>2016-01-02</excludeDay> <excludeDay>2016-01-03</excludeDay> <excludeDay>2016-01-04</excludeDay> <excludeDay>2016-01-05</excludeDay> <excludeDay>2016-01-06</excludeDay> <excludeDay>2016-01-07</excludeDay> <excludeDay>2016-01-08</excludeDay> <excludeDay>2016-01-09</excludeDay> <excludeDay>2016-01-10</excludeDay> <excludeDay>2016-01-11</excludeDay> <excludeDay>2016-01-12</excludeDay> <excludeDay>2016-01-13</excludeDay> <excludeDay>2016-01-14</excludeDay> <excludeDay>2016-01-15</excludeDay> <excludeDay>2016-01-16</excludeDay> <excludeDay>2016-01-17</excludeDay> <excludeDay>2016-01-18</excludeDay> <excludeDay>2016-01-19</excludeDay> <excludeDay>2016-01-20</excludeDay> <excludeDay>2016-01-21</excludeDay> <excludeDay>2016-01-22</excludeDay> <excludeDay>2016-01-23</excludeDay> <excludeDay>2016-01-24</excludeDay> <excludeDay>2016-01-25</excludeDay> <excludeDay>2016-01-26</excludeDay> <excludeDay>2016-01-27</excludeDay> <excludeDay>2016-01-28</excludeDay> <excludeDay>2016-01-29</excludeDay> <excludeDay>2016-01-30</excludeDay> <excludeDay>2016-02-01</excludeDay> <excludeDay>2016-02-02</excludeDay> <excludeDay>2016-02-03</excludeDay> <excludeDay>2016-02-04</excludeDay> <excludeDay>2016-02-05</excludeDay> <excludeDay>2016-02-06</excludeDay> <excludeDay>2016-02-07</excludeDay> <excludeDay>2016-02-08</excludeDay> <excludeDay>2016-02-09</excludeDay> <excludeDay>2016-02-10</excludeDay> <excludeDay>2016-02-11</excludeDay> <excludeDay>2016-02-12</excludeDay> <excludeDay>2016-02-13</excludeDay> <excludeDay>2016-02-14</excludeDay> <excludeDay>2016-02-15</excludeDay> <excludeDay>2016-02-16</excludeDay> <excludeDay>2016-02-17</excludeDay> <excludeDay>2016-02-18</excludeDay> <excludeDay>2016-02-19</excludeDay> <excludeDay>2016-02-20</excludeDay> <excludeDay>2016-02-21</excludeDay> <excludeDay>2016-02-22</excludeDay> <excludeDay>2016-02-23</excludeDay> <excludeDay>2016-02-24</excludeDay> <excludeDay>2016-02-25</excludeDay> <excludeDay>2016-02-26</excludeDay> <excludeDay>2016-02-27</excludeDay> <excludeDay>2016-02-29</excludeDay> <excludeDay>2016-03-01</excludeDay> <excludeDay>2016-03-02</excludeDay> <excludeDay>2016-03-03</excludeDay> <excludeDay>2016-03-04</excludeDay> <excludeDay>2016-03-05</excludeDay> <excludeDay>2016-03-06</excludeDay> <excludeDay>2016-03-07</excludeDay> <excludeDay>2016-03-08</excludeDay> <excludeDay>2016-03-09</excludeDay> <excludeDay>2016-03-10</excludeDay> <excludeDay>2016-03-11</excludeDay> <excludeDay>2016-03-12</excludeDay> <excludeDay>2016-03-13</excludeDay> <excludeDay>2016-03-14</excludeDay> <excludeDay>2016-03-15</excludeDay> <excludeDay>2016-03-16</excludeDay> <excludeDay>2016-03-17</excludeDay> <excludeDay>2016-03-18</excludeDay> <excludeDay>2016-03-19</excludeDay> <excludeDay>2016-03-20</excludeDay> <excludeDay>2016-03-21</excludeDay> <excludeDay>2016-03-22</excludeDay> <excludeDay>2016-03-23</excludeDay> <excludeDay>2016-03-24</excludeDay> <excludeDay>2016-03-25</excludeDay> <excludeDay>2016-03-26</excludeDay> <excludeDay>2016-03-28</excludeDay> <excludeDay>2016-03-29</excludeDay> <excludeDay>2016-03-30</excludeDay> <excludeDay>2016-03-31</excludeDay> <excludeDay>2016-04-01</excludeDay> <excludeDay>2016-04-02</excludeDay> <excludeDay>2016-04-03</excludeDay> <excludeDay>2016-04-04</excludeDay> <excludeDay>2016-04-05</excludeDay> <excludeDay>2016-04-06</excludeDay> <excludeDay>2016-04-07</excludeDay> <excludeDay>2016-04-08</excludeDay> <excludeDay>2016-04-09</excludeDay> <excludeDay>2016-04-10</excludeDay> <excludeDay>2016-04-11</excludeDay> <excludeDay>2016-04-12</excludeDay> <excludeDay>2016-04-13</excludeDay> <excludeDay>2016-04-14</excludeDay> <excludeDay>2016-04-15</excludeDay> <excludeDay>2016-04-16</excludeDay> <excludeDay>2016-04-17</excludeDay> <excludeDay>2016-04-18</excludeDay> <excludeDay>2016-04-19</excludeDay> <excludeDay>2016-04-20</excludeDay> <excludeDay>2016-04-21</excludeDay> <excludeDay>2016-04-22</excludeDay> <excludeDay>2016-04-23</excludeDay> <excludeDay>2016-04-24</excludeDay> <excludeDay>2016-04-25</excludeDay> <excludeDay>2016-04-26</excludeDay> <excludeDay>2016-04-27</excludeDay> <excludeDay>2016-04-28</excludeDay> <excludeDay>2016-04-29</excludeDay> <excludeDay>2016-04-30</excludeDay> <excludeDay>2016-05-02</excludeDay> <excludeDay>2016-05-03</excludeDay> <excludeDay>2016-05-04</excludeDay> <excludeDay>2016-05-05</excludeDay> <excludeDay>2016-05-06</excludeDay> <excludeDay>2016-05-07</excludeDay> <excludeDay>2016-05-08</excludeDay> <excludeDay>2016-05-09</excludeDay> <excludeDay>2016-05-10</excludeDay> <excludeDay>2016-05-11</excludeDay> <excludeDay>2016-05-12</excludeDay> <excludeDay>2016-05-13</excludeDay> <excludeDay>2016-05-14</excludeDay> <excludeDay>2016-05-15</excludeDay> <excludeDay>2016-05-16</excludeDay> <excludeDay>2016-05-17</excludeDay> <excludeDay>2016-05-18</excludeDay> <excludeDay>2016-05-19</excludeDay> <excludeDay>2016-05-20</excludeDay> <excludeDay>2016-05-21</excludeDay> <excludeDay>2016-05-22</excludeDay> <excludeDay>2016-05-23</excludeDay> <excludeDay>2016-05-24</excludeDay> <excludeDay>2016-05-25</excludeDay> <excludeDay>2016-05-26</excludeDay> <excludeDay>2016-05-27</excludeDay> <excludeDay>2016-05-28</excludeDay> <excludeDay>2016-05-30</excludeDay> <excludeDay>2016-05-31</excludeDay> <excludeDay>2016-06-01</excludeDay> <excludeDay>2016-06-02</excludeDay> <excludeDay>2016-06-03</excludeDay> <excludeDay>2016-06-04</excludeDay> <excludeDay>2016-06-05</excludeDay> <excludeDay>2016-06-06</excludeDay> <excludeDay>2016-06-07</excludeDay> <excludeDay>2016-06-08</excludeDay> <excludeDay>2016-06-09</excludeDay> <excludeDay>2016-06-10</excludeDay> <excludeDay>2016-06-11</excludeDay> <excludeDay>2016-06-12</excludeDay> <excludeDay>2016-06-13</excludeDay> <excludeDay>2016-06-14</excludeDay> <excludeDay>2016-06-15</excludeDay> <excludeDay>2016-06-16</excludeDay> <excludeDay>2016-06-17</excludeDay> <excludeDay>2016-06-18</excludeDay> <excludeDay>2016-06-19</excludeDay> <excludeDay>2016-06-20</excludeDay> <excludeDay>2016-06-21</excludeDay> <excludeDay>2016-06-22</excludeDay> <excludeDay>2016-06-23</excludeDay> <excludeDay>2016-06-24</excludeDay> <excludeDay>2016-06-25</excludeDay> <excludeDay>2016-06-27</excludeDay> <excludeDay>2016-06-28</excludeDay> <excludeDay>2016-06-29</excludeDay> <excludeDay>2016-06-30</excludeDay> <excludeDay>2016-07-01</excludeDay> <excludeDay>2016-07-02</excludeDay> <excludeDay>2016-07-03</excludeDay> <excludeDay>2016-07-04</excludeDay> <excludeDay>2016-07-05</excludeDay> <excludeDay>2016-07-06</excludeDay> <excludeDay>2016-07-07</excludeDay> <excludeDay>2016-07-08</excludeDay> <excludeDay>2016-07-09</excludeDay> <excludeDay>2016-07-10</excludeDay> <excludeDay>2016-07-11</excludeDay> <excludeDay>2016-07-12</excludeDay> <excludeDay>2016-07-13</excludeDay> <excludeDay>2016-07-14</excludeDay> <excludeDay>2016-07-15</excludeDay> <excludeDay>2016-07-16</excludeDay> <excludeDay>2016-07-17</excludeDay> <excludeDay>2016-07-18</excludeDay> <excludeDay>2016-07-19</excludeDay> <excludeDay>2016-07-20</excludeDay> <excludeDay>2016-07-21</excludeDay> <excludeDay>2016-07-22</excludeDay> <excludeDay>2016-07-23</excludeDay> <excludeDay>2016-07-24</excludeDay> <excludeDay>2016-07-25</excludeDay> <excludeDay>2016-07-26</excludeDay> <excludeDay>2016-07-27</excludeDay> <excludeDay>2016-07-28</excludeDay> <excludeDay>2016-07-29</excludeDay> <excludeDay>2016-07-30</excludeDay> <excludeDay>2016-08-01</excludeDay> <excludeDay>2016-08-02</excludeDay> <excludeDay>2016-08-03</excludeDay> <excludeDay>2016-08-04</excludeDay> <excludeDay>2016-08-05</excludeDay> <excludeDay>2016-08-06</excludeDay> <excludeDay>2016-08-07</excludeDay> <excludeDay>2016-08-08</excludeDay> <excludeDay>2016-08-09</excludeDay> <excludeDay>2016-08-10</excludeDay> <excludeDay>2016-08-11</excludeDay> <excludeDay>2016-08-12</excludeDay> <excludeDay>2016-08-13</excludeDay> <excludeDay>2016-08-14</excludeDay> <excludeDay>2016-08-15</excludeDay> <excludeDay>2016-08-16</excludeDay> <excludeDay>2016-08-17</excludeDay> <excludeDay>2016-08-18</excludeDay> <excludeDay>2016-08-19</excludeDay> <excludeDay>2016-08-20</excludeDay> <excludeDay>2016-08-21</excludeDay> <excludeDay>2016-08-22</excludeDay> <excludeDay>2016-08-23</excludeDay> <excludeDay>2016-08-24</excludeDay> <excludeDay>2016-08-25</excludeDay> <excludeDay>2016-08-26</excludeDay> <excludeDay>2016-08-27</excludeDay> <excludeDay>2016-08-29</excludeDay> <excludeDay>2016-08-30</excludeDay> <excludeDay>2016-08-31</excludeDay> <excludeDay>2016-09-01</excludeDay> <excludeDay>2016-09-02</excludeDay> <excludeDay>2016-09-03</excludeDay> <excludeDay>2016-09-04</excludeDay> <excludeDay>2016-09-05</excludeDay> <excludeDay>2016-09-06</excludeDay> <excludeDay>2016-09-07</excludeDay> <excludeDay>2016-09-08</excludeDay> <excludeDay>2016-09-09</excludeDay> <excludeDay>2016-09-10</excludeDay> <excludeDay>2016-09-11</excludeDay> <excludeDay>2016-09-12</excludeDay> <excludeDay>2016-09-13</excludeDay> <excludeDay>2016-09-14</excludeDay> <excludeDay>2016-09-15</excludeDay> <excludeDay>2016-09-16</excludeDay> <excludeDay>2016-09-17</excludeDay> <excludeDay>2016-09-18</excludeDay> <excludeDay>2016-09-19</excludeDay> <excludeDay>2016-09-20</excludeDay> <excludeDay>2016-09-21</excludeDay> <excludeDay>2016-09-22</excludeDay> <excludeDay>2016-09-23</excludeDay> <excludeDay>2016-09-24</excludeDay> </excludeDays></reportJobCalendar>[/code]Appendix 2 - Bug with timezonesAs stated above, there is a bug within Jaspersoft/Quartz causing timezones to be applied twice. I have not been able to find a quitable fix within the code, as I am missing the sources of some critical components to properly debug this code. From what I have found, it appears the problem is around the HolidayCalendar object being created (or even stored in the database). This object contains a TreeSet of date objects, which have the time zone offset information populated. The bug appears to become problematic when converting this date object into a timestamp object (which is essentially just a long). Because the timestamp object has no timezone information, it converts the GMT stored time into the local time, adding the timezone offset. Then, later on, once that timestamp object has been used, it is once again converted into a date object, with the timezone infomration applied again. becasue we've applied the timezone offset tiwce now, the expected hours/minutes for the comparing objects are different (it's expecting all date objects to be 00:00:00.000, so it will match entire days, instead one of them has a timezone offset applied again).
  10. cameron_1
    I don't think there should be any difference between platforms, it's all about the configuration of Jaspersoft that impacts this... Can you provide some more info, like the version you're running, the platforms you're using, what exactly happens when you try to export (are you getting a stack track, or something in the log file?). It might be worth posting an entirely new question, instead of a reply to an answer to a question.
  11. cameron_1
    You should be able to put the exec sp_name <parameter1>, <parameter2> statement directly into the report query window (don't use the query designer as it doesn't work that well) -
  12. cameron_1
    Parameters are attached to the dataset, if you expand the dataset itself, you'll find a section there for parameters, just like in your main report. You'll need to link the parameters together though, using the connection properties where you're actually using the dataset, eg, in a chart or a table. For example, in the table, you go to the dataset tab of the properties pane, and click on the parameters button to map the parameters between your main report and your sub dataset.
  13. cameron_1
    You could do that using different reports and hyperlinks to each report. The hyperlink would pass through the parameters from the parent report (where applicable, such as the subject and dates), and pick up the student from the record in the report itself.
  14. cameron_1
    Just be aware if you're looking for Dashboards, what's available in the "Professional" edition may be a fair way away from what you'd expect from a paid Dashbaord product. Give it a trial first, before investing money, don't make the same mistake we did...
  15. cameron_1
    Hello, Working with iReport, we need to use a subreport in a main report that is greater than the width of the main report. Idea is - Main report is A4 landscape, most subreports are A4 landscape as well, however some are A3 landscape. How do we set up the report to expand the pages to A3 landscape, while keeping the rest of the report at A4 landscape?
  16. cameron_1
    I've found that Jaspersoft doesn't work well at all with anything less than IE9. Given that IE7 is now almost 7 years old, and is less than 1% of the worldwide market share, it's probably for the best (you can't expect them to support everything forever). Maybe time to upgrade to IE11?
  17. cameron_1
    So, I can see this has been marked as resolved and fixed, but I don't see this functionality at all in Jaspersoft Studio 5.5. Has this actually been resolved and fixed, or should it still be open?
  18. cameron_1
    Have you managed to find a resolution to this yet? Turning off pagination isn't really appropriate for larger reports where people want to view it both online and in CSV/XLS.
  19. cameron_1
    Hey, I just put together a wiki page on how to get this up and running in 5.5, it should work in 5.2 as well. - http://community.jaspersoft.com/wiki/use-pptx-exporter-jaspersoft-55
  20. cameron_1
    The current build of the PPTX exporter, PPTX Exporter Project, is built against verion 4.7.1 of Jaspersoft, not the latest version, 5.5. The instructions provided to compile from source, are also outdated, referencing changes needed in the Jasperosft source code. With 5.5, these changes are not necessary. These instructions should, in theory, also work for Version 5.0, 5.1 and 5.2, however they have not been tested. New JARThe attached JAR archive is a modified version of the original source. This has been compiled against version 5.5 of the Jaspersoft libraries, without any changes to the original (Jaspersoft) source code. The updated source files have also been attached if you find any bugs and need to recompile. This JAR should be placed in the webappsjasperserver-proWEB-INFlib directory Configure Jaspersoft ServerOnce you have the new pptx exporter library in place, you need to configure Jaspersoft to use it. This is done through the XML configuraiton files. Modify the following files, adding in or changing the supplied details webappsjasperserver-proWEB-INFapplicationContext.xmlAdd in the following bean, in the same location as the other <type>ExportParamaters beans <bean id="pptxExportParameters" class="com.jaspersoft.jasperserver.api.engine.jasperreports.common.PptxExportParametersBean"></bean>[/code]webappsjasperserver-proWEB-INFflowsviewReportBeans.xmlIn the <util:map id="exporterConfigMap"> section add in the following - <entry key="pptx" value-ref="pptxExporterConfiguration"/>[/code]In the "report<type>Exporter" bean section (just before the "reportExporter" bean itself) add in the following bean - <bean id="reportPptxExporter" class="com.jaspersoft.jasperserver.war.action.ReportPptxExporter" parent="baseReportExporter"> <property name="setResponseContentLength" value="true"/></bean>[/code]In the "<type>ExporterConfiguration" section add in the following bean - <bean id="pptxExporterConfiguration" class="com.jaspersoft.jasperserver.war.action.ExporterConfigurationBean" scope="prototype"> <property name="descriptionKey" value="jasper.report.view.hint.export.pptx"/> <property name="iconSrc" value="/images/pptx.png"/> <property name="exportParameters" ref="pptxExportParameters"/> <property name="currentExporter" ref="reportPptxExporter"/></bean>[/code]webappsjasperserver-proWEB-INFbundlesjasperserver_messages.propertiesAdd in the following property (can be anywhere, however putting it near the other "jasper.report.view.hint.export" properties would be sensible) - jasper.report.view.hint.export.pptx=As Powerpoint[/code]SchedulerThe previous method of adding new exporters in the reportJobBeans.xml file no longer works in version 5.5. with the new report scheduling interfaced intoduced in this version, it appears they hard coded a lot of the functionlity of the exporters, including areas like the jsp page to display the available exporters and the rest API that schedules the job and validates the options selected. If you are using version 5.2 you may be able to get this working using the old method. It is documented in the Jaspersoft Server Ulitmate Guide in section 11.10.3. The attached JAR archive should implement the correct interface as documented in step 1. Unfortunatley I've not been able to test this.
  21. cameron_1
    Surely that would be why you'd implement case/switch statements to keep your expressions from getting unwieldy? Right now the conditional operator get amazingly unusable after about 3 or 4 nested conditions.
  22. cameron_1
    Not sure if it's related (sorry dont' have a postgres DB handy to check against), but you can't use DDL/DML queries in MSSQL as well, unless you disable the SQL injection checks... That's done in the file apache-tomcatwebappsjasperserver-proWEB-INFclassesesapisecurity-config.properties change the following line to false - security.validation.sql.on=false
  23. cameron_1
    If you're still on 5.2 you can have a look at this for a starting point - http://community.jaspersoft.com/questions/818984/input-control-jsp-standard-draw-function If you're using 5.5, they changed the input controls in that version and none of what I've written before works anymore. Waiting for Jaspersoft to update their documentation (or wirte it to start with, more specifically).
  24. cameron_1
    1. Yup. 2. Ha! When have you seen Jaspersoft document anything useful??? 3. Verion 2.3.2, as of Jaspersoft Profession version 5.5 (Annoying Jaspersoft DIDN'T upgrade to the latest version of Highcharts when they moved to Version 5.5, or 5.2, or 5.1....) I use this for documentaion on Highcharts (and HTML5 charts in Jaspersoft) - http://api.highcharts.com/highcharts Generally most of the options here can be translated into "advanced parameters" in the HTML5 cahrt options in dotted formats, eg, to disable xAxis labels you'd create the advanced property xAxis.label.enabled and set the expression to be Boolean.FALSE. When setting parameter expressions, it accesses fields from the main report, not the sub dataset you're using to fill your chart.
  25. cameron_1
    I've asked the same question before and got a pretty blunt "No" response... Pretty hopeless, to be honest. The workaround I ended up doing was to create some new groups in AD and map the to JS roles, then login with say, 1 user who has every role assigned, get those AD linked roles set up in JS, then assign the permissions to those roles. Then when AD users login they'll get their roles assigned based upon their group memberships in AD. Downside of this is you need to maintain your Jaspersoft role membership in AD, instead of Jaspersoft. Depends on the kind of access you have to AD (or more specifically the kind of access your JS administrators have to AD), to decide if this is an acceptable solution.
×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore