Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle parameter form for reports - forms and reports 10g

Posted on 2009-07-10
3
Medium Priority
?
457 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
  • 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

824 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