Export to Excel "ERROR" in number fields

Comments

3 comments

  • Avatar
    Sergey Smagin (Product manager)

    Hello, Carlos.

    We need more information in order to investigate this problem:

    1. database server (name, version)

    2. problematic field data type

    3. does this problem happens only for some specific field values or it doesn't depend on specific values?

    0
    Comment actions Permalink
  • Avatar
    Carlos Rivas

    Hello Sergey,

     

         The database is Microsoft SQL 2012

         The fields are decimal types.

         It happens with all the the decimal type fields that I export.

     

       FYI, I created an ODBC connection to the sql server and that seemed to work fine.  The direct connection did not.  I guess I will use that.

     

       Thanks,

      Carlos

    0
    Comment actions Permalink
  • Avatar
    Sergey Smagin (Product manager)

    Hello, Carlos.

    What are your decimal boundaries? Decimal(?,?)

    Also, kindly send us a screenshot of your data format settings (a button in the left-bottom corner) of the Export dialog.

    0
    Comment actions Permalink

Please sign in to leave a comment.