Jump to content
Changes to the Jaspersoft community edition download ×

cameron_1

Members
 View Profile  See their activity

  • Posts

    75

  • Joined

  • Last visited

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

cameron_1's Achievements

Enthusiast

Enthusiast (6/14)

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

Recent Badges

0

Reputation

3

Community Answers

  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?
×
×
  • Create New...

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

Products

Explore