rcrom Posted September 26, 2016 Share Posted September 26, 2016 Hi all,I have a report that is based on a stored proc that has two paramenters. Here's the sql that I'm using: SELECT * FROM test.www_report_func('20160901','20160930'); The two parameters are strings that represent start and end dates. If I have the paramenters hardcoded, the report runs fine and returns data and displays perfect. If I change it to SELECT * FROM test.www_report_func($P{startDate},$P{endDate}); I get an error that is:net.sf.jasperreports.engine.JRException: Error executing SQL statement for: WIP_Landscape3.Caused by: org.postgresql.util.PSQLException: ERRROR: Function test.www_report_func(caracter varying, character varying) does not exist.Hint: No function matches the given name and argument types. You might need to add explicit type casts. I created two parameters that are named startDate and endDate with the class of java.lang.String and when I run the report, I get a prompt to enter the two string dates I'm lost where to go next and any help would be great. Thanks in advance Link to comment Share on other sites More sharing options...
rcrom Posted September 27, 2016 Author Share Posted September 27, 2016 I figured it out! SQL was: SELECT * FROM test.www_report_func($P{startDate},$P{endDate}); now SELECT * FROM test.www_report_func('$P!{startDate}','$P!{endDate}'); Link to comment Share on other sites More sharing options...
Vishnuprasadkv760 Posted October 14, 2016 Share Posted October 14, 2016 Exec GetPivotForSponsorDataReview('$P!{crId}','$P!{sponsorId}','$P!{siteId}'); this is not working for me, can you help? Link to comment Share on other sites More sharing options...
rcrom Posted October 15, 2016 Author Share Posted October 15, 2016 you might need to have the single quotes around your variables, if you're passing in numbers Link to comment Share on other sites More sharing options...
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