Home » Developer & Programmer » Forms » reoprt calling from form 11g (11G 11.1.2.2.0)
reoprt calling from form 11g [message #671452] Thu, 30 August 2018 01:53 Go to next message
glmjoy
Messages: 187
Registered: September 2011
Location: KR
Senior Member
Dear all,

I have write this code on when button pressed it was working but now it is not working.

PROCEDURE Print_Report IS
MCUR_ITM VARCHAR2(40) := :SYSTEM.CURSOR_ITEM;
mpara varchar2(20) := :REPORTID;
server_name varchar2(100) := :global.PTH_IP;
sname varchar2(100) := :global.PTH_REP_SRV;
repformat varchar2(15) := 'PDF';
Pform varchar2(5) := 'NO';
dest varchar2(15) := 'Cache';
PARAM varchar2(500);
USER_NAME varchar2(100) := get_application_property(username);
REP_PATH varchar2(100) := :GLOBAL.R_PATH||'RECP_PRINT.rdf';
BEGIN

param:='recpno='||mpara;

WEB.SHOW_DOCUMENT ('http://'||server_name||'/reports/rwservlet?destype='||dest||'&desformat='||REPFORMAT||'&paramform='||PFORM ||'&pagestream=yes&server='||sname||'&report='||REP_PATH||'&userid=hmis/patel123@hmis&logged_in_user_name='||user _name||'&'||PARAM);

END;

it gives error REP-51000: The Reports Server name is not specified.

I am not getting where is the problem


Re: reoprt calling from form 11g [message #671458 is a reply to message #671452] Thu, 30 August 2018 05:21 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you sure all your global variables are populated correctly?
Re: reoprt calling from form 11g [message #671459 is a reply to message #671458] Thu, 30 August 2018 05:36 Go to previous messageGo to next message
glmjoy
Messages: 187
Registered: September 2011
Location: KR
Senior Member
Yes
Re: reoprt calling from form 11g [message #671466 is a reply to message #671459] Thu, 30 August 2018 09:02 Go to previous message
glmjoy
Messages: 187
Registered: September 2011
Location: KR
Senior Member
http://testoracle:8888/reports/rwservlet?destype=Cache&desformat=PDF&paramform=NO&pagestream=yes&server=&report=C :\REPORTS\TEST.rdf&userid=hmis/patel123@hmis&logged_in_user_name=HMIS&recpno=1096210
Previous Topic: Looping through block for each record
Next Topic: How to Print Directly without showing Report in Oracle Forms 10G?
Goto Forum:
  


Current Time: Thu Mar 28 03:48:51 CDT 2024