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.

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 08 23:51:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.