| Run Report 10g from Form 10g [message #413936] |
Sun, 19 July 2009 06:59  |
sazzadur
Messages: 9
Registered: January 2009
Location: UK
|
Junior Member |
|
|
I am using Form and Report version 10g R2.
I have 2 tables, for example Employee and employee_details. They have common column named empid.
I created a form, named form1, for Employee table and a report, named report1, for Employee_details table.
I want to call report1 from form1 with empid.
Form1 has employee data block.
In Form1, I write the following code in the WHEN-BUTTON-PRESSED trigger:
:GLOBAL.empid:=:EMPLOYEE.empid;
I need to write the code here to run the report.
How can I call or run a report from the form? The report report1 should run with this global variable empid. In report the query should be as follows:
select * from employee_details where empid:=:GLOBAL.empid.
Is it possible to run the report like this way? What is the easiest way to do it?
|
|
|
|
|
|
| Re: Run Report 10g from Form 10g [message #413948 is a reply to message #413939] |
Sun, 19 July 2009 10:33  |
sazzadur
Messages: 9
Registered: January 2009
Location: UK
|
Junior Member |
|
|
When I run a report in web from report builder, it shows in the browser as follows:
C:\Temp\docroot\MODULE5006005276.htm.
I never find or get 'http://host:8889/reports/rwservlet/'..
If I want to use web.show_document, how can I find reports service? I am confused.
I installed developer 10g, where I can start Form service. But I never find Report server seperately.
What should I do?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
