I needed a way to sort dynamically in a Reporting Services report today. Google was kind enough to provide me with a sample which did exactly that on GotDotNet. Head on over to the Dynamic Sorting Sample.
Also I found a pretty interesting set of links pertaining to Reporting Services during my search. Go have a look at those at Reporting Services - Links on Ohad's WebLog.
The opinions expressed herein are my own personal opinions and do not represent
my employer's view in any way.