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
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: 18822
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.
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.
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: 18822
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.
Previous Topic: templete attahcment
Next Topic: Call 6i report and Create PDF file and send mail
Goto Forum:
  


Current Time: Wed Apr 16 18:12:23 CDT 2014

Total time taken to generate the page: 0.10822 seconds