OraFAQ Forum: Forms » Reports in Unix environment

Home » Developer & Programmer » Forms » Reports in Unix environment (Oracle Reports 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Reports in Unix environment [message #448395]

Tue, 23 March 2010 02:56

abdulahads
Messages: 44
Registered: October 2009
Location: SAUDI

Member

Below is my code for calling a report from form in windows environment. I want to use the same report to be called from Unix environment .

When m using application server tbanner@.... instead of 'repsrv@ahad-pc' is throwing error its in unix environment

REP-51002: Bind to Reports Server tbannerdb.kfupm.edu.sa failed

Declare
v_show_document VARCHAR2 (2000) := '/reports/rwservlet?';
v_connect VARCHAR2 (200) := 'userid=abdulahad/inshalla@test';
v_report_server VARCHAR2 (30) := 'repsrv@ahad-pc';
v_report_name VARCHAR2(100) := 'test3.rdf';
v_format VARCHAR2(12) := 'HTML';
begin
v_show_document := v_show_document
|| v_connect
-- Report server
|| '&server='
|| v_report_server
-- Report name
|| '&report='||v_report_name
-- Reports parameters
|| '&destype=CACHE'
|| '&desformat='||v_format
|| '&paramform=no';
web.show_document(v_show_document);
end;

Please if some one can guide me.
Thanks

Report message to a moderator

Re: Reports in Unix environment [message #448451 is a reply to message #448395]

Tue, 23 March 2010 08:08

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Do you have a reports server called "tbannerdb.kfupm.edu.sa" and is it up and running on the app server?

You should be able to look at the report server status messages at:

http://{server}:{port}/reports/rwservlet/showjobs?queuetype=past&server=tbannerdb.kfupm.edu.sa

Report message to a moderator

Re: Reports in Unix environment [message #448613 is a reply to message #448451]

Wed, 24 March 2010 05:46

abdulahads
Messages: 44
Registered: October 2009
Location: SAUDI

Member

Thanks it's done after the server is UP.

Assigning separateFrame=True a separate frame for form is shown.
What about report for separate frame or maximize frame.

so that the url and othe tool buttons are not viewed in output.

Regards,
Shaikh

Report message to a moderator

Re: Reports in Unix environment [message #449271 is a reply to message #448613]

Mon, 29 March 2010 01:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Does your reply indicate that you have solved your problem?

David

Report message to a moderator

Re: Reports in Unix environment [message #449278 is a reply to message #449271]

Mon, 29 March 2010 01:26

abdulahads
Messages: 44
Registered: October 2009
Location: SAUDI

Member

Yes David problem is solved.
on Application server I did up the server and it worked fine.

Thanks for your interest.

Is there someting like forms seprate_frame=true. to view fullscreen of report. I mean to hide url bar and other staff and view only report.

Report message to a moderator

Re: Reports in Unix environment [message #455510 is a reply to message #449278]

Tue, 11 May 2010 23:39

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Shaikh,

Did you solve the 'hide url' problem?

David

Report message to a moderator

Re: Reports in Unix environment [message #455527 is a reply to message #455510]

Wed, 12 May 2010 01:04

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Look at the document referenced in http://www.orafaq.com/forum/m/195956/67467/?srch=hide+url#msg_195956

This adds the report to 'cgicmd.dat' so that the report attributes are defined elsewhere.

David

Report message to a moderator

Previous Topic:	FRM-40735: ORA-01400
Next Topic:	FRM - 92050 : Failed to connect to Server: /forms/frmservlet:-1(Negative Content-length) error. ...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 00:56:35 CST 2025