Jump to content
We've recently updated our Privacy Statement, available here ×

Connection problem in subreport with main report


mail2vsdvg1

Recommended Posts

Hi,

I am working on Subreport. subreport is working fine, but when i call run the main report, error is generated.

I clicked on Subreport go to Subreport properties in that Connection Expression:

$P{REPORT_CONNECTION}

The above expression in it display in Red color.

Help me to solve this problem.

 

Thanks,

vs

 

 

 

Code:
  Compiling to file... E:\iReports\MySQL Reports\salesslip.jasper  Compiling subreports....  Subreport E:\iReports\MySQL Reports\SalesSlip_subreport1.jrxml already compiled.Compilation running time: 968!   Filling report...  Locale: English (United States)  Time zone: DefaultError filling print... net.sf.jasperreports.engine.JRException: Incompatible java.lang.Integer value assigned to parameter SalesNo in the SalesSlip_subreport1 dataset. net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Incompatible java.lang.Integer value assigned to parameter SalesNo in the SalesSlip_subreport1 dataset.      at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:659)      at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:327)      at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:402)      at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:361)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2013)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:749)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:252)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:110)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:923)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826)      at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:59)      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:858)      at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)      at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)  Caused by: net.sf.jasperreports.engine.JRException: Incompatible java.lang.Integer value assigned to parameter SalesNo in the SalesSlip_subreport1 dataset.      at net.sf.jasperreports.engine.fill.JRFillDataset.setParameter(JRFillDataset.java:900)      at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(JRFillDataset.java:639)      at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:581)      at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1246)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)      at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:565)      at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59)      at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:205)      at java.lang.Thread.run(Thread.java:595)  Print not filled. Try to use an EmptyDataSource...
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...