9 Replies Latest reply on Mar 19, 2012 3:12 AM by Chris Turnbull

    Sort Problem on Name Field

    Chris Turnbull

      Hi All,

       

      I have a starnge problem that I am struggling with.

       

      I am linked to a MSSQL 2008 Data Source.

       

      I have a Cross Tab Table of which the First field is a PersonID which is an integer and is hidden.  When not hidden I can sort this as expected.  My next field is a name of the format - Turnbull, Chris which is concatenated in the SQL View with the field name of Name.  The problem that I am having is that when I click on Sort for this field either descending or ascending.

       

      I would appreciate any pointers as to why this happens.

       

      Thanks

       

      Chris