Home » Developer & Programmer » Reports & Discoverer » how to get the values asc order??
how to get the values asc order?? [message #632196] Tue, 27 January 2015 05:41 Go to next message
mist598
Messages: 1188
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,
Getting in the report output as shown as below , means not in a sequence even used order by Order_no ,Line_no, how to get the Order_no as asc order ???
Order_no  Line_no
----      -------
625       1.1

626       1.1
 
786       1.1          
--------
617       2.1
 
618       2.1

619       2.1

620       2.1

621       2.1

622       2.1

---------


I have used property for Line_no Column-->Break order-->Ascending

[Updated on: Tue, 27 January 2015 05:41]

Report message to a moderator

Re: how to get the values asc order?? [message #632197 is a reply to message #632196] Tue, 27 January 2015 05:48 Go to previous messageGo to next message
cookiemonster
Messages: 13787
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you only have one group in the query editor remove the break order. It overrides order by and isn't needed unless you have multiple groups (and is never needed in the bottom group)
Re: how to get the values asc order?? [message #632201 is a reply to message #632197] Tue, 27 January 2015 06:06 Go to previous messageGo to next message
mist598
Messages: 1188
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
If you only have one group in the query editor remove the break order. It overrides order by and isn't needed unless you have multiple groups (and is never needed in the bottom group)

Thanks for quickly reply cookiemonster.. Smile

In the Data model
     A_1
 
    B_1

        in the group i have Order_no

   C_1
       i have SO_LINE column

Data link between B_1 and C_1 


icon14.gif  Re: how to get the values asc order?? [message #632202 is a reply to message #632197] Tue, 27 January 2015 06:20 Go to previous messageGo to next message
mist598
Messages: 1188
Registered: February 2013
Location: Hyderabad
Senior Member
Hi cookiemonster, i didn't understand your post can you please give me solution please??
Re: how to get the values asc order?? [message #632203 is a reply to message #632202] Tue, 27 January 2015 06:57 Go to previous messageGo to next message
cookiemonster
Messages: 13787
Registered: September 2008
Location: Rainy Manchester
Senior Member
So you need to set break order on order_no to ascending
Re: how to get the values asc order?? [message #632229 is a reply to message #632203] Tue, 27 January 2015 21:58 Go to previous messageGo to next message
mist598
Messages: 1188
Registered: February 2013
Location: Hyderabad
Senior Member
Quote:
So you need to set break order on order_no to ascending

I Already set the break order on order_no to ascending & remove the SO_LINE (bottom group) break order property as NONE right??
Re: how to get the values asc order?? [message #632245 is a reply to message #632229] Wed, 28 January 2015 03:07 Go to previous message
cookiemonster
Messages: 13787
Registered: September 2008
Location: Rainy Manchester
Senior Member
Have you got multiple queries or multiple groups?
In this case a screen shot of the data model would be clearer than what you posted.
Previous Topic: Page wise grouping
Next Topic: Rank/Position Calculation.
Goto Forum:
  


Current Time: Mon Jan 27 03:54:35 CST 2020