title: SSRS tablix Sorting not working on Date column
body: <p>I have a SSRS report one </p>
  
  <blockquote>
    <p>Stock#_______Description_____Colum1_____Colum2_____Colum3
    ABC__________XYZ_____________4334________4354_______454</p>
  </blockquote>
  
  <pre><code>detail part 
  
  Transaction#_______Date
  1__________________yyyy/MM/dd } Need to be sorted
  2__________________yyyy/MM/dd } this date column
  3__________________yyyy/MM/dd } but always comes unsorted
  4__________________yyyy/MM/dd } Note: (This is tablix)
  </code></pre>
  
  <p>So one line for master and in detail part showing 4 last recent records. And this is not sub-report. I am getting 4 rows, then grouping by stock# and used tablix to display 4 transactions sorted by recent date (desc). Did every effort but its not showing date in any order. Checked the dataset value, its completely in desc order by date, but reports is not arranging it somehow. Sending date as date, displaying it using Format("yyyy/MM/dd") SSRS function. Sorting using simple date value from dataset. What else I should do here?</p>