Generating multiple pdf files using oracle report builder

15 pts.
Tags:
Oracle 10g
Oracle Reports
Oracle Reports 10g
I have about 25000 pages in a pdf file. I want to split this into multiple files. Please help me out to generate this using Oracle Report Builder 10g.
ASKED: April 20, 2009  4:10 PM
UPDATED: March 25, 2010  7:04 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I’m not sure whether it is possible to split a report output in more than one file, but I guess the answer is no.
I think you could implement some kind of pagination to split the report in many files.

You could do it by modifying the report’s query to recieve the record numbers to include as parameters.

Using ROWNUM, the query should look something like this:

<pre>SELECT * from (SELECT ID, first_name, salary,rownum rnum
FROM employee
WHERE rownum <= :your_highest_record_number
ORDER BY salary
)
WHERE rnum >= :your_lowest_record_number ;</pre>

Or you could achieve something similar using the ROW_NUMBER() analytical function.

These pagination queries will not perform very fast, but in some circumstances they are the only choice.

You might want to have a look at <a href=”http://www.dba-oracle.com/t_sql_pagination.htm”>these Oracle pagination tips</a>

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Kumardev
    I have a report whose output is a 25000 pages pdf file. Actually i have about 300,000 records for the query. When i restrict the no of rows to 90,000 then i am able to generate a pdf file of 12000 pages (24 MB size) file. But when i remove this restriction (i.e rownum < 90000) then this report hangs and closes the report builder tool after 15 minute. Is it possible to generate this report in a single file ? If not , i want to split this report and generate multiple pdf files using page count as the criteria. Thanks for your help.
    15 pointsBadges:
    report
  • Jurisprudence1000
    some hidden variables in report are displayed when converting to pdf?Is there any solution to solve this problem?
    30 pointsBadges:
    report
  • Fasi
    Hi there

    I am trying to generate report in Oracle Reports 10g and wants to get the ourput in pdf form in my browser. Please advise how can i do this
    10 pointsBadges:
    report
  • TomLiotta
    Please advise how can i do this...   Since this doesn't seem to follow directly in this thread, your best first step here is to open your own question with a meaningful title. You might catch the attention of someone who can help, and future members might be able to locate your question and any answer.   Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following