Ba Ma Posted February 26, 2016 Posted February 26, 2016 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 Posted February 27, 2016 Posted February 27, 2016 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 Posted February 29, 2016 Posted February 29, 2016 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
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now