Formatting numbers in Reports

Mauddib
Mauddib Member Posts: 269
edited 2005-09-23 in NAV/Navision Classic Client
I have declared and populated an array of type integer in a report in Navision 3.07B

I want to add a thousands comma to these so 34000 comes out 34,000 etc. But Ive tried it in the FORMAT property of the text box and Ive tried using the FORMAT() function in the sourceexpression property. Neither is working for me so im sure im doing something wrong. What would the best way of doing this be?

GaMBe

Comments

  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    I don't think an Integer can be formatted this way, try converting it to a decimal.
    Marije Brummel | Freelance Business Central Specialist
  • DenSter
    DenSter Member Posts: 8,307
    Isn't it automatically formatting those numbers with your computer's settings? It may be because you are using integers instead of decimals, like Mark says.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Mauddib
    Mauddib Member Posts: 269
    Im still unsure how to use formatting. Anything I do from the help menu seems to make the field either go BLANK or display a ZERO. Weird, but im obviously messing up the syntax now so heres my new question.....

    now that I have it on decimal it IS putting in the commas but is is ALSO putting in decimals which I dont want. So now how to I format them out?

    Gavin
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Use
    <Sign><Integer Thousand>

    In the format property
    Marije Brummel | Freelance Business Central Specialist
  • Kowa
    Kowa Member Posts: 926
    edited 2005-09-15
    If you want to just cut the decimals off, put

    <Sign><Integer Thousand>

    in the Format-Property of the field.

    If you want it rounded, use the ROUND function ( ROUND(...,1)) in the source expression.
    Kai Kowalewski
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    Same option twice :D

    This must be the right solution :!:
    Marije Brummel | Freelance Business Central Specialist
  • Mauddib
    Mauddib Member Posts: 269
    Thank you all. Being a beginner sucks but Im getting it.
  • Marije_Brummel
    Marije_Brummel Member, Moderators Design Patterns Posts: 4,262
    We all went that way, and learning never gets booring. :D
    Marije Brummel | Freelance Business Central Specialist
  • DenSter
    DenSter Member Posts: 8,307
    You'll be posting answers to other people's questions in no time :)
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • Mauddib
    Mauddib Member Posts: 269
    I hope so! Navision is pretty new here in Ireland. Not too many companies use it (i dont think ive seen anyone else in ireland registered here either). So Im glad Im learning ahead of the bunch!!!

    At least this forum doesnt have the newbie haters that most forums do :) You should try reading the telephone tech talk forums at sundance.com :)

    GaMBe
  • kriki
    kriki Member, Moderator Posts: 9,121
    Mauddib wrote:
    I hope so! Navision is pretty new here in Ireland. Not too many companies use it (i dont think ive seen anyone else in ireland registered here either).
    Don't worry, it will get better in Ireland. :wink:
    I have an international customer that decided to put all the databases in 1 point with citrix-access. Guess which country take took to put all the databases.... Ireland :!:
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories