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
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 #238911 is a reply to message #238898] Sun, 20 May 2007 23:37 Go to previous message
janu
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.

Regards,

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 17:31:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.