Dear faulknerwilliam2,

Hello, a pleasant day to you. 🙂

David Burrows is right, I encountered the same thing and I would like to thank David Burrows for the information. Yes, if the column [font="Courier New"][date_ordered][/font] is [font="Courier New"]VARCHAR[/font] type it would sort in alphabetical order.

As a workaround to this:

In the RDL, right click the cell where [font="Courier New"] [date_ordered][/font] is located...

Choose Expression...

In the big textbox under Set Expression for: Value, please type:

=FORMAT(CDATE(Fields!date_ordered.Value), "dd-MMM-yy")

Then click OK.

The column will now display [font="Arial Narrow"]<<Expr>>[/font] on the column to indicate that the column has an expression, conditional statement, etc.

I hope you find David Burrows (and mine too) tips useful in your future RDL development.

Thank you all and Godspeed. 🙂

Warmest regards,

Mark Squall