Order by in SSRS report

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.

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)

Thanks to Nathan I got a fix. I changed the sorting property within the milestones Group to CompletionDate and it seems to be working fine now.. earlier the group was sorted by Milestones.. Just had to change it to completionDate..

You can also delete the sorting which is automatically created for you when you do grouping and then you'll get the same Order as you get when you execute the Query

becasuse you already got one sorting in the Query , so no need to sort it over again in the report

There is nice post over here regarding grouping which mentions this deleting

Your Question helped, but then I went for Deleting option which is working fine for me