jimh_1

Thanks for all your help with this, I have now managed to get it all to work correctly... ....Now on with the other issues!!

I have got the Lag function within the query working perfectly, but I am still struggling with the script for the Print When Expression. I have tried: $F{CONSIGNMENT}!=$F{CONSIGNMENT2} Boolean(${CONSIGNMENT}.notequal(${CONSIGNMENT2})) Boolean(${CONSIGNMENT}.equals(${CONSIGNMENT2})) I must be writing this script incorrectly but I have been unable to find out how it should be phrased... .... Any ideas?

I will try that and will update the thread with what happens... ....Just need to find out about the Lag function now!! Thank you very much for your help with this

A WMS called Red Prairie which is an Oracle SQL database... ... how would you specify a line being drawn within the query? Sorry if I am being obtuse!! Post Edited by jimh_1 at 07/28/2011 13:51

thats right yes, whenever the consignment changes, I want iReports to print a line so that it is easily identifiable. is this possible?

I have managed to resolve this issue now, the temp jasper folder was missing so the report couldnt find the sub-reports jasper file for it to print out the results.

Hi There, I am writing a report with a sub-report element in iReport, however, whenever I try to compile the report, I get the following error message: Error filling print... Could not load object from location : H:\JRTEMPLATES\Bin\sr_a_newsscclabel.jasper net.sf.jasperreports.engine.JRException: Could not load object from location : H:\JRTEMPLATES\Bin\sr_a_newsscclabel.jasper at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:266) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:308) at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:257) at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:275) at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:426) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillBandNoOverflow(JRVerticalFiller.java:424) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageHeader(JRVerticalFiller.java:388) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:249) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:891) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:795) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:944) at java.lang.Thread.run(Unknown Source) Print was not filled. Try using an EmptyDataSource... Does anyone have any ideas? Thanks in Advance Jim

Hi There, I hope you can help with this issue.... I am tying to use the Print When Expression option to print a line when the data within a field changes. I have never used Booleans before and it is confusing me, I have tried the following and none of them have worked!! $F{CONSIGNMENT}!=$F{CONSIGNMENT} Boolean($F{CONSIGNMENT}.equals($F{CONSIGNMENT})) Boolean($F{CONSIGNMENT}.notequal($F{CONSIGNMENT}))and various variations of the above. Does anyone have any ideas of what I am doing wrong and what needs to be done to make this work properly? I have had it suggested that the easiest solution is to create a sub-report which means that the Print When Expression is no longer required. If its possible I would rather use formatting of the report rather than create a sub-report as that seems tedious for what the report actually shows, particularly when if this works the way I believe it should do.... Thanks in Advance of any adivce... Jim Post Edited by jimh_1 at 07/28/2011 12:41 Post Edited by jimh_1 at 07/28/2011 12:45