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:
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:
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');
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);
IF rep_status = 'FINISHED' THEN
/*Display report in the browser*/
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?
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.
October 11, 2015
View Thread Other 2 Replies on community.oracle.com
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.
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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