ServiceDesk

 View Only

  • 1.  Incident Reports and Resolution Text

    Posted May 02, 2011 05:28 AM

    Hi!

     

    I need to get a report, that contains basic stuff - incident number, title, description, creation date and resolution. But when I add resolution text to report, I get an error:

    The ntext data type cannot be selected as DISTINCT because it is not comparable.

    SD in use is 7.1, upgraded from 7.0

    Digging into database reveals, that column data format for "Resolution Text" is ntext. And ntext data type is "do not use" by Microsoft since SQL 2005... Can I just "flip" the colum  data type to nvarchar(max)?

    Hando



  • 2.  RE: Incident Reports and Resolution Text

    Posted May 03, 2011 10:07 AM

    Are you using the report builder or is this your own SQL query?  If the latter, can you provide the query?



  • 3.  RE: Incident Reports and Resolution Text

    Posted May 09, 2011 02:15 AM

    I'm using report builder...