Basic Sort in Table Columns Possible?

Question

Post reply

Basic Sort in Table Columns Possible?

Tracey Marcinski

Newbie

Points: 2
More actions
September 7, 2007 at 7:23 am

#180632

What are my options in allowing users to sort a basic report by column? I am a Reporting Services newbie and am using SQL Server 2000 Reporting Services...any help appreciated!
Kindest Regards,
- Tracey

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ray M SSC-Insane Points: 21093 More actions · Answer 1

reporting services 2000 does not have Dynamic sorting built in.

you would have to make it a parameter into the report.

If you upgrade to 2005, it is very easy.

David McFarland SSChampion Points: 11815 More actions · Answer 2

For 2000, assuming your sorting issues are truly basic (i.e. dynamic primary sort column, fixed secondary/tertiary/quaternary/etc. sort), then as Ray says, make it a parameter. We used to offer drop downs that would let them pick.

Tracey Marcinski Newbie Points: 2 More actions · Answer 3

Thanks Ray & David! I will go the parameters route...

Kindest Regards,

- Tracey