OraFAQ Forum: Reports & Discoverer » Print three copies of report

Home » Developer & Programmer » Reports & Discoverer » Print three copies of report

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

Print three copies of report [message #637054]

Fri, 08 May 2015 13:15

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

I have a report and want to print the three copies of report one for the consumable ,other for then non-consumbale and other is third one.
three queries is ..one for the conumable,other for the non-consumable and third query for the third one..
how i can do this......?

Report message to a moderator

Re: Print three copies of report [message #637055 is a reply to message #637054]

Fri, 08 May 2015 15:11

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

Senior Member
Account Moderator

Select "3" as "Number of copies" while printing the document.

Report message to a moderator

Re: Print three copies of report [message #637057 is a reply to message #637055]

Sat, 09 May 2015 02:00

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

i means three copies of print not from printer but three copies of soft copies...at run time three pages ...

Report message to a moderator

Re: Print three copies of report [message #637058 is a reply to message #637057]

Sat, 09 May 2015 03:09

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

Senior Member
Account Moderator

Create a new query which will select 3 records, such as

select level lvl
from dual
connect by level <= 3

Its repeating frame should contain all other objects you currently have on the report. See what properties (such as Page protect, Break before/after etc.) have to be set in order to keep all objects on the same physical page. When you run the report, you'll have 3 copies. You can even print the recipient information somewhere on the report by creating a formula column; for example

return case when :lvl = 1 then 'Consumable'
            when :lvl = 2 then 'Non consumable'
            when :lvl = 3 then 'The third one'
       end;

Report message to a moderator

Re: Print three copies of report [message #637059 is a reply to message #637058]

Sat, 09 May 2015 03:46

irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan

Senior Member

i don't undestand...please explain....the query u write is at which frame i set....can it possible that i desingened on page and at run time ,there is three page display on page for each ...i must declare three physical page for each case and set page breake to use.But in this method there is problem that the data in first page is larger than the page size then the data overlaped. i want to displayed each case on new page...

Report message to a moderator

Re: Print three copies of report [message #637104 is a reply to message #637059]

Sun, 10 May 2015 14:16

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

Senior Member
Account Moderator

"My" query is independent, it isn't related to any query you've written so far. It is just used to let you create three exact copies of the same report. Therefore, it will have its own repeating frame which should enclose (i.e. contain) all other objects.

As of problems you mentioned: page break might not be the only property you need to set. Consider modifying Page protect, Vertical elasticity and possibly some other properties as well. If you set everything right, nothing should overlap.

Finally: I have impression that you literally created three layouts, each for one of the three pages you need. Is that correct? If so, I suppose that it isn't wrong, it only makes the report somewhat difficult to maintain (as you have to make every change three times).

Report message to a moderator

Previous Topic:	Creating a letter - self populated fields but free text body
Next Topic:	Export to Excel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 16:45:17 CST 2025