Home » Developer & Programmer » Reports & Discoverer » Group above Report from View sort differently (Oracle 10g , Developer 10g , WinXP)
Group above Report from View sort differently [message #508257] Fri, 20 May 2011 01:45 Go to next message
alammas
Messages: 46
Registered: July 2008
Member
I encountering while giving ORDER BY CLASS at report query

View was created from Master and Detail table with simple join after this i created group above report with order by ID (Varchar2 , Values like 0010101001) but in report it order ruffly( not ascending or descending but randomly) .


please help to solve this


THANKS in advance

Report message to a moderator

Re: Group above Report from View sort differently [message #508258 is a reply to message #508257] Fri, 20 May 2011 01:56 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In Data Model Editor, check fields' "Break Order" properties (you'll recognize them by blue UP or DOWN arrows).

Also, open field's Property Inspector window, go to "Break Order" property and press F1 to open Help. Read it, it might be useful.

Report message to a moderator

Re: Group above Report from View sort differently [message #508262 is a reply to message #508258] Fri, 20 May 2011 02:09 Go to previous messageGo to next message
alammas
Messages: 46
Registered: July 2008
Member
Thanks Sir,

what would be the best option to have view or at report level join as for as performance is concern.

Report message to a moderator

Re: Group above Report from View sort differently [message #508263 is a reply to message #508262] Fri, 20 May 2011 02:12 Go to previous message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A view is just a stored SELECT statement, so - if you write it correctly (tune its (SELECT statement's, I mean) performance), it doesn't matter.

Report message to a moderator

Previous Topic: templete attahcment
Next Topic: Call 6i report and Create PDF file and send mail
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 15:55:17 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.