About formatting in a NAV 2013 Report

poppins
poppins Member Posts: 647
edited 2014-03-24 in NAV Three Tier
Hi everyone,

I am working on a report based on Sales Invoices (table 113) in NAV 2013 R2.
I looked in the table, the amounts in the differentlines do not have the same format : sometimes they have 2 decimal places and sometimes they have 3 decimal places (it depends on the currency, I think).

I tried TextBox Properties ->Number and I chose default in the category, but it didn't much my need (when the value is integer for example 10, the reports displays 10 and not 10.00 as I need, and when it is a decimal like 10.6 , the report displays 10.6 and not 10.60 as I need).

What shall I do to get the format as it is in the table line? and how can I add a thousand separator?
Thanks in advance :)

Comments

  • poppins
    poppins Member Posts: 647
    The thousand separator I need is a space...
    I tried to use the FORMAT function, I found the following code but didn't know how to use it: 
    FORMAT(YourDec,0,'<Sign><Integer Thousand><1000Character,,>')
    Can anyone give me a concrete example (with values) so that I can apply it to my code?
    Thanks in advance :)
  • suraj92291
    suraj92291 Member Posts: 49
    Choose:
    TextBox Properties ->Number-> Number
    and check in checkbox for Use 1000 separator..

    Regards,
    Suraj
    “Any fool can know. The point is to understand.”
    ― Albert Einstein
  • 181deepak
    181deepak Member Posts: 95
    poppins wrote:
    Hi everyone,

    I am working on a report based on Sales Invoices (table 113) in NAV 2013 R2.
    I looked in the table, the amounts in the differentlines do not have the same format : sometimes they have 2 decimal places and sometimes they have 3 decimal places (it depends on the currency, I think).

    I tried TextBox Properties ->Number and I chose default in the category, but it didn't much my need (when the value is integer for example 10, the reports displays 10 and not 10.00 as I need, and when it is a decimal like 10.6 , the report displays 10.6 and not 10.60 as I need).

    What shall I do to get the format as it is in the table line? and how can I add a thousand separator?
    Thanks in advance :)


    HI
    Try This
    On Report Designer, Click on Text Box For which you need to do the above format. Then go to Properties on the right side, Here choose Number --> Format --->Choose Expression and in the Expression Box choose the Text Box Name With Keyword "Format", and Test the Result

Categories