Jump to content
Changes to the Jaspersoft community edition download ×

rcrom

Members
  • Posts

    5
  • Joined

  • Last visited

rcrom's Achievements

Rookie

Rookie (2/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. 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
  2. you might need to have the single quotes around your variables, if you're passing in numbers
  3. 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}');
  4. 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
  5. 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.
×
×
  • Create New...