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.