jasperReport-reports /samples/ Freight

[Faabris]

Hi@all

I take a look at [root]/reports/samples/Freight and see at the SQLQuary:
...
WHERE
SHIPCOUNTRY = $P{Country}
and REQUIREDDATE > $P{RequestDate}
and ORDERID > $P{OrderId}

and in my jrxml file:
...
WHERE
geschlecht = $P{geschlecht}

but I get the following message:

(Error : SQLproblemsYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{geschlecht}' at line 6)

I upload the jrxml file and I get the following message:
[file name=error-27edcbe4685437ea66ce96f3e9a227d3.txt size=12499]

Can anyone help me?

Thans
Faabi
Post edited by: Faabris, at: 2008/02/25 09:50

[Faabris]

it work

he he :laugh: