OraFAQ Forum: Forms » reoprt calling from form 11g

Home » Developer & Programmer » Forms » reoprt calling from form 11g (11G 11.1.2.2.0)

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

reoprt calling from form 11g [message #671452]

Thu, 30 August 2018 01:53

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

Report message to a moderator