|
|
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #346675 is a reply to message #346319] |
Tue, 09 September 2008 05:54   |
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
|
Member |
|
|
Sir,
I have created a report using report object in the Oracle Form buidler. (REPORT7)
I tried to call this object using the inbuilt procedure, RUN_REPORT_OBJECT
declare
retVal varchar(20);
begin
retVal := RUN_REPORT_OBJECT(REPORT7);
END;
This is showing the error.
Can you send me the solution, sir???
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #346682 is a reply to message #346675] |
Tue, 09 September 2008 06:18 |
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
|
Senior Member |
|
|
hi
you place one push button in your form.when button pressed u write this coding.I hope your report runs successfully.
Declare
repid REPORT_OBJECT;
v_rep VARCHAR2(1000);
rep_status VARCHAR2(20);
BEGIN
repid := find_report_object('REPORT698');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
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_SERVER,'rserver');
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://it-2c162956cad3:8889/reports/rwservlet/getjobid' ||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=rserver','_blank');
ELSE
message('Error when running report');
END IF;
END;
[Updated on: Tue, 09 September 2008 06:18] Report message to a moderator |
|
|
|
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #350297 is a reply to message #346682] |
Wed, 24 September 2008 11:02 |
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
|
Member |
|
|
Sir,
I have tried to run the report in Oracle Forms.
But it is showing the following error.
-------------------------------------------------------
FRM-41213 : Unable to connect to the Report Server
rserver
-------------------------------------------------------
And also it displays the message in the 'else' condition
'Error while running report'.
What to do? How can I solve this problem?
Is there any problem with my installation?
|
|
|
|
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #351138 is a reply to message #350380] |
Mon, 29 September 2008 07:58 |
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
|
Member |
|
|
Sir,
I am using Oracle Developer Suite 10g.
While I am running Report in Oracle Forms its showing the following error.
-------------------------------------------------------
FRM-41213 : Unable to connect to the Report Server
rserver
-------------------------------------------------------
Is there any problem in my Installation? How can I solve this error?
|
|
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #351850 is a reply to message #351206] |
Fri, 03 October 2008 08:09 |
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
|
Member |
|
|
Sir, This is my code...
------------------------------------------------------------
Declare
repid REPORT_OBJECT;
v_rep VARCHAR2(1000);
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_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_SERVER,'rserver');
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://amrita535.amritapdc.ettimadai.net:8889/reports/rwservlet/getjobid' || substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=rserver','_blank');
ELSE
message('Error when running report');
END IF;
END;
------------------------------------------------------------
Thanks
|
|
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #352728 is a reply to message #352255] |
Thu, 09 October 2008 04:03 |
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
|
Member |
|
|
Sir,
If I am using web.showdocument() how can i set its parameters? I mean the url part? I am not able to understand that.
One more thing sir,
While I am trying to insert record to my Oracle 10g database its showing the error message.
FRM-40508, unable to insert record. Please help me in this also sir.
I am able to insert record through the command prompt. While I am using Oracle forms its showing this error.
Thanks,
Ranjith
[Updated on: Thu, 09 October 2008 04:08] Report message to a moderator |
|
|
|
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #354045 is a reply to message #346124] |
Thu, 16 October 2008 03:48 |
vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai
|
Member |
|
|
Even i am facing same issue. Here is my code . I am using web.show document only
DECLARE
rep_url varchar2(2000);
BEGIN
rep_url:=‘/reports/rwservlet?server=repserv&report=reptest.rdf’||’&desformat=htmlcss&destype=cache’||’¶mform=no ’;
WEB.SHOW_DOCUMENT(rep_url,’_blank’);
END;
My oc4j instance already running, repserver also running and i am using window xp sp2, and 10 g DS. No application server in install in my pc.
One more error i am getting...Bind to report server repserver failed
|
|
|
|
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #354177 is a reply to message #346124] |
Thu, 16 October 2008 18:26 |
arunn
Messages: 52
Registered: September 2008
Location: usa
|
Member |
|
|
hi,
check your report server name is right? its main thing and u can get the server information based on your host-port-servlet.
for the first time, when u try to start the report server it will automatically install in the screen, did u saw like that? if yes then your server name is right otherwise check the server name.
and also it will generate the file with name of report server, under the report folder. check it.
update me soon, we will work it out.
arun
|
|
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #354448 is a reply to message #354093] |
Sun, 19 October 2008 04:12 |
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
|
Member |
|
|
Hi,
I tried like this
rwserver server=rserver runtime=yes
-- my server name is rserver. Its is showing error in parameter.
But when I am giving
rwserver server = rserver its showing serevr is running.
When I am trying to run report from oracle form its showing unable to run report. Why it is so...???
|
|
|
|
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #354706 is a reply to message #346124] |
Mon, 20 October 2008 22:50 |
vikasg2006
Messages: 80
Registered: March 2006
Location: Dubai
|
Member |
|
|
No, I tried with that way also. But "bind to report server repserver failed error still came. How to BIND???. Seriously now i am frustrating i tried so many ways still not able to run report.... even i install oracle 10G DS again , complete installation. still same error.
**Here I want to update that I installed 10g in my home pc. 10g developer suite which comes in 2 cds version 10.1.0.2.0 and then oracle 10g database enterprise edition.
I have two more cds: database client edition and databas companion cd which i didn't install.
[Updated on: Tue, 21 October 2008 04:44] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: How to run Report Generator in Oracle Form builder? [message #357998 is a reply to message #357837] |
Fri, 07 November 2008 11:26 |
scorpio_
Messages: 8
Registered: October 2008
|
Junior Member |
|
|
Sorry! I am not explain well...
Actually, I am using web.showdocument to run reports, but its display the username, and connstring in the url,i want to hide these parameters but I am not found the rigth way...
I try to hide the url using keymap file, this execute well... but my problem is that i don´t have only a one user! I can´t use a generic user/password to run reports because many times the user name is displayed in the report as a label or parameter control... and that is why I can not use the same user to generate all reports...
also tried to use the method of cookies, but, although I do not generate errors, did not record a cookie on the client and the report asks me to be the user authenticate...
Excuse my spelling, I'm not very good in English!!
I appreciate your understanding and support!
Thanks!!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
