Home » Developer & Programmer » Reports & Discoverer » Calling Reports from Forms
Calling Reports from Forms [message #238898] Sun, 20 May 2007 20:29 Go to next message
Messages: 5
Registered: November 2006
Location: Pune
Junior Member

Dear All,
I have a form containing two fields Department_ID and Job_ID.
I want these values to be passed to the report which will select data from database on the basis of the values in Department_ID and Job_ID
and display it. All this should be done on the button pressed on the form.
I have tried to write When-Button-Pressed trigger on form level. In it I have declared global variables which will fetch values from Department_ID and Job_ID and I am using run_report_object built in for calling report but the problem is
1) I am unable to determine whether the values of Department_ID and Job_id are passed to the report select query? and
2) how to navigate to the report?
Please reply me on this mail_id sarangd.211@gmail.com
Waiting for your reply.
Re: Calling Reports from Forms [message #238911 is a reply to message #238898] Sun, 20 May 2007 23:37 Go to previous message
Messages: 4
Registered: January 2007
Junior Member
Hi Saranag,

I did not try with run_report_object, but i have used the run_product and executed the report.

You can find the required information and example in form help.
check for run_product built in.

Previous Topic: group headings
Next Topic: How to print even no.of pages in Reports6i
Goto Forum:

Current Time: Sun Oct 23 11:34:25 CDT 2016

Total time taken to generate the page: 0.04823 seconds