Passing Parameters to proc in Jaspersoft Studio

Posted on September 26, 2016 at 2:53pm

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
 
 
Jaspersoft® Studio
rcrom's picture
rcrom
3
Joined: Jun 23 2016 - 7:14am
Last seen: 4 years 6 months ago
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}');
rcrom - 6 years 6 months ago

Exec GetPivotForSponsorDataReview('$P!{crId}','$P!{sponsorId}','$P!{siteId}');  this is not working for me, can you help?

Vishnuprasadkv760 - 6 years 5 months ago

you might need to have the single quotes around your variables, if you're passing in numbers

rcrom - 6 years 5 months ago
add comment

0 Answers:

No answers yet
Feedback
randomness