Oracle Reports (MOSC)

MOSC Banner

Dynamically displaying Parameter Form

edited Nov 10, 2009 4:12AM in Oracle Reports (MOSC) 2 commentsAnswered
I'm hoping that someone will be able to advise on this.

Is there a method for programatically identifying whether an Oracle Report contains a Parameter Form or not?

We have developed an Oracle Form to function basically as a menu.  It will display forms, reports, programs etc based on a users' access.  Both forms and reports are displayed using the command Web.Show_Document.

I have successfully managed to run reports with and without parameter forms.  To display the parameter form (on the web), it was necessary to hard code PARAMFORM=YES into the URL.  This worked fine when the report had a parameter form but didn't for non-parameter form reports.  I would like to be able to setup the URL so that the PARAMFORM=YES is only hard coded into the URL if the report has a parameter form.  Hence I would need to be able to identify whether the parameter form exists within a report.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center