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

I am using iReport version 2.0.2 I have created a report template file (.xml) which has been created to leverage an Oracle Stored Procedure Link to Stored proc code used. When I create a report based off of that template, I cannot seem to run the report using the "Execute (with active connection)" button. No output window is displayed. It seems like when I create a report based off a report with a Stored proc call, or try to make changes to the type of values returned from the Stored Proc call, that iReport will no longer run the report in the output window. I have verified that "Show Output Window" window does display. And sometimes (usually if it is the first report run in iReport after a reboot) I can get a report to display in the output window. So sometimes: - I can create a report based off my template and place a new Stored Proc in it, and run the report fine. - I can create a report based off my template and place a new Stored Proc in it, and the report will never return any results, nor will iReport say there was any error. iReport will just sit there staring back at me. - I can create a report from scratch and place the Stored Proc in it, and run the report fine. - I can create a report from scratch and place the Stored Proc in it, and the report will never return any results, nor will iReport say there was any error. iReport will just sit there staring back at me. - I can also take a report that works, and tell iReport to return an additional field from the database, and have the report fail with no error. Does this sound like an issue that anyone has heard of? I am rattling my brain trying to figure out what is going wrong. Even if there was a way to have iReport state what was going wrong with the report execution, that may help. Currently when iReport fails, it does so by saying nothing to me.