OraFAQ Forum: Reports & Discoverer » How can I add these sentences

Home » Developer & Programmer » Reports & Discoverer » How can I add these sentences

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

How can I add these sentences [message #389302]

Sat, 28 February 2009 05:14

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

i have report used for invoices
when user press button report will print two copy of the same invoice
what i need is
only when the second copy of invoice is printed it should show this sentences (client copy)
but in your consideration user can not change number of copy
in report i change system parameter
-copies=2
-destype=printer

Report message to a moderator

Re: how can i add this sentences [message #389305 is a reply to message #389302]

Sat, 28 February 2009 05:29

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This is not tested, but - just as an idea: one way might be to create a table

CREATE TABLE rep_copy
(report_name varchar2(30),
 copy        number
);

You'd insert a record into this table in the AFTER REPORT trigger

INSERT INTO rep_copy (report_name, copy)
  VALUES ('this report name', 1);

and test the "copy" column value in the "COPY" text format trigger and return TRUE (print it) or FALSE (don't print it) - if "copy = 1", it would mean that the "original" has already been printed so the next copy (copies) are ... well, copies:

  l_max_copy number;
begin
  select max(copy) into l_max_copy
    from rep_copy
    where reprot_name = 'this report name';

  return (l_max_copy > 0);
end;

Report message to a moderator

Re: how to write this sentences [message #389313 is a reply to message #389302]

Sat, 28 February 2009 06:21

khalidmehz
Messages: 37
Registered: May 2008
Location: PAKISTAN

Member

you have design single page you can copy one page setting to second page and print only single copy of each page. use text to display different text on each page.

Report message to a moderator

Previous Topic:	how to give page break?
Next Topic:	get total of records in different row-number

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 02:30:05 CST 2024