About formatting in a NAV 2013 Report

poppins

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

poppins

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

Choose:
TextBox Properties ->Number-> Number
and check in checkbox for Use 1000 separator..

Regards,
Suraj

181deepak

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