Gaby38

I think that you get a blank page due to a real overflow : is the last object of your last band at the bottom of it? Is there not a blank space after the last object of your last band?

I have a custom landing page which is a standard report. This report queries the jasperserver database to retrieve reports and analysis views that I display. I have hyperlinks on this report list, so users can launch them by clicking. To do that, instead of launching the repository tree, I launch a clone of the "viewReportFlow" in which I set my report as parameter. It's a little more complicated than your solution, but it allows to define "rights" on directories and reports according to the user logged in and so to display only relevant reports and analysis views.

You can also use the "trigger" mechanism of your rdbms, if any. I use that in a commercial product managing children inscriptions to activities. I put in place a trigger on insert into the table "inscription" and everytime a new record is inserted I check if the max number of allowed children is reached. In your case, you could use PL/SQL packages to send mail if there is an alert detected by your trigger. This should not be very difficult to put in place by people aware of triggers and pl/sql programming (in my case I have an oracle database)

As for me, jasperserver is not the best tool to do what you want, because it has not been designed for that. But it contents a functionnality that could be interesting for you : the scheduled reports. You can design reports and scheduled them to be run at chosen frequency. The results of the reports are sent by mail to a list of mail addresses. Moreover, if there are no results (blank page), you can tell jasperserver not to send any mail. So, in your case, you could have one or several dedicated scheduled reports, running adequate queries against your database to detect alarms. If no alarm, no result so no mail is sent. As soon as an alarm is detected, the query returns the details of the alarm that can be sent to dedicated people. You could decide to run "alarm reports" every hour for instance, or once a day, or ... But in this case, you couldn't have a "user-friendly frontend to define the criteria and design the alert mails" . You should use the tools to create reports as iReport which is a generic tool for designing jasperreport reports. This solution is not the best one but it could be set very quickly, let's say a week, by people aware of jasperreport and your database.

You can also do the conversion in sql and get directly the number of the month in the query. I already did that in Oracle : i presume there are equivalent functions in other rdbms.

AS I previously said, I use a report as home page. This report works on the metadatabase. In this metadatabase, you can retrieve the reports and so list them. In fact, i Use the rights by user to list only the reports that are allowed for this user. I agree with you that, for standard users, the repository tree may be confusing. I prefer present them the list of reports they can see and with hyperlink mechanism they can run these reports.

Are your mail addresses (if there are several) separated by comas and not semi-columns ?

As far as I remember, it was : jasperreports-3.7.3.jar jasperreports-fonts-3.7.3.jar jasperreports-chart-themes-3.7.3.jar (?)

One possibility is to upgrade the jasperreport jar in jasperserver with that in iReport. I did it sometimes ago but I got some other troubles in other parts of the report ( lucian had said that there could be some problems doing that on one of my posts). It worked for the table object but I came back to the standard configuration and I'm waiting for the next release of jasperserver.

Some time ago, I asked on this forum if it was possible to update records via jasperreport. I was answered "No, it is not possible". But I did some tries and finally found it was possible by using a "stored function" (I am running Oracle Database) which contents the update statements and returns anythinh like 0 or "OK". The "main query" of the report just makes a call to this function. By using sub reports or datasets in the right order it should be possible to sequence the queries in order to get the aimed result. I tested and it was working but finally I didn't use. All that to say that it is possible to update records but using this capability to solve your problem seems rather complex. Perhaps this will help you

First thing : are you sure that the sub-reports are working fine? That is, are they working if you test them as Main reports ?? If they are working, then your troubles may come from the parameters you are passing to them when they are sub-reports. Have you done the right mapping. To be sure of that, print the parameters in the sub reports : as there is blank page, use the "nodata" section to put your parameters in and set the right property for the main report to have the nodata section printed when the query returns nothing. This might help you to identify your problem

I noticed that Palette doesn't appear at each time. It seems that , in order to appear , Palette needs to have a jrxml loaded in the designer. After that, if it doesn't appear, I click on "Windows" menu in iReport then "Palette" (or Ctrl+Maj+8).

I already had to add extra "total" (percentage) in a crosstab. I did it by adding a new "Measure" element in the crosstab with the Report inspector and I defined this new measure as a percentage. I put it (drag and drop) in the same column than the total: in that column I had two "Measure elements" : the total (defined by wizard) and my new "percentage" measure

Yes, The original size of "DefaultParametersForm.jsp" is 22150 and the size of the new downloaded is 22839. Since the download, all has become as previous. I forgot : you have to restart jasperserver Post Edited by Gaby38 at 07/15/2010 20:26

