Home » Developer & Programmer » Forms » Print specific number of copies of report linkes with form
Print specific number of copies of report linkes with form [message #253570] Tue, 24 July 2007 06:00 Go to next message
scosco
Messages: 12
Registered: July 2007
Location: Port louis
Junior Member
hi,im new to oracle 10g,im working on form and report using SET_REPORT_OBJECT_PROPERTY...How to print a specific number of copies of report called from a form.
Actually im using the code:

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,printer);

for e.g i wanna print 2 copies a a report..
plz help
Re: Print specific number of copies of report linkes with form [message #255156 is a reply to message #253570] Mon, 30 July 2007 20:11 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please supply more of your code.

Oracle's Reports website http://www.oracle.com/technology/products/reports/index.html has under 'Documentation' the manual "Oracle Reports Building Reports" in whose html version http://download.oracle.com/docs/cd/B14099_17/bi.1012/b13895/toc.htm a search for 'print' found "3.7.17.6 Printing a report on UNIX" which has a reference "Oracle Application Server Reports Services Publishing Reports to the Web" to http://download.oracle.com/docs/cd/B14099_17/bi.1012/b14048/toc.htm where a search for 'cop' found an index entry that points to http://download.oracle.com/docs/cd/B14099_17/bi.1012/b14048/pbr_cla.htm#sthref2617

If you use the correct server then you should be able to simply specify the number of 'copies' that you want printed.

David
Re: Print specific number of copies of report linkes with form [message #256131 is a reply to message #255156] Fri, 03 August 2007 02:02 Go to previous messageGo to next message
scosco
Messages: 12
Registered: July 2007
Location: Port louis
Junior Member
i work on sun6....thx very much David..i finally got the solution..


SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER,'ST_CASH_ID='||varstcashid||' ST_DATE='||:stdate||' ST_SITE='||varstsite||' paramform=no' ||' copies=2');
Re: Print specific number of copies of report linkes with form [message #256136 is a reply to message #256131] Fri, 03 August 2007 02:10 Go to previous messageGo to next message
gaurav.mcabanti
Messages: 5
Registered: May 2007
Junior Member
HI


U got the solution of your problem...as u shown the code in your
message...


please if if u don't mind can u ...describe the working of your new code.....actually i am not able to understand it...completely



please help me regarding this.....
Re: Print specific number of copies of report linkes with form [message #256143 is a reply to message #256136] Fri, 03 August 2007 02:34 Go to previous message
scosco
Messages: 12
Registered: July 2007
Location: Port louis
Junior Member
hi....i post my work on the

message:Call several reports from a button-pressed form

im just passing 3 parameters from form to reports like u've seen 'ST_CASH_ID='||varstcashid||' ST_DATE='||:stdate||' ST_SITE='||varstsite||' and the param is set to no and the number of copies is set to 2.
Simple...which has took some time though..heheh..
Previous Topic: ENVIRONMENT VARIABLES
Next Topic: View image in fullsize without path
Goto Forum:
  


Current Time: Mon Dec 05 09:11:01 CST 2016

Total time taken to generate the page: 0.06243 seconds