Oracle parameter form for reports - forms and reports 10g

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
LVL 6
anumosesAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
schwertnerConnect With a Mentor Commented:
There is WEB_SHOW_DOCUMENT builtin in Forms.
You can pass the parameters. Look  in the online help
for details and examples.
0
 
anumosesAuthor Commented:
thanks
0
 
schwertnerCommented:
Good luck!
There are many complaints about RUN_REPORT.
Be careful!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.