title: Interactive sorting In SSRS on Values - Matrix report
body: <p>I want a <em>interactive sorting</em> in SSRS matrix report. From database we are getting 3 columns -PrimaryKey,Columns and Value.<br>
  We are grouping rows by <strong>Primary Key</strong> and grouping column by <strong>Columns</strong> and use <strong>Value</strong> as data.</p>
  
  <p>My Matrix Report - </p>
  
  <pre><code>ID             [Columns]
  [Primary Key]     Values
  </code></pre>
  
  <p>Output of the Matrix report -</p>
  
  <pre><code>ID  FirstName   MiddleName  Lastname
  1   Rajiv         Jha        Sharma
  2   Prem          Kumar      Bose
  3   Usha          Shamila    Praveena
  </code></pre>
  
  <p>I am able to use the interactive sorting on ID because ID is group by rows but I want to use the interactive sorting on dynamic cloumns values like FirstName,MiddleName and LastName.</p>
  
  <p>Expected result when we interactive sort on Lastname </p>
  
  <pre><code>ID  FirstName   MiddleName  Lastname
  2   Prem         Kumar      Bose
  3   Usha         Shamila    Praveena
  1   Rajiv        Jha        Sharma
  </code></pre>
  
  <p>Thanks for any Help.</p>