Problems showing more than 4 decimals in FR4

OscarOscar
edited 7:02PM 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 7:02PM
    What components do you use for DB access? Do you use TfrxDBDataset or FR internal dataset like TfrxADOQuery?
  • OscarOscar
    edited 7:02PM
    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 7:02PM
    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 7:02PM
    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 7:02PM
    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 7:02PM
    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.
    Oscar 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
  • gpigpi
    edited 7:02PM
    Also try to set ADOQuery1.Query.EnableBCD to False
  • OscarOscar
    edited 7:02PM
    HOw do I do that? I cannot find the EnableBCD property.
    gpi wrote: »
    Also try to set ADOQuery1.Query.EnableBCD to False
  • gpigpi
    edited 7:02PM
    What version of FR do you use?
  • OscarOscar
    edited 7:02PM
    FastReport Studio 4.6.94
    gpi wrote: »
    What version of FR do you use?
  • gpigpi
    edited 7:02PM
    Use latest FR 4.12.14

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024