Not getting Reports Parameter Form in web-forms environ
I am not able to get a report parameter form to appear for a
report called from forms via a 'run_product' command. It works
fine in client/server mode. In web-forms the report just goes
ahead and runs without the needed parameters. I have tried
explicitly passing a parameter list with the 'paramform' set to
'yes' and this did nothing. I have this on a NT box with latest
Dev2 patches applied.
1. Is the reports parameter form supposed to work in web-forms
2. How do you set it up to work, if it is supposed to work?
Thanks for any replies.
I guess you have to use web.show_document - I found this article
November 30, -0001
View Thread Other 5 Replies on community.oracle.com
Circulation: PUBLISHED (EXTERNAL)
Platform: GENERIC Generic issue
Subject: How to show Reports HTML PARAMFORM when
Modified-Date: 09-AUG-1999 18:02:04
This bulletin explains how to overcome the current restriction
of calling an Oracle Report from Oracle Forms and showing a
PARAMETER FORM. This is currently not possible when using the
RUN_PRODUCT built-in with
WEB DEPLOYED APPLICATIONS.
When you call an Oracle Report from Oracle Forms using
RUN_PRODUCT in Client-server, you can specify an optional
parameter called PARAMFORM to display the parameter form defined
in the Oracle Report.
For web-deployed applications, the PARAMFORM parameter can be
set to HTML to produce a HTML version of the parameter form.
When calling Oracle Reports from an Oracle Form using
RUN_PRODUCT and specifying PARAMFORM=HTML in the parameter list,
the Oracle Reports parameter form doesn't show the in the client
browser. If the Oracle Reports Cartridge/CGI is used and
PARAMFORM=HTML is specified, then the Oracle Reports parameter
form does appear in the client browser.
Oracle Forms does not use either the Cartridge or the CGI with
RUN_PRODUCT, and it's these thin clients that produce the HTML
Oracle Reports parameter form.
As a workaround to this problem, you can use either the
Cartridge or the CGI with the WEB.SHOW_DOCUMENT Oracle Forms
builtin. This does require either the Oracle Reports Cartrige
or the CGI to be installed. Neither of these are necessary if
the parameter form isn't required.
The following items need to be installed:
1. Oracle Reports Multi-tier Server.
2. Oracle Reports Web Cartridge
Oracle Reports Web CGI.
Here is a typical URL that can be specified in a browser
to run a report using Oracle Reports Cartridge implementation:
For CGI implementation:
The Oracle Reports parameter form now is shown. This can be
used with WEB.SHOW_DOCUMENT issuing the request to execute the
report to the Oracle Reports Multi-Tier Server instead of using
The following code may be added to a program unit, which then
issues the request to run the report:
IF get_application_property(user_interface) = 'WEB' then
/* Use Cartridge configuration with WEB.SHOW_DOCUMENT. */
userid=scott/[email protected]=html', '_self');
/* OR for CGI configuration. */
userid=scott/[email protected]=html', '_self');
/* use RUN_PRODUCT for client-server with PARAMFORM=Yes. */
Add_Parameter(plid, 'PARAMFORM', TEXT_PARAMETER, 'YES');
Developer/2000: Guidelines for Building Applications, Deploying
Applications on the Web (for detailed instructions on setting up
the Oracle Reports Cartridge and CGI)
Laura (guest) wrote:
: I am having the same problem with Dev 6 on NT. The parameter
: screen for reports works in client/server but not web using
: product. I am getting error REP-0788: Warning the value of
: restricted LOV parameter is not among the selectable values.
: Any reports without a parameter screen work fine with run-
: Any help would be appreciated.
I am not able to get a report parameter form to appear for a report called from forms via a 'run_product' command. It works fine in client/server mode. In web-forms the report just goes ahead and runs without the needed parameters. I have tried expli
Dear all, We are running the program ROEMPROACT2 in ECC to transfer planned independent requriement entered in MD61, the message ProductActivityNotification_In is successful in ECC and SNC. SLG1 shows warning message "Item 1: ShipFromLocation and Ven
Hi. I have an existing Client-Server Form (6i) still in production that needs to call a Web Form and pass it a parameter. Obviously I can't use Call Form or New Form from the client-server version, but can I somehow issue a command line (including a
please tell me how to attach files to a web form for uploading. i know how to make a page that just uploads a file. but before i do it, i have to attach files( sent by a pop-up window ) to a web form in a main window. There are some resources about u
Hi, I need to create responsibility in which all forms or web form should be query only. When i tried this with individual forms (QUEYR_ONLY="YES") its working but web form not working please guide how can i do with web forms. Regards Rehan87743
Hello Experts please help to solve my issue: SRM 7.13 I created a new configuration of a Wed-dynpro view to replace the original one. But for some unknown reason it is not getting delegated on the SRM web. Technical Help shows the original WDCONFIGUR
I am not getting report output for java Concurrent Program(Concurrent Program Executable Method), for the reports which are of type PL/SQL Stored Procedure getting the output. for some of the reports the executable method is 'java Concurrent Program'
Hi, I have a report which has got a parameter form. This report is running fine in client/server environment. But when I deploy the same report on web (CGI) using PARAMFORM=YES, I am getting the parameter form and after pressing the SUBMIT button I a
I am using FORMS6 and REPORTS6, with OAS 4.07 on NT4 (SP3). In client server mode all works well - i am able to pass parameter lists from my calling form to the relevant reports and view them (using RUN_PRODUCT). However, when i try and do the same b
Hi all, I am migrating client-server to 3-tier with 9iAS Rel2 on AIX 5.1. The forms and reports are upgraded from Forms4.5 to forms9i and Reprots 2.5. We used to have user defined parameter in parameter form(e.g. articale no.) to select records appea
Good Morning, I get the "REP-50134: Cache subitem reports does not exist" error after clicking on the Submit Button from a Reports parameter form. I am using Forms/Reprots 9i. Using the source code given in the Whitepaper 'Oracle Forms Services
Hi There, I hope this is the correct form to be posting in. Ok, I would like to get into developing Oracle web forms.. I'm not really sure if thats the correct name. Below is an image of exactly what I want to develop. It is loaded up through a Java
My intent is to open a form in a totally different session from another form. I want to open FORM B from a trigger in FORM A and I want both to be active simultaneously. To achieve that I thought to use web.show_document in completely new borwser win
hello, am migrating from Forms 6i applications to Forms 10g. one of my application contain report, that report display parameter form I wrote below code for WHEN-BUTTON-PRESSED Trigger DECLARE pl_id ParamList; v_report_id report_object; v_report
Hello there, We have a number of forms we're executing as web forms using Oracle JInitiator 22.214.171.124. We have one form in particular that, when a button is pressed, is supposed to call another form via the CALL_FORM built-in. We are passing a paramet
Hi : I found ODBC are not working in Dev6i Web Forms , my reports all based on excel though ODBC . Can anyone help me to solve this problem ? Help me !!!! Thanks in advenace !!!Answering Oracle Reports questions is a bit out of my league, but I deal
I want to print a Report from Forms via WEB.SHOW_DOCUMENT directly to the printer and it works fine. But every time i print it from my web application a new browser-windows opens and shows a message "Printed successfully" or something like that.
hello, I am new to OTN forum. can someone please help me to resolve my issue in classic planning application. i have created two web forms in classic planning . but while i am trying to open the web forms ,its showing the error like the" data form Re
I have a secure page signup form that I have placed using a content holder in BC and inserted in Muse. Every time I make correction in Muse and republish, the webform is deleted from the list webform at the BC side. This is the error I got when I tes
Hi, We are using WEB forms 6.0 patch level 6 (We tried 6i but had too many bugs with it, we prefer to wait until at least a couple of patches are out, installation was a VERY painful experience for us) We still have the following problem with WEB FOR