rcrom
-
Posts
5 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by rcrom
-
-
you might need to have the single quotes around your variables, if you're passing in numbers
-
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}');
-
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 datesI'm lost where to go next and any help would be great.Thanks in advance -
Did you ever find out an answer? I have the same behaviour and the only way I found to get around this was by adding the equations from the calculated fields into the new equation.
Crosstab Question
in Products
Posted
I have a crosstab that will only return two rows, but has a dynamic count of columns. Instead of summing the two values in each column, I want to create a percentage by dividing the one value by the other. How can I do that