dbTalk Databases Forums  

printer print out different pdf print out different

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss printer print out different pdf print out different in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #71  
Old   
H.C.
 
Posts: n/a

Default Re: printer print out different pdf print out different - 10-22-2008 , 06:28 AM







Użytkownik "Shakespeare" <whatsin (AT) xs4all (DOT) nl> napisał w wiadomości
news:48ff0b05$0$189$e4fe514c (AT) news (DOT) xs4all.nl...
Quote:
"H.C." <halinacierniak (AT) poczta (DOT) onet.pl> schreef in bericht
news:gdmsgk$3el$1 (AT) news (DOT) onet.pl...

Użytkownik "Shakespeare" <shakespeare (AT) mi5 (DOT) uk.com> napisał w wiadomości
news:48f70751$0$188$e4fe514c (AT) news (DOT) xs4all.nl...

"K." <halinacierniak (AT) poczta (DOT) onet.pl> schreef in bericht
news:gcnh3u$4em$1 (AT) news (DOT) onet.pl...

Użytkownik "Shakespeare" <whatsin (AT) xs4all (DOT) nl> napisał w wiadomości
news:48ef083c$0$186$e4fe514c (AT) news (DOT) xs4all.nl...

"K." <halinacierniak (AT) poczta (DOT) onet.pl> schreef in bericht
news:gckv1t$a1c$1 (AT) news (DOT) onet.pl...
Hello!

I have a strange problem which look like this....
I print out the report into the screen (in Oracle Reports (Oracle
9.0)) and then
I print it out on the paper (this is: into the printer).
I also print out the report into the screen and then I saves it into
the pdf file.

My client told me that report printed out into the pdf file is OK,
but report
printed out into the paper & screen (this is into printer) is NOT OK.
I`ve checked and my client is right, because report printed out on
the paper
and screen contains different values than report printed out into the
pdf file.

Can you tell me what problem causes?
Why the same report created from the form with the same parameters
sent from form
into the report is different while it is saving into the PDF file and
while it is printing out
on the screen and paper.

Can you write me whether report generated on the screen and then
saving into the pdf
file is analysing database data once more or it creates pdf file
basing on the report which
I see on the screen without double database data analysing?

Thank you in advance
HC
.


1) You may have been fooled by the Application Server Cache or Browser
Cache. Either the screen/printer output or the PDF output comes from
the cache. I bet it's the PDF.
Put a date of printing (timestamp) in your report header to check
that.
or 2)
Your query could give new (updated) results when it is executed more
than once. You can check this by running the report on screen twice in
a row and see if the results differ too.

Shakespeare

Shakespeare



Hello!

I need 3 hours to check it so I will come back to the problem on
Monday.

Thank you Shakespear for quick response
I will inform you on the newsgroup what the result was.
HC.


And the result is.....?

Shakespeare



I solved the problem. It was very strange behaviour.
Problem was that I had subblock (called B) linked with main block (called
A) by relation.
In the main block I had fields which was the sum of the subblock (B).
In the result when I`ve added SUM and GROUP BY statement in the subblock
(B) everything was working fine.

Then after my changes, PDF was equal to SCREEN REPORT.

The problem occurs only when subblock (B) return more than one record
with value
data.

Thank you all for help
Greetings

working correctly



So the data DID change in between?

Shakespeare

Our client data doesn`t change so often, so it was not a problem of chaning
immediatly/rapidly data.

Marcin




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.