SQL Statement doesn't work for Jaspersoft

[Ba Ma]

Hi Everyone, 

I am working on a report which should contain the data from the last month. I tried a SQL Statement in TOAD FOR MY SQL which retrieved the data,  I really needed. 

Afterwards i copied the statement in the Jaspersoft Tool and it results in an error:  

The error:

Multiple markers at this line:

-no viable alternative at input 'month'

- missing EOF at '-

 

The statement:

..select * from call_view where (create_month = month(NOW() - INTERVAL 1 MONTH) and (create_year = year(NOW() - INTERVAL 1 MONTH)));..[/code]

 

Would be awesome if anybody could help me out.

 

Thank you.

[hozawa]

Ignore the error and preview the report to see if the report renders. Jaspersoft Studio sometimes displays an error message. If you know the SQL syntax is correct, just ignore the message.

[kkriplani]

Make sure the connection is made between jaspersoft and Toad, also the necessary jars are deployed.
But as rightly pointed by Hozawa, jaspersoft gives some errors.

Thank you,
KKriplani