Home » Developer & Programmer » Forms » Report without viewing send to printer (windows 2003 server)
Report without viewing send to printer [message #557625] Thu, 14 June 2012 06:11 Go to next message
nmdevorah
Messages: 6
Registered: May 2012
Location: Islamabad
Junior Member
./fa/10246/0/

WHEN-BUTTON-PRESSED


declare
repid report_object;
v_rep varchar2(200);
CNT NUMBER:=1;
ATC VARCHAR2(30);
begin
for rec1 in
(SELECT DISTINCT T.SNO, T.PID, P.CAMPUS_ID
FROM KIET.STCLASS T, STPROGRAMDET P
WHERE T.TNO = :LIST16C
AND P.SNO = T.SNO AND P.PID = T.PID AND P.STATUSID NOT IN (5)
AND P.CAMPUS_ID = :LIST16A
AND T.PID = :LIST16B
ORDER BY T.SNO)
LOOP
IF ((CNT MOD 25) =0) THEN
SET_ALERT_PROPERTY('A1',ALERT_MESSAGE_TEXT,'Do you want to Continue?');
ATC:=SHOW_ALERT('A1');
IF ATC =alert_button2 then
exit ;
end if;
END IF;

repid:=find_report_object('GHP');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,:GLOBAL.MYRS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESTYPE, PRINTER);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESNAME, :PL);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=no P_SNO='||TO_NUMBER(:LIST16) ||' P_PCODE='||TO_NUMBER(:LIST16B)||' P_CAMPUS='||TO_NUMBER(:LIST16A));
v_rep := run_report_object(repid);
WEB.SHOW_DOCUMENT(:GLOBAL.MYRJ|| substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||:GLOBAL.MYRS,'_SELF');
CNT := CNT+1;
END LOOP;
MESSAGE ('END OF GRADESHEET PRINTING') ;
MESSAGE ('END OF GRADESHEET PRINTING') ;
end;





My issue is i have 3 locations(Area)
following report run only at in house where AS Located i want to run this report at every location.
  • Attachment: Form View.JPG
    (Size: 49.87KB, Downloaded 335 times)
Re: Report without viewing send to printer [message #573302 is a reply to message #557625] Wed, 26 December 2012 08:44 Go to previous message
reaz62
Messages: 9
Registered: December 2012
Location: dhaka
Junior Member
can you mail me the fmb reaz62@yahoo.com
Previous Topic: Query in Tab Canvas
Next Topic: Oracle forms 11g windows 64bit - File extraction password
Goto Forum:
  


Current Time: Sat Dec 20 22:51:11 CST 2014

Total time taken to generate the page: 0.07800 seconds