In the development environment and the local environment, table connection and condition parameters can not exist at the same time

0

 sql:

select {c.pk} from {consignment as c 
left join order as o on {c.order} = {o.pk}
} where
{c.code} = $P{code}
 
problem:
 
Second lines and fourth lines can not run at the same time
 
The Exception:
 
 
net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Blank_A4_Landscape.
at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:530)
at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:505)
at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:386)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Blank_A4_Landscape.
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:344)
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)
 
Could you  give me a solution.
 
best regard
 
Arno
 
1437697007's picture
Joined: Oct 9 2016 - 4:34am
Last seen: 2 years 12 months ago

0 Answers:

No answers yet
Feedback
randomness