I want to print my report more than once.
Is there a property or function I can use to set the number of copies/reports i want to print?
This is my code:
with bar_no as (
select distinct $P{pn_from_pallet} start_bar, $P{pn_to_pallet} end_bar from dual)
select distinct barcode
from (select distinct level barcode
from dual
connect by level <= (select max(end_bar) from bar_no)) a
where exists (
select distinct 1
from bar_no
where barcode between bar_no.start_bar and bar_no.end_bar)
order by barcode
say i run this and use 5 for $P{pn_from_pallet} and 10 for $P{pn_to_pallet}.
it will return :
1
2
3
4
5
This will be my barcodes of my pallets.
I also want to now say how many times the report must generate. How do i do this? please help me
Recommended Comments
There are no comments to display.