SAVEASPDF is using wrong decimal format / separators

meto89

Hello all,

I have found some weird behavior in Dynamics NAV 2009 R2 (6.00.32012 -> I did not test it with different builds).
[SQL Server, Service Tier and Client are all installed on different machines]

When I print a report from RTC (or use the preview for that matter) it displays decimals like '1.234,98'. However, when I use SAVEASPDF function for the same report, it displays decimals like '1,234.98'.

I don't understand this behavior. Is this a bug, or am I missing something?

While searching I could only find one post that looks similar to mine, though it states that the date formats are wrong, which work fine for me. (http://mibuso.com/forum/viewtopic.php?f=32&t=51005)


Kind regards,

Alex

ara3n

Check the window local setting on the service tier. SAVEASPDF runs on service tier not on the client.

meto89

Hi ara3n,

thanks for the answer, but running a report in RTC (without SAVEASPDF) does not use my client settings either. Therefore I would expect the same result for running a report manually or using SAVEASPDF, if both is initiated by the same client.

Furthermore all my machines have the regional settings set to "German". (Client, Service Tier and SQL Server)

(While testing a colleague found out that for printing an RTC report the system seams to use the regional settings of the SQL Server and not the one from the Service Tier... :shock:)

Further researching of the problem got me to a (not NAV related) problem. It seems that our SQL Server Version always uses the format '1234.56' for decimal fields and uses the regional settings only for float fields. Maybe my problem is the result of this issue.

I will use a workaround for now and just set specific decimal places in the RDLC Layout.


Kind regards,

Alex

mdPartnerNL

isn't this because NAV is only supplying the flat data. It's printed by ? (don't know the name)