Home » Developer & Programmer » Forms » RUN_REPORT_OBJECT is not working, Please Help. (Developer Suite, 10g, XP)
RUN_REPORT_OBJECT is not working, Please Help. [message #343071] |
Tue, 26 August 2008 03:51 |
m_golam_hossain
Messages: 89 Registered: August 2008 Location: Uttara, Dhaka, Bangladesh
|
Member |
|
|
Hi,
I have
a form c:\testdir\forms\test4.fmb/fmx and
a report c:\testdir\reports\test4.rdf/rep
both created in developer 6i.
I installed developer suite 10g.
I re-compiled both the form and report in developer suite 10g.
To run the report from the form I have written code as below:
DECLARE
Repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := FIND_REPORT_OBJECT('c:\testdir\reports\test4');
v_rep := RUN_REPORT_OBJECT(repid);
END;
While running the above mentioned codes shows error FRM-41219: Can not find report: Invalid ID.
My OC4J is running. I am sure the form and report exist in the specified locations.
It may be mentioned that I also tried to use the form compilation time auto generated code
rp2rro.rp2rro_run_product(reports,:GLOBAL.REPORTDIR||'\test4',SYNCHRONOUS,runtime,filesystem,PL_ID,null);
Whereas global variable :GLOBAL.REPORTDIR:='c:\testdir\reports\';
I had previously copied rp2rro.pll and EnableDisableItem.pll files in forms directory c:\testdir\forms\.
I would be very much gratefull if someone can please help me to run the report in paper layout showing complete trigger.
Kind regards to the answer provider.
G. Hossain
|
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343131 is a reply to message #343071] |
Tue, 26 August 2008 06:50 |
Kaeluan
Messages: 179 Registered: May 2005 Location: Montreal, Quebec
|
Senior Member |
|
|
Your problem is with the command Find_report_object. You are not using the good parameter.
In Form Builder 10g, you need to define the report. If you look in the object navigator you will see a new section called Report. In this section create a new report and set the filename to your report. See attached print screen
So when using FIND_REPORT_OBJECT, you will have to use this name instead of the path you actually used
repid := FIND_REPORT_OBJECT('TEST_REPORT');
|
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343142 is a reply to message #343131] |
Tue, 26 August 2008 07:43 |
m_golam_hossain
Messages: 89 Registered: August 2008 Location: Uttara, Dhaka, Bangladesh
|
Member |
|
|
Dear Kaeluan,
I have tried your suggestion that worked well. But, there comes another problem
REP-0110: Unable to open file la.
REP-1070: Error while opening or saving document.
please see attachment.
I have also tried with PREVIEW option in addition to FILE option in report destination.
Please help me.
G. Hossain
-
Attachment: error.JPG
(Size: 78.85KB, Downloaded 2077 times)
[Updated on: Tue, 26 August 2008 08:14] Report message to a moderator
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343160 is a reply to message #343071] |
Tue, 26 August 2008 08:49 |
Kaeluan
Messages: 179 Registered: May 2005 Location: Montreal, Quebec
|
Senior Member |
|
|
Here is something you may try on your trigger
DECLARE
Repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := FIND_REPORT_OBJECT('REPORT5');
set_report_object_property(repid, REPORT_EXECUTION_MODE, BATCH);
set_report_object_property(repid, REPORT_SERVER, 'rep_synntm172_fr');
set_report_object_property(repid, REPORT_COMM_MODE, SYNCHRONOUS);
set_report_object_property(repid, REPORT_DESTYPE, CACHE);
set_report_object_property(repid, REPORT_DESFORMAT, 'PDF');
set_report_object_property(repid, REPORT_FILENAME, '\\synntm53\repogi\GAG_RPAC.RDF');
v_rep := RUN_REPORT_OBJECT(repid);
END;
This allow you to overwrite some setting define in the report object.
REPORT_SERVER parameter = Your report server use to run the report
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343164 is a reply to message #343160] |
Tue, 26 August 2008 08:53 |
m_golam_hossain
Messages: 89 Registered: August 2008 Location: Uttara, Dhaka, Bangladesh
|
Member |
|
|
Dear Kaeluan,
Many many thanks for your suggestions. I am trying this at once.
1. How can I know what is my report server name?
2. Can I send the report output to preview for print like reports of developer 6i?
3. Would you please see the attached file, why does this happen?
Best Regards for your kind attention.
G. Hossain.
-
Attachment: ERROR3.JPG
(Size: 79.37KB, Downloaded 1746 times)
[Updated on: Tue, 26 August 2008 09:19] Report message to a moderator
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343173 is a reply to message #343164] |
Tue, 26 August 2008 09:21 |
|
Try This
declare
p paramlist;
rep_id report_object;
begin
p:=Get_parameter_list('rep');
if not id_null(p) then
destroy_parameter_list(p);
end if;
p:=Create_parameter_List('rep');
add_parameter(p,<parameter1>,text_parameter,<Field1>);
Add_Parameter(p,'MAXIMIZE',TEXT_PARAMETER, 'YES');
add_parameter(p,'PARAMFORM',text_PARAMETER,'NO');
web.show_document
('/reports/rwservlet?destype=CACHE&desformat=PDF&report=<Path of RDF file>&userid=scott/tiger@orcl&p_internalno=<Field1>');
END;
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343184 is a reply to message #343173] |
Tue, 26 August 2008 09:58 |
m_golam_hossain
Messages: 89 Registered: August 2008 Location: Uttara, Dhaka, Bangladesh
|
Member |
|
|
Dear Mr. Mudabbir,
Thank you very much for your help. But, it reveals user password.
1. Can I use RUN_REPORT_OBJECT instead?
2. How can I know what my REPORT SERVER name is?
3. Can you please send the solution for the problem shown in attached file?
Kindly answer all the 3 questions.
Best Regards-
Mohd. Golam Hossain.
-
Attachment: ERROR3.JPG
(Size: 79.37KB, Downloaded 1494 times)
[Updated on: Tue, 26 August 2008 10:01] Report message to a moderator
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343209 is a reply to message #343071] |
Tue, 26 August 2008 11:29 |
Kaeluan
Messages: 179 Registered: May 2005 Location: Montreal, Quebec
|
Senior Member |
|
|
1- Yes you can use RUN_REPORT_OBJECT
2- if you try to run your report locally using oc4j you need to start a report server to be able to submit job on it. Open a dos command promt and type:
rwserver server=test &
This will start a new instance of report server called test.
To see your job on the report server, open Internet explorer and use a similar url (You will need to change the name of the computer)
http://wmtxpinf061.optimum.inc:8889/reports/rwservlet/showjobs?server=test
Now in your trigger in your Form use code like this
DECLARE
Repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := FIND_REPORT_OBJECT('REPORT5');
set_report_object_property(repid, REPORT_EXECUTION_MODE, BATCH);
set_report_object_property(repid, REPORT_SERVER, 'test');
set_report_object_property(repid, REPORT_COMM_MODE, SYNCHRONOUS);
set_report_object_property(repid, REPORT_DESTYPE, CACHE);
set_report_object_property(repid, REPORT_DESFORMAT, 'PDF');
set_report_object_property(repid, REPORT_FILENAME, '\\synntm53\repogi\GAG_RPAC.RDF');
v_rep := RUN_REPORT_OBJECT(repid);
web.show_document('/reports/rwservlet/getjobid'||
substr(v_rep,instr(v_rep,'_',-1)+1)||
'?server=test');
END;
web.show_document will display your report when completed
3- I am really sorry but i don`t know what is the problem here since it worked fine for me. Your form is running locally or on application server?
[Updated on: Tue, 26 August 2008 12:39] Report message to a moderator
|
|
|
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343591 is a reply to message #343071] |
Wed, 27 August 2008 10:45 |
Kaeluan
Messages: 179 Registered: May 2005 Location: Montreal, Quebec
|
Senior Member |
|
|
Actually rwdiag is a batch file that should be located in your %oracle_home%/bin. i don`t know if it`s part of some specific setting during installation of 10g tools.
Here is the code in the batch file. maybe you can try to create it manually. I hope you have all jar files required by the script installed. You may need to change some path in the file since maybe your installation is not in same directory than mine
@echo off
REM $Header: rwdiag.bat 13-may-2005.03:21:21 sunaraya Exp $
REM
REM rwdiag.bat
REM
REM Copyright (c) 2005, Oracle. All rights reserved.
REM
REM NAME
REM rwdiag.bat - rw diagnostic tool
REM
REM DESCRIPTION
REM Script to run the diagnostic tool used to locate servers / monitor packets on the network
REM
REM NOTES
REM Usage: rwdiag.bat -find <server name> | -findAll [-conf <config file>] [-timeout <timeout in sec>]
REM
REM Usage: rwdiag.bat -monitor [-log <logfile>] [-conf <config file>]
REM
REM MODIFIED (MM/DD/YY)
REM sunaraya 05/13/05 - Added rwrun.jar to the classpath for bug 4361664
REM sunaraya 04/22/05 - Provided execute permission to the script for bug 4323789
REM sunaraya 04/14/05 - sunaraya_bug-4221172
REM sunaraya 04/14/05 - Creation
REM
set ORA_HOME=C:\Oracle\ora10gds
if "%ORA_HOME%"=="" goto ERROR
set _CLASSPATH=%ORA_HOME%\jlib\zrclient.jar;%ORA_HOME%\reports\jlib\rwrun.jar
%ORA_HOME%\jdk\bin\java -DORACLE_HOME=%ORA_HOME% -classpath %_CLASSPATH% oracle.reports.utility.DiagServerLocator %*
goto END
:ERROR
echo "ORACLE_HOME is not set"
echo.
:END
|
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #343983 is a reply to message #343591] |
Thu, 28 August 2008 09:30 |
m_golam_hossain
Messages: 89 Registered: August 2008 Location: Uttara, Dhaka, Bangladesh
|
Member |
|
|
Boss,
I created a batch file named rwdiar.bat:
----------------------------------------
@echo off
set ORA_HOME=D:\oracle\OraDev\10G
if "%ORA_HOME%"=="" goto ERROR
set _CLASSPATH=%ORA_HOME%\jlib\zrclient.jar;%ORA_HOME%\reports\jlib\rwrun.jar
%ORA_HOME%\jdk\bin\java -DORACLE_HOME=%ORA_HOME% -classpath %_CLASSPATH% oracle.reports.utility.DiagServerLocator %*
goto END
:ERROR
echo "ORACLE_HOME is not set"
echo.
:END
Then I ran the batch file. The result is as below:
--------------------------------------------------
D:\Documents and Settings\Administrator>cd\
D:\>c:\matadorit\system\rwdiag -findall
Exception in thread "main" java.lang.NoClassDefFoundError: oracle/reports/utility/DiagServerLocator
D:\>
G. Hossain
[Updated on: Thu, 28 August 2008 09:32] Report message to a moderator
|
|
|
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #344602 is a reply to message #344051] |
Sat, 30 August 2008 23:32 |
m_golam_hossain
Messages: 89 Registered: August 2008 Location: Uttara, Dhaka, Bangladesh
|
Member |
|
|
Dear Mr. Kaeluan,
Can You Please give me solution to my 2 other problems:
Problem-1: Forms 10g Window problem:
In developer 6i forms windows are quite good and items of the full window are visible and navigable.
But, in developer 10g forms:
1. TOP SIDE VACANT: some space above the oracle forms window is vacant and un-usable,
2. RIGHT AND BOTTOM SIDE INVISIBLE: some items in the right side and at the bottom are neighter visible nor navigable
Problem-2: Password Problem:
Oracle asks for password each time I want to print report in Deveoper 6i reports with Database 11g.
It would be very helpful for me if you kindly provide me the solutions.
Best regards.
M. G. Hossain.
[Updated on: Sun, 31 August 2008 00:34] Report message to a moderator
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #345147 is a reply to message #343071] |
Tue, 02 September 2008 07:18 |
Kaeluan
Messages: 179 Registered: May 2005 Location: Montreal, Quebec
|
Senior Member |
|
|
Problem #1
1- This look like some reserve space for menu and toolbar because your form don`t seem to have any. I don`t know if it`s possible to remove this space.
2- Look in your file named forsmweb.cfg. This file contain default value to run your application. Search for something like this
Increase those value and it should fix your problem with invisible field.
Problem #2
Oracle ask you for password when you try to run the report from report builder or when you submit it from forms?
|
|
|
Re: RUN_REPORT_OBJECT is not working, Please Help. [message #345309 is a reply to message #345147] |
Tue, 02 September 2008 22:53 |
m_golam_hossain
Messages: 89 Registered: August 2008 Location: Uttara, Dhaka, Bangladesh
|
Member |
|
|
Problem2:
---------
Front End: Oracle Developer 6i (Forms6i and Reports 6i)
Back End : Oracle Database 11g
Yes, when I submit report print request from Developer6i Forms Builder with Oracle Database 11g, it asks for password before previewing report?
Printing Report from Developer 6i+Database 8i Combination is OK, this combination runs the programs very fine does not ask for password. I originally wrote the program in Developer 6i and Database 8i. Now, I need to upgrade them for compatibility with new Hardware and O/S.
Thanks and Regards.
G. Hossain
[Updated on: Tue, 02 September 2008 22:57] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Fri Apr 26 07:18:01 CDT 2024
|