Sorting on Column Headers

Question

Post reply

Sorting on Column Headers

Chris Gottner

SSC Rookie

Points: 41
More actions
January 5, 2006 at 10:30 am

#115804

Is there a way to sort on Column Headers in a regular Table report

Viewing 8 posts - 1 through 7 (of 7 total)

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

Karl Proctor SSC Eights! Points: 913 More actions · Answer 1

To Sort Data (from help screens):

To add sorting to a group in a table

In Layout view, click the table so that column and row handles appear above and next to the table.
Right-click the corner handle of the table, and then click Properties.
On the Groups tab, select the group to edit, and then click Edit.
On the Sorting tab, type or select the expressions by which to sort the data and the sort direction for each expression.

To add sorting to a table

In Layout view, click the table so that column and row handles appear above and next to the table.
Right-click the corner handle, and then click Properties.
On the Sorting tab, type or select the expressions by which to sort the data and the sort direction for each expression.

I always try and sort the data in the stored procedures that I call, and return a sorted result set to Reporting Services.

Hope this helps

Karl

Chris Gottner SSC Rookie Points: 41 More actions · Answer 2

Thanks Carl...But I want to be able to sort the columns by that Header by clicking on the header after it has been rendered....It would work like the sort feature in an ASP.NET Datagrid

Any idea on how to do that?

Karl Proctor SSC Eights! Points: 913 More actions · Answer 3

Our users required something similar but we couldn't find a way to do it. The solution we used was to present the user with a series of combo boxes with column names in. They could then select which items they wanted to sort on. Not ideal.

Chris Gottner SSC Rookie Points: 41 More actions · Answer 4

I see...Not a bad idea....The only way I was thinking of was to make the headers as "jump to" action items and you could be the sort type in the link but then you have to render the report again....maybe not too bad if its a quick report but I would rather not do it that way

mvee Hall of Fame Points: 3634 More actions · Answer 5

That's exactly what I ended up doing - I created up arrow and down arrow images and put them next to each column name. I added Sort Direction and Sort Column parameters and I set the action for the images to jump to the same report with the new parameters. It works fine for my short report.

But you're right - seems like there should be a better way.

Good luck.

-Megan

Chris Gottner SSC Rookie Points: 41 More actions · Answer 6

I was thinking of just making the column headers as links but I love the arrows idea...Thanks

At least I know that others have tried to find this feature and that it is most likely not available in this version...Hopefully it will be in RS 2005, unless that is what you were using....I am still using the 2000 version

mvee Hall of Fame Points: 3634 More actions · Answer 7

mvee

Hall of Fame

Points: 3634

January 6, 2006 at 9:11 am

#613285

Still using 2000 here too...