Hello, I use jasperserver CE. So when I wrote that I downloaded and that was working fine, it was with jasperserver CE.. As far as I remember there was no special thing to take care of.

I remember that I got some trouble with modifications of login page. It seemed that they were without effect. I had to delete the jasperserver directory in the "work/Catalina/localhost" directory of Tomcat.

Hello Marc, As far as I remember, I already used date parameters to get a list of values for another parameter via a query. I don't remember if that was a single-select or multi-select query but this was working fine. But, in a general way, to have cascading controls working fine I'm obliged to define define default values for parameters used by other parameters (for instance for a date : have to-day date) Post Edited by Gaby38 at 06/29/2010 20:48

I just got the error I spoke about. In fact it is not exactly the same exception libel : I apologize. A s I said, I ran a report, then left to do other things. When I came back and wanted to re-run the report, I was asked to authenticate and after authentication, I got the following error. After that I cannot do anything and have to quit I put the error trace here after Code:java.lang.IllegalArgumentException: An id is required to lookup a FlowDefinition at org.springframework.util.Assert.hasText(Assert.java:162) at org.springframework.webflow.definition.registry.FlowDefinitionRegistryImpl.getFlowDefinition(FlowDefinitionRegistryImpl.java:56) at org.springframework.webflow.executor.FlowExecutorImpl.launchExecution(FlowExecutorImpl.java:138) at sun.reflect.GeneratedMethodAccessor341.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy17.launchExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:193) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:146) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)

What I do in this case is to put the report as a sub-report in another "main" report, and in this main report, the query "calculates" in sql the right dates which are passed as parameters for the sub-report. For instance, you can schedule this main report to be run the 1st of each month and have for the query (Oracle database): select sysdate as DayDate from dual You will get in the field DayDate "01/06/2010" the 1st of June, "01/07/2010" , the 1st of July ((French dates) and so on.. You just have to map your $P{DayDate} parameter in sub-report to the field $F{DayDate} of the main report

Kristen, What I want to say is : in previous releases, after getting a time-out session, I was obliged to authenticate and after that I went back in jasperserver where I was before, let us say in the report's list and I could now re-launch the same report or launch another report. With the 3.7 release, after getting a session time-out, I have to authenticate, as before, but I cannot launch any report. I am obliged to do "exit", to authenticate once more and after that I am in the standard situatuion from jasperserver point of view. This is not a severe error. I noticed that in the first days I used 3.7 but I never put anything in the tracker because it is not blocking.

Lucian, It's not exactly I wanted to say : the session time-out doesn't occur while a long report is running but because I didn't work with Jasperserver. As far as I remember, I run a report, then I leave jasperserver as is. When I come back and want to relaunch the same report by clicking on the same link, then I get the "NoSuchConversationException" and I cannot do anything than "exit". After re-logging, all works fine. As I said this error appeared with the 3.7 release Post Edited by Gaby38 at 06/16/2010 19:10

I verfied on one of my servers. I still have 2 running jasperservers : one communitiy edition named jasperserverce and a pro release (evaluation) with standard names. The first step to go through is having the existing release running after change of name and all stuff linked to that.

Have a look at $tomcat/conf/Catalina/localhost : if there is a jasperserver.xml file you have to edit this file and do the same modifications as in context.xml on jdbc/jasperserver database parameters. Before editing don't forget to stop tomcat. Have you "renamed" your mysql database? Did you copy the content of the previous mysql database using js-export.sh and js-import.sh scripts?

I recently installed a jasper-pro release on the same server than my jasperserver ce release. This is the same principle to have to releases of jasperserver pro co existing Two things are needed : have a different name for the directory under webapps in tomcat and have separate metadatabase. What I should do id I were you is: - first to rename your existing jasperserver directory under tomcat/webapps (jasperserver_3.0 for instance), rename the metadatabase jasperserver as "jasperserver30" for instance (this needs to create new database with this name, export the existing and import in the new : see in mysql "rename database"). Have this new context running as before. - And after install the new release in a standard way by reusing existing tomcat and mysql. Of course there are some modifications to be done in META_INF/context.xml to take into account the new names. Post Edited by Gaby38 at 06/09/2010 21:52

I forgot to say that I am using Google chrome as browser to access jasperserver. So I tried with Firefox and with this browser all is working fine. Sorry for the trouble : it's not strictly a jasperserver problem (chrome is not in the list of supported browsers)