Jump to content
  • Print multiple pages off the same report


    wernervd
    CategoryFeature request
    PriorityNormal
    ReproducibilityAlways
    ResolutionOpen
    SeverityMinor
    StatusNew
    Versionv3.7.4

    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



    User Feedback

    Recommended Comments

    There are no comments to display.


×
×
  • Create New...