OraFAQ Forum: Forms » Print specific number of copies of report linkes with form

Home » Developer & Programmer » Forms » Print specific number of copies of report linkes with form

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

Print specific number of copies of report linkes with form [message #253570]

Tue, 24 July 2007 06:00

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

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

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');

Report message to a moderator

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

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.....

Report message to a moderator

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

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..

Report message to a moderator

Previous Topic:	ENVIRONMENT VARIABLES
Next Topic:	View image in fullsize without path

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 11:31:46 CDT 2025