Thousand separator on RDLC report (NAV2016)

ACaignie

Hello,

I'm having a problem with the format of decimals on my report. The format of the decimal I want to print is "12.456,78", always with 2 decimals and a separator for thousands and decimals.
On a page this is displayed correctly, but on a report this is displayed as "12 456,78" (space as thousand separator).
This is the expression of the field on the report: =format(cdec(Code.GetData(8,10)), "#,##0.00")
The language of the report is set to =User!Language
I have checked the regional settings of the client, this is OK. Printing in NAV2009 is with this expression gives the required result.
The version of NAV is 9.0.45834.0 (which is CU16 I think), I design the report in VS Community 2015.

Does anyone have an idea how I can get this correct.

Kind regards,
Andy

SilverX

Please have a look into this post: https://blogs.msdn.microsoft.com/nav/2014/09/08/windows-regional-settings-and-number-formatting-in-rdlc-reports/

Does this apply to your environment?

navdeveloper

Hi,

Have you checked 'Number' option in 'Number' tab of Textbox property?

ACaignie

Hi,
I have tried it now, and the result is the same. I have set that I want to use a 1000 separator (it shows a point), but still the result is the same.
I suspect the problem lies with the default regional settings of NL-be, which has a space as 1000 separator, and that the report generator just ignores every change you do to the regional settings.

navdeveloper

Hi,

I too guess so. Tried changing the language property of this textbox alone?.

ACaignie

Hi,
Indeed this works, but causes another issue: we are an international company and some users work with a point as decimal separator, so they need the report with their regional settings.
For the moment I think we will use another regional setting (NL-nl) which has a thousand separator

SilverX

Please have a look into this post: https://blogs.msdn.microsoft.com/nav/2014/09/08/windows-regional-settings-and-number-formatting-in-rdlc-reports/

Does this apply to your environment?

ACaignie

Hi,
Yes this might be a solution. As I understand it the report viewer will never take customized regional settings into account, so I will try to update NL-be.
Thanks,
Andy