Hi, I am running into a problem about sorting the column info. When I design the OLAP DB (or Cube), I have a dimension called Estimate, basically it has two main attributes: Estimate_Key(the value or member like, 1,2,3...) and Estimate_ID_and_DESC(its values or members like, 1-TomEstimate, 2-JohnEstimate....). For Estimate_ID_and_DESC, it is sorted by Estimate_Key(Key column), so when I connect to Analysis Services using SSMS, the list of Estimate_ID_and_DESC is like 1-TomEstimate, 2-JohnEstimate..10-MikeEstimate..., which is what I want. However, when I use RB2.0 or RB3.0 to work with the cube, and drag Estimate_ID_and_DESC to column field and run the report, the list of Estimate_ID_and_DESC will be 1-TomEstimate,10-MikeEstimate, 11-MaryEstiamte... 2-JohnEstimate..... The members are sorted in alphabet order which is not what I want. Why the RB doesn't conform with what I designed? Is there some way I can avoid this? Thanks in advance.

Hi, I am running into a problem about sorting the column info. When I design the OLAP DB (or Cube), I have a dimension called Estimate, basically it has two main attributes: Estimate_Key(the value or member like, 1,2,3...) and Estimate_ID_and_DESC(its values or members like, 1-TomEstimate, 2-JohnEstimate....). For Estimate_ID_and_DESC, it is sorted by Estimate_Key(Key column), so when I connect to Analysis Services using SSMS, the list of Estimate_ID_and_DESC is like 1-TomEstimate, 2-JohnEstimate..10-MikeEstimate..., which is what I want. However, when I use RB2.0 or RB3.0 to work with the cube, and drag Estimate_ID_and_DESC to column field and run the report, the list of Estimate_ID_and_DESC will be 1-TomEstimate,10-MikeEstimate, 11-MaryEstiamte... 2-JohnEstimate..... The member is sorted in alphabet order which is not what I want. Why the RB doesn't conform with what I designed? Is there some way I can avoid this? Thanks in advance.

Hi EricLBI, You could add a sort feature to the control to sort the value, here you could sort the value by datafield of Estimate_ID, then it will show like 1-TomEstimate, 2-JohnEstimate..10-MikeEstimate... If I misunderstand you, please feel free to let me know. Thanks, Challen Fu