Re: printer print out different pdf print out different

From: H.C. <halinacierniak_at_poczta.onet.pl>
Date: Wed, 22 Oct 2008 13:28:50 +0200
Message-ID: <gdn2pj$qcq$1_at_news.onet.pl>


Użytkownik "Shakespeare" <whatsin_at_xs4all.nl> napisał w wiadomości news:48ff0b05$0$189$e4fe514c_at_news.xs4all.nl...
>
> "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
>

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

Marcin Received on Wed Oct 22 2008 - 13:28:50 CEST

Original text of this message