I'm using SSRS 2005. I have a pretty simple report: it's a table with an optional date filter. I have one column designated to allow interactive sort. When testing the report everything works fine. When I change the report execution to snapshot, the interactive sort no longer works. The icon will sometimes change to make it appear as if it is sorted, but the data doesn't actually get sorted.
Is there some config or option I've missed?
TIA
Denise