Jump to content
Changes to the Jaspersoft community edition download ×

really struggling including date selection in report HELP PLEASE


george_17

Recommended Posts

Hi all

in sheer frustration i stripped my query into simple terms...

steps

i created the report initially without the where statement just to make sure all data was generated...

then i created a Parameter renamed it as Message and set datatype to java.sql.Date

the date_added field on the database is datetime the content looks like 22/08/17 10:30

but this sql  select order_id, comment, date_added from oc_order where cast($P(Message) as datetime) > date_added

asks me to select a date from thecalendar 01/08/17 but pressing the run button i get

error generating report

and in the error log i get exception error executing sql statement for 1.

 

I am hoping someone can make some suggestions as to what i am doing wrong....

 

thanks very much

 

george

 

 

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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...