We are using MS reporting services 2008. Here is my code to do the second sorting: =IIF(Parameters!SecondSortDirection.Value = "A",Fields(Parameters!SecondSort.Value).Value, 0) =IIF(Parameters!SecondSortDirection.Value = "D",Fields(Parameters!SecondSort.Value).Value, 0) The Ascending seems working fine but no the Decending direction. Please help! Thanks! Su

Hi, I don't undestand the expression you provided, please give us more details about your requirement. thanks, Jerry

We set the following Report Parameters to facilitate the Sorting: FirstSort, FirstSortDirection, SecondSort, SecondSortDirection. The user can choose one of the field in the data set as the FirstSort and the other one as the SecondSort. Then, in the Tablix>Sorting, we set up the Expression as the above. The FirstSort works great but not the SecondSort which puzzles me. Thanks for your help! Su

Hi Su - do you use this exact same logic for the first sort? I can't quite understand how your report hangs together, sorry!!every day is a school day