?
Solved

How can i call report from Oracle form 10g?

Posted on 2006-11-06
3
Medium Priority
?
4,348 Views
Last Modified: 2009-12-23
I have a button in form, has been created from Oracle form 10g but i don't know how to call the report has supported by Oracle 10g from that button. Please help me call a report from that button.
Thanks very much
0
Comment
Question by:tinhlahan
  • 2
3 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 17880337
Create the button and provide it with WHEN-BUTTON-PRESSED trigger (see online help)

After that invoke RUN_REPORT_OBJECT builtin. There is a plenty of examples in the Forms onlone help.
0
 
LVL 1

Author Comment

by:tinhlahan
ID: 17886462
Could you show any examples or code example from button? more importantly, it have to run on Oracle Form 10g. And when we used it, the OC4J must be RUN. It mean call Dll through J2EE. That is a problem, how can i call a report throught a button.
0
 
LVL 48

Accepted Solution

by:
schwertner earned 500 total points
ID: 17888868
1. Create  BUTTON item in your Form.
2. Normally it will have WHEN-BUTTON-PRESSED trigger, but if not - add this trigger.

http://www.oracle.com/technology/products/forms/pdf/10g/frmrepparamform.pdf

http://www.orablogs.com/fnimphius/archives/000943.html


0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question