We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

How can i call report from Oracle form 10g?

tinhlahan
tinhlahan asked
on
Medium Priority
4,683 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
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008

Commented:
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.

Author

Commented:
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.
CERTIFIED EXPERT
Top Expert 2008
Commented:
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


Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.