Home » Developer & Programmer » Reports & Discoverer » How can I add these sentences
How can I add these sentences [message #389302] Sat, 28 February 2009 05:14 Go to next message
hisham99
Messages: 86
Registered: October 2008
Location: united arab emirates
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

Re: how can i add this sentences [message #389305 is a reply to message #389302] Sat, 28 February 2009 05:29 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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;
Re: how to write this sentences [message #389313 is a reply to message #389302] Sat, 28 February 2009 06:21 Go to previous message
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.
Previous Topic: how to give page break?
Next Topic: get total of records in different row-number
Goto Forum:
  


Current Time: Sun Dec 04 14:56:05 CST 2016

Total time taken to generate the page: 0.09575 seconds