reports 2.5 sorting question

From: <techwritery2k_at_my-dejanews.com>
Date: Fri, 26 Mar 1999 18:33:25 GMT
Message-ID: <7dgjtl$6dg$1_at_nnrp1.dejanews.com>

[Quoted] I need help in my SQL statement ORDER BY clause: User requires 4 ways to sort [Quoted] in one report..my parameter form has a listbox with 4 values..I need to pass [Quoted] the selected value and append to the ORDER BY..My query is :

SELECT

  SKY_ORDER_ALERT.SKA_CREATE_DATE,
  SKY_ORDER_ALERT.SKA_GPC_ID,
  SKY_ORDER_ALERT.SKA_ORDER_NO,

  TO_DATE(SKY_ORD_INTF_LINE_PKG_CONT.IOLC_USER5,'YYMMDD'),

  SKY_ORD_INTF_LINE_PKG_CONT.IOLC_DETAIL_NO,
  SKY_ORD_INTF_LINE_PKG_CONT.IOLC_SI_ITEM_ID,
  SKY_MESSAGES.MSG_TEXT

  FROM SKY_ORDER_ALERT,
             SKY_ORD_INTF_LINE_PKG_CONT,
             SKY_MESSAGES
WHERE  	(SKY_ORDER_ALERT.SKA_ACTIVE_FLAG='A' AND
         SKY_ORDER_ALERT.SKA_GPC_ID = 'OC')

AND 	(SKY_ORD_INTF_LINE_PKG_CONT.IOLC_ID = SKY_ORDER_ALERT.SKA_IOLC_ID)

AND (SKY_ORDER_ALERT.SKA_MSG_NO =SKY_MESSAGES.MSG_NO) AND (TO_DATE(SKY_ORD_INTF_LINE_PKG_CONT.IOLC_USER5,'YYMMDD') >SYSDATE-1) ORDER BY [Quoted] -- either a) TO_DATE(SKY_ORD_INTF_LINE_PKG_CONT.IOLC_USER5,'YYMMDD') ASC, b) [Quoted] SKY_ORDER_ALERT.SKA_ORDER_NO, c) SKY_ORD_INTF_LINE_PKG_CONT.IOLC_SI_ITEM_ID ASC d) SKY_ORD_INTF_LINE_PKG_CONT.IOLC_SI_ITEM_ID

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 26 1999 - 19:33:25 CET