Not getting Reports Parameter Form in web-forms environ

Advertisement

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
mode?
2. How do you set it up to work, if it is supposed to work?
Thanks for any replies.
null

Advertisement

I guess you have to use web.show_document - I found this article
on DevConnect:
Article-ID: <Note:68647.1>
Circulation: PUBLISHED (EXTERNAL)
Platform: GENERIC Generic issue
Subject: How to show Reports HTML PARAMFORM when
calling Reports
from Forms
Modified-Date: 09-AUG-1999 18:02:04
Document-Type: BULLETIN
Content-Type: TEXT/PLAIN
Impact: MEDIUM
Component: SQLREP
PURPOSE:
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.
DESCRIPTION:
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.
INSTRUCTIONS:
The following items need to be installed:
1. Oracle Reports Multi-tier Server.
2. Oracle Reports Web Cartridge
or
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:
http://your_webserver/r30ows?
server=repserver21+report=emp_30.rep+
destype=cache+desformat=html+userid=scott/[email protected]+paramform=ht
ml
For CGI implementation:
http://your_webserver/your_vir_cgi_dir/r30cgi32.exe?
server=repserver21+report=emp_30.rep+destype=cache+desformat=html
userid=scott/[email protected]=html
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
RUN_PRODUCT.
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. */
WEB.SHOW_DOCUMENT('http://your_webserver/r30ows?
server=repserver21+report=emp_30.rep+destype=cache+desformat=html
userid=scott/[email protected]=html', '_self');
/* OR for CGI configuration. */
WEB.SHOW_DOCUMENT
('http://your_webserver/your_vir_cgi_dir/r30cgi32.exe?
server=repserver21+report=emp_30.rep+destype=cache+desformat=html
userid=scott/[email protected]=html', '_self');
ELSE
/* use RUN_PRODUCT for client-server with PARAMFORM=Yes. */
Add_Parameter(plid, 'PARAMFORM', TEXT_PARAMETER, 'YES');
RUN_PRODUCT
(REPORTS,'emp_30.rep',SYNCHRONOUS,RUNTIME,FILESYSTEM,plid);
END;
RELATED DOCUMENTS:
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
run-
: product. I am getting error REP-0788: Warning the value of
the
: restricted LOV parameter is not among the selectable values.
: Any reports without a parameter screen work fine with run-
: product.
: Any help would be appreciated.
null

November 30, -0001

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 expli

Data not getting displayed in SNI monitor Web-UI screen

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

Calling Web Form from Client-Server Form

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

Attaching files to a web form

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

Oracle EBS Web Form (Query Only)

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

SRM 7.13 Web-Dynpro custom configuration is not getting delegated

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

No getting Report Output in OAF for java Concurrent program Method

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'

Web Report not working with parameter form

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

Passing a parameter list from a web form to a report

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

Urgent! Using Reports parameter forms with RUN_REPORT_OBJECT on 9iAS

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

REP-50134 occurs when using the submit button on the Reports Parameter Form

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

Getting started in Web Forms development.

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

Opening a separate form using Web.show_documen not working as intended

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

How to display  Reports parameter form in Oracle Forms 10g.

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

Forms 10.1.2.0.2: Web Form does not appear at Runtime with CALL_FORM

Hello there, We have a number of forms we're executing as web forms using Oracle JInitiator 1.3.1.22. 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

ODBC not working in WEB FORM(Dev6i)!!!

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

Reports 9i Printing from Forms with WEB.SHOW_DOCUMENT

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.

Getting error while trying to open the web forms in classic planning app

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

Muse/BC Bug: Secure page web form in BC gets deleted everytime I publish

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

WEB Forms do not display properly with windows 95 LARGE fonts desktop setting

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