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
Messages: 89
Registered: October 2008
Location: united arab emirates
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

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
Messages: 21130
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
(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;
  select max(copy) into l_max_copy
    from rep_copy
    where reprot_name = 'this report name';

  return (l_max_copy > 0);
Re: how to write this sentences [message #389313 is a reply to message #389302] Sat, 28 February 2009 06:21 Go to previous message
Messages: 37
Registered: May 2008
Location: PAKISTAN
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: Thu Jul 27 00:06:48 CDT 2017

Total time taken to generate the page: 0.11031 seconds