2 Replies Latest reply: Sep 18, 2013 6:56 AM by dassdhan RSS

    Print Copies with Different Headings ?

    dassdhan

      Hi all,

       

      We have 11gr2 Forms/Reports.

       

      I have a report  for billing purpose. I want three copies of this print and every copies with some different headings i.e.  first copy with heading as "Original Copy", second copy with heading as "Duplicate Copy", third one as "Extra Copy", and all other details are same on every copies.


      Please guide me, it is urgent.


      Thanks/Regards.

      Dass

        • 1. Re: Print Copies with Different Headings ?
          Soofi

          Hi Dass,

           

          Just put another Data model and make a query like this...

           

          (select 'first copy' a from dual)

          union

          (select 'second copy' b from dual)

          union

          (select 'third copy'c from dual);

           

          Then in your report make a separate main frame and a repeating frame and place the 'a' column selected from the query inside the repeating frame...

           

          Next... Place your report(select all frames ) and just put inside the new repeating frame..

           

          the Object navigator will look like this

           

          New main frame -> new repeating frame-->remaining frames...

           

          Run the report you will get no.of report copies you mentioned.

           

          On the other hand there is another option...

           

          Put three separate reports having distinct headings and call them when you want..

           

          Hope this helps.

           

          Regards,

          Soofi

          • 2. Re: Print Copies with Different Headings ?
            dassdhan

            Thanks a lot Mr. Soofi.