drewmcfarland Posted July 7, 2008 Share Posted July 7, 2008 I have a report with 2 subreports. Each subreport needs to have the same Date parameter value passed to it. I have tested all the report queries in Oracle and they all accept a DATE parameter. In the main report, I have a parameter called [pDate], with a class of [java.util.Date], with Use as Prompt turned on, and with a default value of [new java.util.Date()]. In the main report, I have set the subreports properties to pass a parameter called [pDate] using the expression [$F{PDATE}]. Each of the subreports has the same parameter settings as the main report. But, when I try to run the report in iReport I keep getting an error [java.sql.SQLException:ÂORA-06553:ÂPLS-306:ÂwrongÂnumberÂorÂtypesÂofÂargumentsÂinÂcallÂtoÂ'SUBREPORT1'] If I run the subreports by themselves, they work. What I can't tell is whether iReport is passing the DATE from the main report as a different type to the subreports, or if iReport is simply not passing the DATE field to the subreports. Has anyone experienced a similar problem?Post edited by: drewmcfarland, at: 2008/07/07 17:10 Link to comment Share on other sites More sharing options...
yskripch Posted July 15, 2008 Share Posted July 15, 2008 i believe u need the following expression when passing parameters. $P{pDate} and not $F{pDate} $F means you are passing the field value and not the parameter value. Hope this helps. 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