Order by in SSRS report

Question

My report is supposed to be ordered by completionDate in ascending order. I can get the order in my T-SQL query but when I populate it onto an SSRS report it doesn't seem to carry the order. I'm using SQL Server 2008. and the date is in Varchar. Any help will be highly appreciated.

Avinash.

Answer 1

Go into the properties of your table (right-click, properties) and set the Sort property to be by completionDate in Ascending order. You can also Sort each group if you need to.

If you still run into problems, you can sort the field after it's been converted into a date:

=CDate(Fields!completionDate.Value)