Problems showing more than 4 decimals in FR4

OscarOscar
edited 9:10PM in FastReport 4.0
Helllo there, I'm triyng to show numbers with 6 decimals, the numbers are stored in a SQL 2005 table. With a SQL Query I can see all the 6 decimals numbers, but when I try to show them in FR4 it shows only 4 decimals (rounding the others)

Is there any way to make FR4 to read all the 6 decimals?

thanks.

Comments

  • gpigpi
    edited 9:10PM
    What components do you use for DB access? Do you use TfrxDBDataset or FR internal dataset like TfrxADOQuery?
  • OscarOscar
    edited 9:10PM
    Thanks for your answer, I'm using TfrxADOQuery
    gpi wrote: »
    What components do you use for DB access? Do you use TfrxDBDataset or FR internal dataset like TfrxADOQuery?
  • technisofttechnisoft
    edited 9:10PM
    A shot in the dark. 4 decimals makes me think it may have something to do with Currency data type.
  • pelepele
    edited October 2012
    I had the same problem and I still don't have a solution.
    But I walked around the problem by formatting value as text.
    CAST (1.123456 AS VARCHAR(10)) AS Number
  • OscarOscar
    edited 9:10PM
    Hi Technisoft, whe you say "currency data type" do you mean in the SQL database or in FR? If SQL database, I checked and all my 6 digits are present in the table. If you mean in FR, please advise how would you check this.
    Thnaks!
    technisoft wrote: »
    A shot in the dark. 4 decimals makes me think it may have something to do with Currency data type.
  • OscarOscar
    edited 9:10PM
    Thanks pele, I wil try your suggestion and will tell you the result.
    pele wrote: »
    I had the same problem and I still don't have a solution.
    But I walked around the problem by formatting value as text.
    CAST (1.123456 AS VARCHAR(10)) AS Number
  • OscarOscar
    edited 9:10PM
    Hi again pele, your sugestion is not what I was looking for, but guess what? It works great!!, when I put the cast result in a Memo in FR I can format it and perform calculations. So My Problem is solved.

    Thanks Man!!
    Oscar wrote: »
    Thanks pele, I wil try your suggestion and will tell you the result.
    show previous quotes
  • gpigpi
    edited 9:10PM
    Also try to set ADOQuery1.Query.EnableBCD to False
  • OscarOscar
    edited 9:10PM
    HOw do I do that? I cannot find the EnableBCD property.
    gpi wrote: »
    Also try to set ADOQuery1.Query.EnableBCD to False
  • gpigpi
    edited 9:10PM
    What version of FR do you use?
  • OscarOscar
    edited 9:10PM
    FastReport Studio 4.6.94
    gpi wrote: »
    What version of FR do you use?
  • gpigpi
    edited 9:10PM
    Use latest FR 4.12.14

Leave a Comment


Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2025