Calling a Report from a Form

Advertisement

I have uploaded my form to the app server and compiled to Linux. I have copied my RDF file to the reports_path/demo directory. I can run the report via a link from our portal using the URL as follows:
/reports/rwservlet?report=IndRpt.rdf&desformat=pdf&destype=cache&userid=' target="_blank"
That opens the report in a separate window, which is what we want. So far, so good.
I can run the form via a link from our portal as well using the URL as follows:
/forms/frmservlet?config=bsc_ind
The config section hides all the form parameters very nicely.
In the portal, I created a Report Server Access portlet, REP_OMHAST2_MIDTIER, and use the following set_report_object calls in my form:
repid := find_report_object('IndRep');
SET_REPORT_OBJECT_PROPERTYrepid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTYrepid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTYrepid,REPORT_SERVER,'rep_omhast2_midtier');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,ls_param);
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP
rep_status := report_object_status(v_rep);
END LOOP;
IF rep_status = 'FINISHED' THEN
/*Display report in the browser*/
WEB.SHOW_DOCUMENT('http://omhast2.omh.state.ny.us:7777/reports/rwservlet/getjobid'||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=rep_omhast2_midtier ','_blank');
All that comes right out of the white paper.
Now here's the weird part, I have never seen this before. When I click my "Show Report" button in my form, the report seems to be running, but then I get a very strange dark grey, square icon superimposed over my mouse pointer. The icon has a small yellow "starburst" pattern with a tiny red exclamation point inside. The report does not appear on screen.
Incidentally, all of this works correctly when I run the same scenario on my workstation using the call to rwserver as: rwserver server=rep_omhast2_midtier. But when we port it to the app server, it does not run. I think it has to be in the way the form calls the report because the report will run as a stand-alone object.
Anything apparent to anyone out there?

Advertisement

Well, it looks like I stumped the band. And with good reason. Sorry for the error. The problem was that the user running the form and the report had a pop-up blocker that was blocking the report. The form and the report ran from another machine. I allowed pop-ups from the report's URL and that enabled the report to appear.
So, here we have another example of how to call a report from a form. Again, I am sorry for any angst this may have caused.

October 11, 2015

Calling a Report from a Form

I have uploaded my form to the app server and compiled to Linux. I have copied my RDF file to the reports_path/demo directory. I can run the report via a link from our portal using the URL as follows: /reports/rwservlet?report=IndRpt.rdf&desformat=pd

Calling Crystal Reports from Oracle Forms 10G

Hi everyone, I am trying to call a crystal report from Oracle Forms 10G. I have a button on my Form which when clicked calls a Crystal Report which the uaser then wants to save as a PDf file. Can someone please send me the code to do this and also th

Calling a report from a form based on procedure

I created a form based on a procedure. It is a entry form where the user is selecting or enters data then on submit I must display the report based on selected data. I know I can simply create a report with all bind variable and do the job. My questi

FRM-41214 when calling a report from a form in DS1012

This is weird. I have a report that contains a lexical parameter that is intended to add an "AND" clause to the WHERE so I can use the same report to do an unrestricted query or a restricted query. To do an unrestricted query, this works fine: l

Error in calling a report from a form

in the button trigger i wrote: DECLARE      RAP REPORT_OBJECT;      VRAP VARCHAR2(100);      BEGIN RAP:=FIND_REPORT_OBJECT('myreport'); VRAP:=RUN_REPORT_OBJECT(RAP); END; the error message is REP-0503: you did not specified the name of a report. the

Simplest Way 2 Call a report from Forms 10g

Hello, i am using Oracle 10g & tools 10g too, What i am trying to do is to call a report from a form... So one friend told me 2 use a library exists in Folder Forms90 called " rp2rro"on the installed developer10g tools,i am using the followi

How to call a report in a form

dear sir I am new to form and report 9i I am calling a report from a form by using run_report_object I am not geting properly please help meRespected Sir, I just write the message i am geting FRM - 41219 : cannot find report : invalid id I am having

Issue calling report from a Form(11.1.2).

Hi, I have an existing code in the form to call a report and it seems to be working in the current 10g version of production server and I am migrating forms 10g to 11gR2. My issue here is when, I want to call the report from Forms 11g ( i.e. in devel

Calling Report From Oracle Forms

Hi I am calling this one report from oracle forms, I am using global temporary table to run that report. I am first inserting data into the temporary table through oracle form and then i am calling report in that form to view the data in that tempora

How to invoke crystal reports from Oracle forms 11g R2 along with passing p

How to invoke crystal reports from Oracle forms 11g R2 along with passing parameter to it. how to pass parameters to crystal report, please help.how to pass parameters to crystal report, please help.This would entirely depend on crystal reports and y

Problem while running the report from a form

Hi, I am able to call a report from forms9i using run_report_object. This report just has a boilertext within it. I did this just to check the functionality of run_report_object built-in. This worked perfectly. But when I am trying to call a report b

Out put file is not genrated when calling xml reports from OAF page

Dear all i am calling xml reports from OAF page the out put file is not generated i am writing this code public int tradingrequest(String quoid, String costoder,int orgid) try OADBTransaction tx = (OADBTransaction)getOADBTransaction(); java.sql.Conne

CALL a report from WDA using SUBMIT to sap-spool

Hi, I need to call a report from one of the methods of a WDA application. The out of this report is a sapscript. I want show it in WDA (PDF). The report is called when a user clicks EXECUTE button. The piece of the code is:   call function 'GET_PRINT

How Can I call Crystal report from R3?

Hi experts,   How Can I call Crystal report from R3?Hi Bill, Can you please be specific and could you please provide the steps Thank youRead other 5 answers

Calling Sql*Loader from oracle Form builder

How do i call sql* loader from my forms to import the external data in different formats into my existing database? Specify the flexibility of sql* loader to import external data from .txt files or .xls files. Would be thankful if certain examples ar

Calling a Report from Jsp

dear all.... I am trying to call a report, from a JSP page, that's th steps i did: 1- I created the report with Oracle Reports 2- I saved it as .jsp 'Wos.jsp' 3- I integrated it in a new project, under Jdevelopper, i added the library, reports_tld.ja

Unable to call a report from form.

Hi i've facing a problem like calling a report(rdf 10g developer) from a form(fmb 10g developer) in 11g database (LINUX) show FRM-41214: Unable to run report. But in 10g Database it's running nicely. If u have a solution plz provide me. It's urgent.H

Urgent: Calling Reports from Oracle Forms 10g (10.1.2.0.2) fails

Problem displaying a report from within Oracle 10g forms. After a lot of work, we are able to access and actually display a report directly from Internet explorer and view the report from the report server as well. The successful url was: http://york

Invalid ID calling report from oracle forms 10 G

Hi, I have a problem during calling a report object 10g from a FORM, the source code is below the message, an the error message is can't not find PLAN_FUZZY (my report module name)...... WHY ??? DECLARE      repid REPORT_OBJECT;      v_rep VARCHAR2(1

Calling a report from designer genareted form

i will appraciate if anyone can tell me how to create a form module that navigate to a report module in 9i designer.i tried action item but i receieved couple of different error messages.i have also tried to find information on this but i couldnt tha