OraFAQ Forum: Reports & Discoverer » Group above Report from View sort differently

Home » Developer & Programmer » Reports & Discoverer » Group above Report from View sort differently (Oracle 10g , Developer 10g , WinXP)

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

Group above Report from View sort differently [message #508257]

Fri, 20 May 2011 01:45

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

Littlefoot
Messages: 21826
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

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

Littlefoot
Messages: 21826
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 11 08:28:10 CDT 2025