Home » Developer & Programmer » Forms » How to run Report Generator in Oracle Form builder? (Windows XP)
How to run Report Generator in Oracle Form builder? [message #346124] Sat, 06 September 2008 05:13 Go to next message
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
Member
hi.

While I am running Oracle Report Object in Oracle Form using RUN_REPORT_OBJECT its showing an error like

FRM-41211 : Integration error: SSL failure running another product

Can anyone help me, please...???
Re: How to run Report Generator in Oracle Form builder? [message #346192 is a reply to message #346124] Sun, 07 September 2008 03:33 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

hi,

Check this forum for FRM-41211.

regards,
Saadat Ahmd
Re: How to run Report Generator in Oracle Form builder? [message #346319 is a reply to message #346124] Mon, 08 September 2008 03:38 Go to previous messageGo to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
send your code
Re: How to run Report Generator in Oracle Form builder? [message #346675 is a reply to message #346319] Tue, 09 September 2008 05:54 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #346902 is a reply to message #346682] Wed, 10 September 2008 01:09 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Just run the web.show_document, forget the 'run_report_object' it is not needed.

David
Re: How to run Report Generator in Oracle Form builder? [message #350296 is a reply to message #346902] Wed, 24 September 2008 11:01 Go to previous messageGo to next message
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
Member
Sir,

I didnt get how to run without using run_report_object. can u send me a sample code, please?

Re: How to run Report Generator in Oracle Form builder? [message #350297 is a reply to message #346682] Wed, 24 September 2008 11:02 Go to previous messageGo to next message
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 #350380 is a reply to message #350297] Wed, 24 September 2008 20:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What version of Forms and Reports are you running?

Search this forum for 'web.show_document'. Look at the older entries.

David

Upd: Look at http://www.orafaq.com/forum/m/144539/67467/?srch=web.show_document#msg_144539

[Updated on: Wed, 24 September 2008 20:41]

Report message to a moderator

Re: How to run Report Generator in Oracle Form builder? [message #350942 is a reply to message #350380] Sat, 27 September 2008 23:33 Go to previous messageGo to next message
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
Member
Sir,

I am using Oracle Developer Suit 10g.

Thanks
Re: How to run Report Generator in Oracle Form builder? [message #351138 is a reply to message #350380] Mon, 29 September 2008 07:58 Go to previous messageGo to next message
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 #351206 is a reply to message #351138] Mon, 29 September 2008 19:43 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please post your code.

David
Re: How to run Report Generator in Oracle Form builder? [message #351850 is a reply to message #351206] Fri, 03 October 2008 08:09 Go to previous messageGo to next message
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 #352255 is a reply to message #351850] Mon, 06 October 2008 22:03 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
With which part of "Just run the web.show_document, forget the 'run_report_object' it is not needed." are you having a problem? Look at the link I posted previously.

David
Re: How to run Report Generator in Oracle Form builder? [message #352728 is a reply to message #352255] Thu, 09 October 2008 04:03 Go to previous messageGo to next message
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 #353353 is a reply to message #352255] Mon, 13 October 2008 08:52 Go to previous messageGo to next message
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
Member
Sir,

Please help me sir. I am fully depending on this orafaq.com for my mini project. So please...

Re: How to run Report Generator in Oracle Form builder? [message #353985 is a reply to message #353353] Thu, 16 October 2008 00:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please post your code.

David
Re: How to run Report Generator in Oracle Form builder? [message #354045 is a reply to message #346124] Thu, 16 October 2008 03:48 Go to previous messageGo to next message
vikasg2006
Messages: 78
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’||’&paramform=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 #354093 is a reply to message #354045] Thu, 16 October 2008 07:09 Go to previous messageGo to next message
arunn
Messages: 52
Registered: September 2008
Location: usa
Member
hi,

did u short the report server

just go to command screen and short the report server like below

rwserver server=ur report server name runtime=yes

let me know the status.

arun

Re: How to run Report Generator in Oracle Form builder? [message #354137 is a reply to message #346124] Thu, 16 October 2008 09:35 Go to previous messageGo to next message
vikasg2006
Messages: 78
Registered: March 2006
Location: Dubai
Member
Yes, of course , i already started by using same command line. It pop up a window which says, report server repserver is running. I want to know, is application server installation needed or not? or any other config file i need to change
Re: How to run Report Generator in Oracle Form builder? [message #354177 is a reply to message #346124] Thu, 16 October 2008 18:26 Go to previous messageGo to next message
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 #354194 is a reply to message #346124] Thu, 16 October 2008 22:56 Go to previous messageGo to next message
vikasg2006
Messages: 78
Registered: March 2006
Location: Dubai
Member
Yes. it display in screen correct report server name. also inside report folder there is one dat file created with repserver name repserver.dat.
Re: How to run Report Generator in Oracle Form builder? [message #354448 is a reply to message #354093] Sun, 19 October 2008 04:12 Go to previous messageGo to next message
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 #354610 is a reply to message #354093] Mon, 20 October 2008 10:04 Go to previous messageGo to next message
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
Member
hi...

I am sure that my report server name (rserver) is correct. And it created one dat file in the server folder named rserver.dat

Still I am not able to run the report... Wht to do???

Ranjith...
Re: How to run Report Generator in Oracle Form builder? [message #354618 is a reply to message #354610] Mon, 20 October 2008 10:31 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

hi,
If this is helpful to you?
http://www.orafaq.com/forum/t/126498/67693/

regards,
Saadat Ahmad
Re: How to run Report Generator in Oracle Form builder? [message #354706 is a reply to message #346124] Mon, 20 October 2008 22:50 Go to previous messageGo to next message
vikasg2006
Messages: 78
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 #354837 is a reply to message #354706] Tue, 21 October 2008 09:10 Go to previous messageGo to next message
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
Senior Member

hi,
Check out this thread. It should help.

http://forums.oracle.com/forums/thread.jspa?threadID=299780

regards,
Saadat Ahmad
Re: How to run Report Generator in Oracle Form builder? [message #355170 is a reply to message #346124] Thu, 23 October 2008 00:24 Go to previous messageGo to next message
vikasg2006
Messages: 78
Registered: March 2006
Location: Dubai
Member
Finally it works. Thanks for all for help me.
Last link help me finally(http://forums.oracle.com/forums/thread.jspa?threadID=299780) given by Saadat Ahmad
icon8.gif  Re: How to run Report Generator in Oracle Form builder? [message #357799 is a reply to message #354177] Thu, 06 November 2008 11:56 Go to previous messageGo to next message
scorpio_
Messages: 8
Registered: October 2008
Junior Member
Hello! I need to generate multiple reports in a form, for example
i have three reports: report1.rdf,report2.rdf and report3.rdf.

I call the reports with the following method:

WEB.SHOW_DOCUMENT(reports_servlet||'/getjobid'||vjob_id||'?server='||report_server_name,'_blank');

This method it´s rigth! but, i´ts only execute with one report(The report selected when creating report object with wizard)!

My questions is: do you need create/add one report object for each report in your application?? or you can use the same object for all reports in yours applicattion??

Thanks!!
Re: How to run Report Generator in Oracle Form builder? [message #357837 is a reply to message #357799] Thu, 06 November 2008 21:28 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
As you have decided to hijack this thread, with which part of my post "With which part of "Just run the web.show_document, forget the 'run_report_object' it is not needed." are you having a problem? Look at the link I posted previously." are you having a problem?

David
Re: How to run Report Generator in Oracle Form builder? [message #357987 is a reply to message #357837] Fri, 07 November 2008 08:50 Go to previous messageGo to next message
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
Member
Sir,

Some times its showing error. When I am simply deleted the item and copied the trigger to another, its not showing the error.

Thanks for your suggestions. I learned a lot from this sir.
Thanks.

Ranjith.
Re: How to run Report Generator in Oracle Form builder? [message #357988 is a reply to message #357837] Fri, 07 November 2008 09:13 Go to previous messageGo to next message
ranjith_amrita
Messages: 44
Registered: August 2008
Location: Coimbatore
Member
Sir,
Can you please give me your E-mail ID? I'll mail you.

Ranjith.
Re: How to run Report Generator in Oracle Form builder? [message #357998 is a reply to message #357837] Fri, 07 November 2008 11:26 Go to previous messageGo to next message
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!!
Re: How to run Report Generator in Oracle Form builder? [message #358180 is a reply to message #357998] Mon, 10 November 2008 00:33 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'hide url' or 'hide userid' or 'hide show_document'.

David
Previous Topic: Can we call a Library from another Library?
Next Topic: Rep-50004
Goto Forum:
  


Current Time: Fri Dec 02 14:19:39 CST 2016

Total time taken to generate the page: 0.10449 seconds