kschmitte

So, now I went little further with my investigations: 1) I needed to put the *.class and *.java files in the root of the JAR file. Otherwise the report could not be validated in JasperServer and the addition of the JAR was not successful. 2) I needed to add the iReport.jar to the Tomcat where I run JasperServer 2 on. But, then - again no way to get further: From iReport I get: java.lang.Exception: 1 - Report design not valid : 1. java.lang.ClassNotFoundException: QuarterlyExchangedMail_jrxml_1190130107948Scriptlet at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:382) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:299) at com.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:73) at java.lang.Thread.run(Unknown Source)This seems as if the mechanism of running reports from the PlugIn in iReport is not capable of using scriptlets. and in JasperServer the message is: java.io.NotSerializableException: net.sf.jasperreports.engine.design.JRValidationFault java.io.NotSerializableException: net.sf.jasperreports.engine.design.JRValidationFault at java.io.ObjectOutputStream.writeObject0(Unknown Source) at java.io.ObjectOutputStream.writeObject(Unknown Source) at java.util.ArrayList.writeObject(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) [...] Has anyone an idea how to get around this? Does this work at all? Or are scriptlets only for iReport exceution?

Hi all, I have created a report with a small scriptlet in iReport. Report runs fine in iReport. Now I want to deploy the report in JasperServer 2. But - I don't know how to connect the report to the scriptlet. I tried to put the scriptlet in a jar file and add the jar to the "Resources" section of my Report Unit. When I run this from JasperServer I get a message which doesn't help at all. When I run the report from within the iReport JasperServer plugin, I get the message that the class could not be found: java.lang.Exception: 1 - Report design not valid : 1. java.lang.ClassNotFoundException: quarterlyExchangedMailScriptlet A research in this forum showed me no helpful article. A restart of the machine JasperServer is running on (was needed anyway) did not change the behaviour. What am I doing wrong? Do I need to obey some naming schema? Or something else? Thanks for any help! Kai

Whatever this is good for, this long after the question was asked ... You can open any of the templates in your iReport install dir /templates with iReport itself. Editing is done like creating any other report. Then save your edited template under a different name - and there you are. Cheers, Kai

Whoever may be interested - here is my scriptlet code - sorry for my "bad" Java: Code: import net.sf.jasperreports.engine.*; public class quarterlyStdReport_TableSubScriptlet extends it.businesslogic.ireport.IReportScriptlet{ public Integer myLastValue = new java.lang.Integer(0); /** Creates a new instance of JRIreportDefaultScriptlet */ public quarterlyStdReport_TableSubScriptlet() { } public Integer getLastValue(Integer nextValue) throws JRScriptletException { Integer i = myLastValue; myLastValue = nextValue; return i; } public Double getPercentage(Integer nextValue) throws JRScriptletException { Double currentLine = new java.lang.Double(nextValue.doubleValue()); Integer i = myLastValue; myLastValue = nextValue; Double percentage = new java.lang.Double(0); if (i != 0) { percentage = new java.lang.Double(((currentLine.doubleValue() - i.doubleValue()) / i.doubleValue()) *100); } else {percentage = new java.lang.Double(0);} return percentage; }

Hi all, I was successful in creating a scriptlet showing the data for the last row - as well as creating a method to calculate the percentage change. It work fine for one of my columns. But, I'm getting 10 values from my query, and I would need the percental deviation to the previous row for each of them. Unfortunatly the above described method only works for one of my columns - if I add additional columns to hold the percental deviation for the other values, I get some kind of chaos figures, as the described method always stores the data of the last execution (which then leads to a in-row calculation). Is there a way to really get the last value for a given field? Thanks for your help! Kai

Hello lucianc, thank you very much for this detailed answers! I will try this within the next week and inform about the outcome. Additionally I have created an Enhancement Request for this one: Artifact artf2385 : Add a constant value to fill Report Parameters Kai

OK, I might have been not exact enough ;) What I tried so far: 1) Create a Datatype & an Input Control - this always uses the Parameters default value when I run the report. 2) Create a List of Vlaues (with only one value) + an Input Control - the same result as above. What I'm looking for, - is a kind of constant to set my parameter while running the report from JasperServer (best: connected to the report execution, not to the resource jrxml) OR - the same as above, only while running from within IReport OR - is a possibility to have different standard values for parameters dependant on the running place. Thanks for your help! Kai

Hello all, I'm facing the following issue: There are quite a few reports with included subreports which I need to develop (in iReport). When I then import them into JasperServer, I need to change the parameter holding the path to the subreport. As I don't want to keep differnet versions of the report, and also don't want to type in the report name each time I execute it, I decided to create a subreport connection as follows: $P{SUBREPORT_DIR} + "reportName." + $P{Extension}. This allows me to define the parameters before the execution. Now my question (which is general and not only restricted to my use case above): How can I define a static value which will be passed to my report as parameter (value)? So, as an example: The above mentioned Parameter should get the value "repo:". How can I assign this value to the report parameter in JasperServer?

Needing to step forward, I decided to install JS 2.0 manually. Worked fine after exploding the WAR file to find config issues - although a manual for the manual installation (enhanced chapter 7: "Database Configuration") would be really nice. Thanks for your help! Kai

Hello shija03, thanks for your help. Seeing that there are not only few tables & statements containing these table names (in lower case) in my export file, I decided to create a whole new (2.0) installation - and export & re-import the reports only... Again - thanks for the help! Kai

