how to do interactive sorting in sql reporting services 2000

I'm trying to configure a report to sort when a Field(colunm) header is
clicked. I have know idea how to do this. Any help appreciated.
Thanks,
JimHii Jim,
This a new feature of RS 2005, which can be set by using the UserSort
properties on a textbox. For example, select a column header textbox
on your report, then right click and select properties. On the
Interactive Sort tab, check the box to enable the sort and set the
specific expression and scope for the sort.
I'm not aware of any similar feature in RS 2000, but you could use
parameter(s) to prompt a user at report run time. Not interactive, but
at least flexible.
HTH
Matt A
Reporting Services Newsletter at www.reportarchitex.com
Jims wrote:
> I'm trying to configure a report to sort when a Field(colunm) header is
> clicked. I have know idea how to do this. Any help appreciated.
> Thanks,
> Jim