Home » Developer & Programmer » Forms » Calling Reports from Forms
Calling Reports from Forms [message #238897] Sun, 20 May 2007 20:28 Go to next message
sarang.deshpande
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.
Thanks.
Re: Calling Reports from Forms [message #238979 is a reply to message #238897] Mon, 21 May 2007 01:53 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I see that you are cross-posting again.

Search this forum for 'run_report_object', there are many threads and lots of answers. You DO have to declare the parameters in report_writer if you use parameters, or access the globals in the triggers in the report-writer.

Read the documentation, its all there. Have you done the report-writer tutorial yet? Its on Oracle's website.

David
Previous Topic: ORA-01001 in WHEN-VALIDATE-ITEM PLEASE HELP
Next Topic: Issue in connecting with the database name
Goto Forum:
  


Current Time: Fri Dec 02 23:04:51 CST 2016

Total time taken to generate the page: 0.25235 seconds