Hello tkavangh, do you mean the path length issue for the sample data? Or are there other restrictions also? I have already read http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=&func=view&catid=10&id=22080. And, I was able to install JasperServer 1.2.1 without the smaple data on the same machine using the embedded MySQL and Tomcat. My current aim is to install JS on the same machine again - but now with a seperate MySQL (which is regularly backed up) and on the tomcat which is running as W2K service. Will there be any compatibility issue, or can I set up & run JS on W2K in this setup? (If I use a manual install) Thanks for your help! Kai

Hello Shija03, thanks again for your quick response! Unfortunatly I can access the (remote) DB from my local machine - at least with my SQL client (Aqua Data Studio). May there any incompatibility? Maybe in the MySQL version I use? Thanks for any help! Kai

Hello shija03, thanks for these answers! Comparing the DBs really showed a difference - and it did not need WinMerge ;( The tables I see in my db are all lower case (on W2K). But the SQL tries to access jasperserver.QRTZ_LOCKS. Accessing the table with upper case while the table is stored as lower case works on Windows - but not on Linux (where my copied DB lives). Unfortunatly I was not able to find a tool converting all the table names in the export from lower to upper case. Are there any Ideas to get around this? Otherwise I would export my reports and newly install 2.0 - once I get the installer connecting to my DB... Thanks for your help!

I just downloaded the JS 2.0 installer to my W2K (as I had the same issue with the not able to connect to DB with the 1.2.1 installer) and tried to install JS on an exosting MySQL db on a foreign machine. Login, IP and Port are correct, and a connection to this DB works. No changes in behaviour - the installer tells me that he cannot connect. Why does this fail? Do I really need to install manually? Or is there any workaround and I was too blind to see the thread? Thanks! Kai Schmitte

Hi shija, swood, thanks for this help! Export & Import export seems to work, but ... I'm not able to start JasperServer on this DB. When I change my "apache-tomcatwebappsjasperserverMETA-INFcontext.xml" to use the newly created DB, I get the following error message: 11:35:59,773 ERROR ContextLoader,Thread-1:205 - Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'quartzScheduler' defined in ServletContext resource [/WEB-INF/applicationContext-report-scheduling.xml]: Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'jasperserver.QRTZ_LOCKS' doesn't exist [see nested exception: java.sql.SQLException: Table 'jasperserver.QRTZ_LOCKS' doesn't exist]] Caused by: org.quartz.SchedulerConfigException: Failure occured during job recovery. [see nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: Table 'jasperserver.QRTZ_LOCKS' doesn't exist [see nested exception: java.sql.SQLException: Table 'jasperserver.QRTZ_LOCKS' doesn't exist]] at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:493) at org.quartz.impl.jdbcjobstore.JobStoreCMT.initialize(JobStoreCMT.java:144) at org.springframework.scheduling.quartz.LocalDataSourceJobStore.initialize(LocalDataSourceJobStore.java:133) Does anyone know how I get around this issue? Remarkable is, that I get the same error in 2 occasions: 1) When I try to run the existing JasperServer installation on the new DB 2) When I try to run my new JasperServer WAR installation on the old (embedded) DB . Any help would be appreciated! Thanks! Kai Post edited by: kschmitte, at: 2007/06/29 10:01

Hi all, is there a way to get my current data out of the embedded MySQL DB (from a standard installation on W2K)? Use case is a migration of the data from a test system to a "productive" server... Thanks for your help! Kai Schmitte

Hello Sherman, thanks for the quick answer. Removing the "/" did it ... It looks now as following: "repo:mysubreport.jrxml" I guess this is the only notation I didn't try ...) Thanks, Kai Post edited by: kschmitte, at: 2007/06/14 17:12

Hello All, Although I have read the current discussions for Subreports and the "Access is denied" error message when running a report with a subreport, I'm not able to get it running as I want to have it / would expect to get from the manual... I have a simple report as Report Unit & a simple subreport in the Resources folder of the Report Unit. I reference it with the subreport expression "repo:/Test/testreport/Resources/subreport.jrxml" with /Test as a folder in the root directory /testreport as the report unit /Resources as the std. Resources folder of the report unit /subreport.jrxml as the name of my subreport When I put the subreport in the folder /Test it works ... Thanks for any help! Kai Schmitte

OK, thanks - I should have taken a deeper look first. :blush: For the convenience of any later reader - this article "http://ensode.net/jasperreports_intro.html" helped to solve my problems. Kai

Hello, I wasn't able to find any helpful information on the web yet - so any help is appreciated :) I have successfuly created a fine report (with iReport). Now I want to run this report and create a PDF out of it (to be called by a cron-job). Where do I find any information on this (easy?) task? I have so far no Idea on coding Java (but Python and C++ so Java is only a slight issue). Isn't there somewhere on the web a tutorial for these "standard" tasks with JasperReports - or can anyone of you help me with a short introduction? Thanks for your help! Kai Schmitte

I'm stuck at a complex report - maybe I just need an idea how to commence ... What I'm trying to do: There is a list of datasets in the details band from the original Report wizard (so the detail and column header & Footer bands are filled). Now I want to display general information above this "table". To get the data I introduced 3 subreports showing one number each and assigning this number to a variable. But - where do I put this data? I tried to add it to the header band. Fine - data was displayed. Unfortunatly, the variables where not filled - the content is "null" (the variables are needed to sum up the single numbers from the subreport). I guess, that the calculation and the subreport run are not handled in a top-down order in the report, so that the calculation with the variables is done at a time when there is still no data in the variables. Can anyone help me, how to design a report like this correctly? I just need to show some general figures and below this a detailed view of my data. Thanks for your help! Kai Schmitte