PDA

View Full Version : Question on Oracle Report


Pat
05-11-2005, 06:02 AM
Hi all,

I have a question on Oracle Report 6.

When report A generate an output PDF file to harddisk, the entire PDF (say
5MB) can be written to harddisk at once. That means when I see the PDF in
my harddisk, the report was already finished and the PDF file size is 5MB.
But in report B, the output PDF just incremented in the harddisk before the
entire report is finished. That mean I can see in my harddisk the PDF file
size is increasing gradually.

Is there any report parameter to control this behaviour?

Thanks.

Daniel Morgan
05-11-2005, 06:33 AM
Pat wrote:
Hi all, I have a question on Oracle Report 6. When report A generate an output PDF file to harddisk, the entire PDF (say 5MB) can be written to harddisk at once. That means when I see the PDF in my harddisk, the report was already finished and the PDF file size is 5MB. But in report B, the output PDF just incremented in the harddisk before the entire report is finished. That mean I can see in my harddisk the PDF file size is increasing gradually. Is there any report parameter to control this behaviour? Thanks.

Not of which I am aware.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

Pat
05-11-2005, 07:36 AM
"DA Morgan" <damorgan@x.washington.edu> wrote in message
news:1115821766.250339@yasure... Pat wrote: Hi all, I have a question on Oracle Report 6. When report A generate an output PDF file to harddisk, the entire PDF
(say 5MB) can be written to harddisk at once. That means when I see the PDF
in my harddisk, the report was already finished and the PDF file size is
5MB. But in report B, the output PDF just incremented in the harddisk before
the entire report is finished. That mean I can see in my harddisk the PDF
file size is increasing gradually. Is there any report parameter to control this behaviour? Thanks. Not of which I am aware. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)

So are there some Windows environment factor which
may affect this behaviour?

Malcolm Dew-Jones
05-11-2005, 09:36 AM
Pat (pat@microsoft.com) wrote:
: Hi all,

: I have a question on Oracle Report 6.

: When report A generate an output PDF file to harddisk, the entire PDF (say
: 5MB) can be written to harddisk at once. That means when I see the PDF in
: my harddisk, the report was already finished and the PDF file size is 5MB.
: But in report B, the output PDF just incremented in the harddisk before the
: entire report is finished. That mean I can see in my harddisk the PDF file
: size is increasing gradually.

: Is there any report parameter to control this behaviour?

No idea, but the report itself may make a difference, depending on the
logic it uses.

Some reports can be generated and displayed one page at a time. Perhaps
when saved to disk you would see the pdf file getting larger one chunk at
a time.

Some reports need to scan through all the data before any pages can be
displayed. In that case the entire file would likely be written at the
end of the process and appear to turn up on disk all at once (so to
speak).


$0.04


--

This space not for rent.

Daniel Morgan
05-11-2005, 11:17 AM
Pat wrote:
"DA Morgan" <damorgan@x.washington.edu> wrote in message news:1115821766.250339@yasure...Pat wrote:Hi all,I have a question on Oracle Report 6.When report A generate an output PDF file to harddisk, the entire PDF (say5MB) can be written to harddisk at once. That means when I see the PDF inmy harddisk, the report was already finished and the PDF file size is 5MB.But in report B, the output PDF just incremented in the harddisk before theentire report is finished. That mean I can see in my harddisk the PDF filesize is increasing gradually.Is there any report parameter to control this behaviour?Thanks.Not of which I am aware.--Daniel A. MorganUniversity of Washingtondamorgan@x.washington.edu(replace 'x' with 'u' to respond) So are there some Windows environment factor which may affect this behaviour?

I doubt it. More likely it is the nature of the report and the query
or queries used in its construction as well as the number of pages
of data.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

Pat
05-12-2005, 07:59 AM
"Malcolm Dew-Jones" <yf110@vtn1.victoria.tc.ca> wrote in message
news:42823470@news.victoria.tc.ca... Pat (pat@microsoft.com) wrote: : Hi all, : I have a question on Oracle Report 6. : When report A generate an output PDF file to harddisk, the entire PDF
(say : 5MB) can be written to harddisk at once. That means when I see the PDF
in : my harddisk, the report was already finished and the PDF file size is
5MB. : But in report B, the output PDF just incremented in the harddisk before
the : entire report is finished. That mean I can see in my harddisk the PDF
file : size is increasing gradually. : Is there any report parameter to control this behaviour? No idea, but the report itself may make a difference, depending on the logic it uses. Some reports can be generated and displayed one page at a time. Perhaps when saved to disk you would see the pdf file getting larger one chunk at a time. Some reports need to scan through all the data before any pages can be displayed. In that case the entire file would likely be written at the end of the process and appear to turn up on disk all at once (so to speak). $0.04 -- This space not for rent.

I also suspect this because the one which write to disk continuously
is something like, say for 50 pages, it writes 1, 2, 3,....10, then
1, 2, 3,...10 5 times. Just wonder if after write to disk for every
10 pages and have a way to control or not.


MyLounge.com Site Map
Forum: Cars, Cell Phone, Database, Games, Home Improvement, IT, Music, School, Sports, Web Design, Web Server, Weight Loss

The MyLounge.com forum is intended for informational use only and should not be relied upon and is not a substitute for any advice. The information contained on MyLounge.com are opinions and suggestions of members and is not a representation of the opinions of MyLounge.com. MyLounge.com does not warrant or vouch for the accuracy, completeness or usefulness of any postings or the qualifications of any person responding. Please consult a expert or seek the services of an attorney in your area for more accuracy on your specific situation. Please note that our forums also serve as mirrors to Usenet newsgroups. Many posts you see on our forums are made by newsgroup users who may not be members of MyLounge.com Term of Service