sql server reporting services: Hi all,

I want to create a report that let end user sort the table by click head
of the any column, ascending and descending. How to do that in reporting
service?
My reporting service is in Visual Statdio .Net 2003

Best Regards,

Hi Sebastian
I have not had to do this but would expect that one way would be to:
1) Have the order determined by a hidden parameter (eg intSort = 1
sorts by Name, intSort = 2 sorts by City)
2) use labels for the sort column names using Navigation properties to
call the report again with a parameter indicating the sort required.

I"ve done something similar to allow dynamic grouping
Hope that helps
BrianK
www.bolign.com