|
|
| Re: Report to multiple file [message #294993 is a reply to message #294825] |
Mon, 21 January 2008 02:05  |
mihaiv
Messages: 6
Registered: May 2007
Location: Bucharest
|
Junior Member |
|
|
Zoltan,
If i wore you, i would do like this:
1. Get the request very clear, so to know exactly which is the limit for those 5000 pages. Based upon the regions, persons, incomes, invoices etc. that you will split your pdf into 5000.
2. Go to the database and add another column to your data model, something like ID_TO_BURST. Write some simple SQL that you will get all your data to generate all those 200.000 pages, and from 5 thousands to 5 thousands update the ID_TO_BURST: 1, 2, 3 ETC...
3. Go to Oracle Reports (assuming that you are using 10g), create your report, repeat it on ID_TO_BURST. Go to main, click on the outermost R_ID_TO_BURST, go to paper design and delete the frame.
4. Distribute the report to files on your local folder, ftp, whatever, and use for example: c:\temp\Report_&<ID_TO_BURST>.PDF
Result:
In c:\temp you will have: Report_1.PDF, Report_2.PDF etc., each PDF containing the 5000.
Hope it helps,
Michael
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
