OraFAQ Forum: Reports & Discoverer » Result differs with different databases

Home » Developer & Programmer » Reports & Discoverer » Result differs with different databases

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Result differs with different databases [message #115512]

Tue, 12 April 2005 04:54

SRM1
Messages: 13
Registered: February 2005
Location: Thane

Junior Member

Hello All ,

I have a report (ZV_INVOICE)in the application . it is supposed to be sorted on creditor number.
We have total 4 databases.
On ZBE, ZBH and ZBZ databases it does that, on ZBA database it does not (using same forms/reports). How can that be?

Can anybody guide me in this scenario ?

Thanks in advance.

SRM

Report message to a moderator

Re: Result differs with different databases [message #115573 is a reply to message #115512]

Tue, 12 April 2005 13:34

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Is there an order by clause?
Is the order column numeric?

Don't laugh, you wouldn't be the first...

MHE

Report message to a moderator

Re: Result differs with different databases [message #115758 is a reply to message #115573]

Thu, 14 April 2005 04:12

SRM1
Messages: 13
Registered: February 2005
Location: Thane

Junior Member

Hello,

Yes, there is an order by clause in the report query.(order by zv.creditor_no).And creditor_no is of NUMBER datatype.

rgrds,
SRM

Report message to a moderator

Re: Result differs with different databases [message #116745 is a reply to message #115758]

Thu, 21 April 2005 15:31

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Did you try the statement in SQL? Does the result still differ between the databases?
Are all databases and reports exactly the same version (patches)?

Report message to a moderator

Previous Topic:	Can we use self joins in Oracle Discoverer Desktop edition
Next Topic:	Utility for migration rpt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 23:00:35 CDT 2024