Home » Developer & Programmer » Forms » Reports in Unix environment (Oracle Reports 10g)
Reports in Unix environment [message #448395] Tue, 23 March 2010 02:56 Go to next message
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
Re: Reports in Unix environment [message #448451 is a reply to message #448395] Tue, 23 March 2010 08:08 Go to previous messageGo to next message
joy_division
Messages: 4643
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
Re: Reports in Unix environment [message #448613 is a reply to message #448451] Wed, 24 March 2010 05:46 Go to previous messageGo to next message
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
Re: Reports in Unix environment [message #449271 is a reply to message #448613] Mon, 29 March 2010 01:01 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Does your reply indicate that you have solved your problem?

David
Re: Reports in Unix environment [message #449278 is a reply to message #449271] Mon, 29 March 2010 01:26 Go to previous messageGo to next message
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.

Re: Reports in Unix environment [message #455510 is a reply to message #449278] Tue, 11 May 2010 23:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Shaikh,

Did you solve the 'hide url' problem?

David
Re: Reports in Unix environment [message #455527 is a reply to message #455510] Wed, 12 May 2010 01:04 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: FRM-40735: ORA-01400
Next Topic: FRM - 92050 : Failed to connect to Server: /forms/frmservlet:-1(Negative Content-length) error. ...
Goto Forum:
  


Current Time: Fri Dec 09 08:11:36 CST 2016

Total time taken to generate the page: 0.13723 seconds