Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    8

    Unanswered: MS SQL bigint in Crystal 10

    Hi,

    I access a table in MS SQL 2000 that has several bigint fields. To my surprise these are displayed in Crystal 10 as 'floats': value 2 is displayed as 2.005. I access the database via ODBC.
    Any suggestions??

    Chris
    Last edited by CTammes; 12-27-04 at 10:38.

  2. #2
    Join Date
    Jan 2005
    Location
    Avon Lake, OH
    Posts
    112
    Change the field formatting (right click field, choose Format Field, then the Number tab. Customize to Decimels = 1, Rounding = 1.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •