[Error executing SQL statement]

Got it, the "names" dont need any kind of '', "" or []. Just the Strings need 'STRING'.

[Error executing SQL statement]

Hi,

i put in the Else-Value but theres always the error message again.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[Zahlungsart],

einzelaufstellung.Anzahl as [Anzahl der Aufträge],

einzelaufst' at line 7

[Error executing SQL statement]

already did

[Error executing SQL statement]

Hmm i'm not sure what can be wrong.

select CASE             WHEN einzelaufstellung.Zahlungsart = 'banktransfer' THEN 'Lastschrift'                 WHEN einzelaufstellung.Zahlungsart = 'eustandardtransfer' THEN 'Vorkasse'                 WHEN einzelaufstellung.Zahlungsart = 'invoice' THEN 'Rechnung'                 WHEN einzelaufstellung.Zahlungsart = 'paypal' THEN 'Paypal'                 WHEN einzelaufstellung.Zahlungsart = 'paypalexpress' THEN 'Paypalexpress'        END as [Zahlungsart],einzelaufstellung.Anzahl as [Anzahl der Aufträge],einzelaufstellung.Anzahl/gesamtzahl.Anzahl*100 as [Anteil der Aufträge in %],einzelaufstellung.Umsatz as [umsatz in EUR],einzelaufstellung.Umsatz/gesamtzahl.Umsatz*100 as [Anteil des Umsatzes in %]from( SELECT '1' as [joinid],         o.payment_method as [Zahlungsart],         count(o.orders_id) as [Anzahl],         sum(ot.value) as [umsatz]  FROM orders as o  LEFT OUTER JOIN orders_total as ot  ON o.orders_id = ot.orders_id and class = "ot_total"  LEFT OUTER JOIN customers as c   ON o.customers_id=c.customers_id  GROUP BY o.payment_method) as einzelaufstellungLEFT OUTER JOIN( SELECT '1' as [joinid],         count(o.orders_id) as [Anzahl],         sum(ot.value) as [umsatz]  FROM orders as o    LEFT OUTER JOIN orders_total as ot  ON o.orders_id = ot.orders_id and class = "ot_total") as gesamtzahl  ON einzelaufstellung.joinid = gesamtzahl.joinidorder by [Zahlungsart] ASC[/code]

[Error executing SQL statement]

Hallo,

 

always if i try to fill a report i get the "Error executing SQL statement" Message and i cant understand why.

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Reportname

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:482)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$18(ReportControler.java:457)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:347)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : faktura

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240)

at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1112)

at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:689)

at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1281)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:900)

at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFiller.run(BaseFillHandle.java:120)

at java.lang.Thread.run(Unknown Source)

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[Zahlungsart],

einzelaufstellung.Anzahl as [Anzahl der Aufträge],

einzelaufstel' at line 8

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.Util.getInstance(Util.java:386)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)

at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2323)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233)

... 6 more

 

Thanks for your Help.