How do I write SortExpressions for Interactive Sorting? I have enabled interactive sorting on a textbox and it works great on a field A. But I want to sort by A and then B, where A is a double and B is a string. When I go to edit the SortExpression it just says "=Fields!A.Value". How would I write an expression to sort by A and then B?

Hi There Thanks for your posting. The most common use of interactive sort is to add a sort button to every column header. The user can then choose which column to sort by. You can only use interactive sort based on one field at a time, however you can use expression like this =IIF(Parameters!Sort.Value="Code",Fields!Code.Value,Fields!Desc.Value) For more information please have alook http://technet.microsoft.com/en-us/library/dd207011.aspx http://www.sqlservercentral.com/blogs/briankmcdonald/2010/11/04/expression-based-interactive-sorting-using-reporting-services-2008-_1320_-part-2-dynamic-sort-by/ I hope this will help Many thanks Syed Qazafi Anjum

This is very odd. Following your documentation link it looks like a more versatile but even ore kuldgy way to sort on more than one field at a time is to create a complex group expression and sort on that. Is there a good reason for SortExpression to not support multiple fields directly?

Hi There Thanks for your posting again. I think this is by design. If you would like to sort on multiple columns then you can go to you group/tablix properties and go to sorting and sort on as many column as you can but then that would be a static sort (not clickable by column as interactive sort) I hope this will help Many thanks Syed Qazafi Anjum