We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Oracle parameter form for reports - forms and reports 10g

anumoses
anumoses asked
on
Medium Priority
473 Views
Last Modified: 2013-12-19
I have a params form where the user defines report parameters for the report registered. This forms works fine.
Now I need to design a params report form where the user when clicks on the report in the oracle application menu, a param form comes up and displays fields where values can be entered for the parameters defined already in params form. Then te user has to run the report. Report pulls data for the parameter values entered. How to design this? Any design help or document . I have database table that stores param_name, data-type (varchar2,date,number) initial_value( eg for start_date - select trunc(sysdate) from dual)
Now my problem how to design the params report form. I am attaching a screen print to show hopw parameters are entered when registering. Now I need to create a form to run report based on these parameters. How to design
Doc2.doc
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
thanks
CERTIFIED EXPERT
Top Expert 2008

Commented:
Good luck!
There are many complaints about RUN_REPORT.
Be careful!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*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.