passing parameters

[drewmcfarland]

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

[yskripch]

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.