Solved

Oracle parameter form for reports - forms and reports 10g

Posted on 2009-07-10
3
452 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 500 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

695 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