Getting SQL exception "Error executing SQL statement for"

I am trying to display jasper reports inside of a website using JSP. I have a form which lets users specify between two dates they want to view the report, and then build the query in the JSP. I have the query itself as a parameter for the report so it knows what to query for in the database. I debugged what the actual query I get is and ran it and the query works. Any ideas?

Thanks