cpscdave

figured it out by using $!P(DB) it outputs live_db if you use $P{DB} it outputs 'live_db' Post Edited by David Robertson at 11/26/08 23:23

We have a live and devel version of a system thats intergrating with JasperServer. Thusly we would like to be able to call the reports using either the devel database or the live databases with out having to have 2 versions of the report in JasperServer. How can this be accomplished? I tried adding a parameter to sepecify the database in the sql query eg SELECT * FROM $P{DB}.table1 but it looks like its making the sql SELECT * FROM 'live_db'. and throws errors. How can we get this to work??? Thanks

Hi again, The reports we're running via soap calls work fine. But when we try and output the report as HTML the report looks correct except all images are not there. Any idea what setting needs to be set/changed to get this to work?? Thanks again :D *EDIT* the url of the missing images points to /images/px Post Edited by David Robertson at 11/07/08 23:11

Okay for whatever reason the charts still do not work when I try and generate them via iReport->server connection. However it all works good via the soap calls which is what we care about so problem solved :D

Hi everyone, I built a report locally using iReport 2.0.1, and 3 subreports. The one subreport that just displays data runs fine on JasperServer. They all run with-out issue locally on my machine via iReport However the 2 subreports that use charts both throw errors and I have no idea why. We tried upgrading from JasperServer 2 to JasperServer 3 (whatever the most recent version is) The one chart is a pie graph and it gives the error: cannot assign instance of java.util.TreeMap to field org.jfree.chart.plot.PiePlot.explodePercentages of type org.jfree.util.ObjectList in instance of org.jfree.chart.plot.PiePlot3D java.lang.ClassCastException: cannot assign instance of java.util.TreeMap to field org.jfree.chart.plot.PiePlot.explodePercentages of type org.jfree.util.ObjectList in instance of org.jfree.chart.plot.PiePlot3D at java.io.ObjectStreamClass$FieldReflector.setObjFieldValues(Unknown Source)..... The other chart is a bar graph and it's giving the error: Error loading object from InputStream net.sf.jasperreports.engine.JRException: Error loading object from InputStream at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:196) at com.jaspersoft.jasperserver.irplugin.wsclient.WSClient.runReport(WSClient.java:316) at com.jaspersoft.jasperserver.irplugin.ReportRunner.run(ReportRunner.java:78) at java.lang.Thread.run(Unknown Source) Caused by: java.io.InvalidClassException: org.jfree.chart.plot.ValueMarker; local class incompatible: stream classdesc serialVersionUID = -7723230047083002786, local class serialVersionUID = -8443836095770227598 at java.io.ObjectStreamClass.initNonProxy(Unknown Source) Any suggestions as to what's going on would be greatly appricated spent all of yesterday bashing my head against the wall with these errors. -Dave