Hi Friends,

I have generated a query using MSSQL 2005 - Reporting Services. It displays data based on alphabetical order of F_NM. I would like to ascending order the data set base on measure R.

I dont know how to incorporate ORDER function to get data set in ascending order of rank (R). Please help.


SELECT NON EMPTY { [Measures].[TAR CALL], [Measures].[MATTY MKT RX TOT], [Measures].[R], [Measures].[DRS CALL] } ON COLUMNS, NON EMPTY { ([DIM_SLS_ORG_PHY].[TM].[TM].ALLMEMBERS * [CUST].[F NM].[F NM].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [CB_PHY_LVL_Y] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

Thanks & Regards,

Naveen J V