Home » Developer & Programmer » Forms » Problem calling Report from Form
Problem calling Report from Form [message #83565] Tue, 28 October 2003 07:15 Go to next message
Dave Manning
Messages: 6
Registered: October 2003
Junior Member
I have two Oracle 6i Reports that I want to call from an Oracle 6i Form. Both reports work ok and produce all expected data in Reports Runtime. If I call the reports from Forms Runtime, both reports are generated ok, but one of the reports has no data. I have checked that both Forms and Reports are connected to the same schema, and have also run the problem query in SQL+, where results are returned as expected.

Are there any recommendations as to what I could try next, or what the problem may be??
Re: Problem calling Report from Form [message #83587 is a reply to message #83565] Sun, 02 November 2003 03:31 Go to previous messageGo to next message
sameer_am2002
Messages: 129
Registered: September 2002
Senior Member
Can u send me that form and report to akil@taza.com.sa ...So i can fix it and send u back.
Re: Problem calling Report from Form [message #83589 is a reply to message #83587] Tue, 04 November 2003 04:03 Go to previous messageGo to next message
aamir
Messages: 5
Registered: August 2002
Junior Member
See the Folloing code

Run the report synchronously, passing the parameter list
*/
Run_Product(REPORTS, 'empreport', SYNCHRONOUS, RUNTIME,
FILESYSTEM, pl_id, NULL);
Re: Problem calling Report from Form [message #83729 is a reply to message #83589] Wed, 03 December 2003 17:48 Go to previous message
Lars O Sjöström
Messages: 25
Registered: May 1999
Junior Member
That code works for Oracle Forms 6i, but not for Oracle Forms 9i. But as long as you are in 6i you are fine.
Previous Topic: Forms 4.5/Oracle 9i
Next Topic: Cursor width in Forms
Goto Forum:
  


Current Time: Fri Apr 26 11:36:06 CDT 2024