twohandsgaz

HI All. I have a report containg one main report and 4 subreports, Data is retrieved from four sources and there is one parameter required at the very begining. As you can see from the attcahed screenshot, the subreports are there but the error seems to be saying there not!!! Confused. Any ideas are gladly received. :) Thanks for your help guys n girls. Code:error as follows  Compiling to file... C:\Documents and Settings\john.doe\Local Settings\Temp\jstmp\file_1302535113428.jasper  Compiling subreports....  Unable to locate the subreport with expression: ""repo:Surveyor_main_info_screen_subreport1.jrxml"".java.lang.Exception: repo:Surveyor_main_info_screen_subreport1.jrxml not found.     at com.jaspersoft.ireport.designer.utils.Misc.locateFileFromExpression(Misc.java:1373)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.compileSubreports(IReportCompiler.java:1403)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:517)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)  Filling report...  Locale: English (United Kingdom)  Time zone: DefaultAdded additional parameters.Error filling print... Could not load object from location : repo:Surveyor_main_info_screen_subreport1.jrxml Setting up the file resolver... Added file resolver... Resource Surveyor_main_info_screen_subreport1.jrxml not found in the report unit at /reports/Support_Tools/Surveyor_Info net.sf.jasperreports.engine.JRException: Could not load object from location : repo:Surveyor_main_info_screen_subreport1.jrxml     at net.sf.jasperreports.engine.util.JRLoader.loadObjectFromLocation(JRLoader.java:262)     at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateReport(JRFillSubreport.java:301)     at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluateSubreport(JRFillSubreport.java:327)     at net.sf.jasperreports.engine.fill.JRFillSubreport.evaluate(JRFillSubreport.java:263)     at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258)     at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2033)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupFooter(JRVerticalFiller.java:925)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillGroupFooters(JRVerticalFiller.java:791)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:299)     at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:135)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)     at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:877)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Print not filled. Try to use an EmptyDataSource...

Hi, Have you added the same parameters in Jasperserver? Are you sure the report produces data?

I have ireport 3.7.4 with compatibility turned back to 3.6.2, The report is then displayed via jasperserver 3.7 community edition. The main report has 4 subreports with one parameter passed through the subreports, taking data from 3 data sources. When the report is previewed in ireport it works all day long. When the report is previewed in ireport via "run report unit" it runs once perfectly, but then subsequent attempts to run it produces errors java.lang.Exception: 1 - Error executing SQL statement for : Surveyor main info screen at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) In Jasperserver the error is, com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error executing SQL statement for : Surveyor main info screen VERY VERY Frustrating. I have tried to save the report in various versions all to no avail. Any help would be greatly appreciated. Post Edited by twohandsgaz at 07/22/2010 08:24