Jump to content
Changes to the Jaspersoft community edition download ×

Error generating report


rafagirl586

Recommended Posts

Good afternoon!

I'm reviewing a report and I can't run it because it has the following message:

converted-file.png.6e76522abf9612321d3ed6523247a586.png

The report's main query has a filter similar to the one shown below:

SELECIONE ID, RECEIVEDDATE

DA PURCHASE_ORDER

WHERE RECEIVEDDATE BETWEEN TO_TIMESTAMP('2021-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') 
    AND TO_TIMESTAMP('2023-05-18 23:59:59', 'YYYY- MM-DD HH24:MI:SS')

When I run this query through pgadmin there are no execution failures.

Thanks in advance to anyone who can help.

 

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...