flycast

Yep...that makes sense. Thanks

I have two MySQL timestamps (start and end date) and I am trying to put the number of hours that has elasped between starting and ending. When I do math like this: $F{completionDate} - $F{startDate} I get an integer result in days (0,1,2...). I want to display in hours (2.3h, 8.75h, 43h). I have been looking for documentation on the expression editor, not sure if it uses java, groovy or something else. Can someone please point me to: 1) How to get the number of hours 2) Tutorials/documentation on the expression editor. Thanks...

So...no answers on this? Is it possible to have a report accessable to anyone without a username/password?

Report access without logging in? 07/27/2012 14:22 I am new to Jasper iReport and Jasper Server. I have iReport 4.6 and JasperServer 4.5.0 and all seems to be running fine. I am hoping that I can author reports and giver the organization access to these reports (run only) so they could go to a simple internal web page and click a link to see a report with the latest data. I have made a simple report and can view it when I log into the server as the administrator. I have found this post http://community.jaspersoft.com/questions/518244/ireport-url-access and have tried running the report with this url: but I get a "You are not authorized" message. I set up a user with the un/pw of anon/anon and given them and many different combinations of priveleges including administration priveleges. Even so I still get the same not authorized message. All I really want to do is have a simple link to a report that runs the report transparently in the background and displays the most recent information without having to take the user to Jasper Server is possible. Is this possible? I was hoping that a report can be exported into a "live" format that is accessable from a simple url likehttp://server:8080/jasperreports/thereport. Possible?

I did not start jasper reports properly - the database server was not bring started. Thanks for the help!

I am new to Jasper iReport and Jasper Server. I have iReport 4.6 and JasperServer 4.5.0 and all seems to be running fine. I am hoping that I can author reports and giver the organization access to these reports (run only) so they could go to a simple internal web page and click a link to see a report with the latest data. I have made a simple report and can view it when I log into the server as the administrator. I have found this post http://community.jaspersoft.com/questions/518244/ireport-url-access and have tried running the report with this url: http://server:8080/jasperserver/flow.html?_flowId=viewReportFlow&reportUnit=/reports/sl24&j_username=anon&j_password=anon but I get a "You are not authorized" message. I set up a user with the un/pw of anon/anon and given them and many different combinations of priveleges including administration priveleges. Even so I still get the same not authorized message. All I really want to do is have a simple link to a report that runs the report transparently in the background and displays the most recent information without having to take the user to Jasper Server is possible. Is this possible? I was hoping that a report can be exported into a "live" format that is accessable from a simple url like http://server:8080/jasperreports/thereport. Possible?

Yep. My connection is being refused. Thanks for the pointer in the right direction. Looking through the logs I can see that the querys ran OK. Checking the port it has the postmaser bound to it. This is on a machine at home with the sole purpose of helping me learn more about Tomcat and Jasper. I'll work on and see what I can learn.

I have gained access to the Tomcat manager and see that the jasperserver app is listed but is not started. when I try to start the all I get the following (and a whole bunch more) in the log files: catalina.out log: and catalina.2012-07-22.log Code:catalina.out log:2012-07-22 17:02:55,553 WARN JDBCExceptionReporter,http-8080-1:100 - SQL Error: 0, SQLState: null2012-07-22 17:02:55,558 ERROR JDBCExceptionReporter,http-8080-1:101 - Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)2012-07-22 17:02:55,560 WARN SettingsFactory,http-8080-1:133 - Could not obtain connection to query metadataorg.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)and catalina.2012-07-22.logJul 22, 2012 5:02:59 PM org.apache.catalina.core.StandardContext startSEVERE: Error listenerStartJul 22, 2012 5:02:59 PM org.apache.catalina.core.StandardContext startSEVERE: Context [/jasperserver] startup failed due to previous errorsJul 22, 2012 5:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [Thread-13] but has failed to stop it. This is very likely to create a memory leak.Jul 22, 2012 5:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_Worker-0] but has failed to stop it. This is very likely to create a memory leak.Jul 22, 2012 5:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.Jul 22, 2012 5:02:59 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.Jul 22, 2012 5:03:30 PM org.apache.catalina.core.StandardContext startSEVERE: Error listenerStartJul 22, 2012 5:03:30 PM org.apache.catalina.core.StandardContext startSEVERE: Context [/jasperserver] startup failed due to previous errorsJul 22, 2012 5:03:30 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [Thread-16] but has failed to stop it. This is very likely to create a memory leak.Jul 22, 2012 5:03:30 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_Worker-0] but has failed to stop it. This is very likely to create a memory leak.Jul 22, 2012 5:03:30 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_Worker-1] but has failed to stop it. This is very likely to create a memory leak.Jul 22, 2012 5:03:30 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreadsSEVERE: The web application [/jasperserver] appears to have started a thread named [quartzScheduler_QuartzSchedulerThread] but has failed to stop it. This is very likely to create a memory leak.

On Ubuntu server 12.04. I have a working tomcat installation. When I install Jasperserver using the 32 bit linux jasperserver the installation asks for the folder where the current tomcat-apache is in. My tomcat is installed at /opt/tomcat. I could not find any folder or file called "apache-tomcat" I attempted the install using "/opt/tomcat" and install bundled Postgre database. Tomcat runs fine but when I load localhost:8080/jasperserver I get: HTTP Status 404 -type Status report message description The requested resource () is not available. Apache Tomcat/6.0.35I am learning about tomcat and jasperserver. I am trying to use the existing tomcat because I already have BonitaSoft running on a tomcat instance and would like to use the same one. Any help would be appreciated.