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

[1437697007]

 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