Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    5

    Unanswered: Decimal DataType

    Hi,
    I have a column ,Lines decimal(10,2).

    The data in this column is not properly displayed in crystal reports.
    Eg: the data in the column is 24.34, it's being displayed like 345234352

    Why this is so? When the data type is int, there's no problem. Because of this I'm not able to display decimals in my report. Which data type in sql server is apt for my task.

    Please help.

    Thanks

    M.L.Srinivas

  2. #2
    Join Date
    Jun 2004
    Posts
    50
    Did you try Float?
    Monk
    The person who confesses ignorance shows it once; the person who conceals it shows it many times.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check your Regional Settings in Control Panel.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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