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.
Just put another Data model and make a query like this...
(select 'first copy' a from dual)
(select 'second copy' b from dual)
(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.