cpscdave
-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by cpscdave
-
-
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 egSELECT * 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
Same Report called with different DB's
in Products
Posted
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