?
Solved

Oracle parameter form for reports - forms and reports 10g

Posted on 2009-07-10
3
Medium Priority
?
454 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
0
Comment
Question by:anumoses
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 1500 total points
ID: 24825777
There is WEB_SHOW_DOCUMENT builtin in Forms.
You can pass the parameters. Look  in the online help
for details and examples.
0
 
LVL 6

Author Closing Comment

by:anumoses
ID: 31602197
thanks
0
 
LVL 48

Expert Comment

by:schwertner
ID: 24829444
Good luck!
There are many complaints about RUN_REPORT.
Be careful!
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup
Suggested Courses

800 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