Re: printer print out different pdf print out different

[Quoted] "H.C." <halinacierniak_at_poczta.onet.pl> schreef in bericht news:gdmsgk$3el$1_at_news.onet.pl...
>
> U¿ytkownik "Shakespeare" <shakespeare_at_mi5.uk.com> napisa³ w wiadomo¶ci
> news:48f70751$0$188$e4fe514c_at_news.xs4all.nl...
>>
>> "K." <halinacierniak_at_poczta.onet.pl> schreef in bericht
>> news:gcnh3u$4em$1_at_news.onet.pl...
>>>
>>> U¿ytkownik "Shakespeare" <whatsin_at_xs4all.nl> napisa³ w wiadomo¶ci
>>> news:48ef083c$0$186$e4fe514c_at_news.xs4all.nl...
>>>>
>>>> "K." <halinacierniak_at_poczta.onet.pl> schreef in bericht
>>>> news:gckv1t$a1c$1_at_news.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 Received on Wed Oct 22 2008 - 13:14:02 CEST