How do you specify Sort Order in a Report?

Question

Post reply

How do you specify Sort Order in a Report?

Welsh Corgi

SSC Guru

Points: 116520
More actions
December 21, 2011 at 7:28 am

#262144

How do you specify Sort Order in a Report?
I tried ordering the results in the SP is but because it contains UNON ALL Statements I can't do it in the SP.
I got a hint the sorting is specified in the Custom Properties Dialog Box but I can't find it.
How do you navigate to the Custom Properties Dialog Box?
Edit: SQL Server 2005.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 5 posts - 1 through 5 (of 5 total)

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

I do not want a interactive sort.

I tried it but when I clicked on the Sort Arrow it collapsed the grid.

I was to sort three columns, AccountCode, AssociateCode and TransactionDate DESC.

Any help would be greatly appreciated.:unsure:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

SQL_path SSCrazy Points: 2810 More actions · Answer 2

High light by clicking your dataregion (table) > then right click properties > new window will open up called as Table Properties > click on sorting tab

then enter your fields one by one

AccountCode, AssociateCode and TransactionDate DESC.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

I'm having trouble selecting table properties.

I can easily get Report and Column Properties but I can't select the table properties. There are a lot of columns and I have to scroll to the right and I'm having trouble selecting all of the columns if that is what I need to do to get to Table Properties. :unsure:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

I found an example on the internet with a visual and I was able to get to the table properties and add the report.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/