Robert_Pryde

Hi When I run my report from JasperServer the dates are displayed 1 day earlier than they appear when I run exactly the same query straight on my database. sql as follows: SELECT count(*) , customer, Date( despatchedScanDate ) AS desScanDate, despatchedScanlocation, consType, itemHistory.itemID, STR_TO_DATE( CONCAT( YEARWEEK( itemHistory.despatchedScanDate ) , 'Sunday' ) , '%X%V %W' ) AS DespatchedWeekCommencing FROM itemHistory WHERE despatchedScanDate BETWEEN $P{DATE_FROM} AND $P{DATE_TO} AND customer = $P{CUSTOMER} GROUP BY DespatchedWeekCommencing, despatchedScanlocation, consType, customer, desScanDate

Hi I am getting the following error when trying to run my report: Error filling print... Error creating scriptlet class instance : SpeedOfService2Scriptlet net.sf.jasperreports.engine.JRException: Error creating scriptlet class instance : SpeedOfService2Scriptlet at net.sf.jasperreports.engine.fill.JRFillDataset.createScriptlet(JRFillDataset.java:456) at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:592) at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:864) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:702) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:660) 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:815) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.IllegalAccessException: Class net.sf.jasperreports.engine.fill.JRFillDataset can not access a member of class SpeedOfService2Scriptlet with modifiers "" at sun.reflect.Reflection.ensureMemberAccess(Unknown Source) at java.lang.Class.newInstance0(Unknown Source) at java.lang.Class.newInstance(Unknown Source) at net.sf.jasperreports.engine.fill.JRFillDataset.createScriptlet(JRFillDataset.java:448) ... 9 more Print was not filled. Try using an EmptyDataSource... Robert

The method I have used to do this is to put each subreport in it's own header and then set the "Min height to start new page", in the Add/Modify options, to highest length possible on my page (A4=842).

Hi I need to display different information in the page footer at the end of a group compared to other pages in the group. Not sure how to identify the end of a group in the print when expression. Any ideas welcome Rob

thanks

Hi I need to display a barcode in the footer of my report only on the last page of a group, before the page resets. Any Ideas welcome.