Home » Developer & Programmer » Reports & Discoverer » order of rows (disc 10.1.2)
order of rows [message #326731] Thu, 12 June 2008 08:09 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi all
To create a report i had to write a query and in that query i have fields in the following order
scoping
negotiation
signature
but when i see the report in the plus and viewer i get the order as
scoping
signature
negotiation.
Can any one please advice me as to hot ot fix it.

Thanks
Re: order of rows [message #326891 is a reply to message #326731] Fri, 13 June 2008 00:12 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

what do you have in break order property of your object?
Re: order of rows [message #327447 is a reply to message #326891] Mon, 16 June 2008 07:57 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Wency, I believe this question is about discoverer and the functionality you describe seems to be reports.

Aarti,

the order in which rows show up depends on a lot of factors, so you can never rely on it to show up in any given order, unless you explicitely tell the tool you're using to order the data and how.

So, if you want it to show up in a specific order other then alphabetically, you should have a column with a sort ordering number or something like that. Do you have that?

Regards,
Sabine
Previous Topic: double page break
Next Topic: Printer Tray control from Develper 6
Goto Forum:
  


Current Time: Tue Dec 06 16:03:10 CST 2016

Total time taken to generate the page: 0.09560 seconds