ReportServer Forum

FLU73

Member

Registered: 2018-10-25

Format of number in standard mode vs pivot mode of dynamic lists

Hello,

I've applied the following settings in the file localization.cf :
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
   <localization>
      <default>fr</default>
      <format>
         <shortDatePattern></shortDatePattern>
         <longDatePattern></longDatePattern>
         <shortTimePattern></shortTimePattern>
         <longTimePattern></longTimePattern>
         <shortDateTimePattern></shortDateTimePattern>
         <longDateTimePattern></longDateTimePattern>
         <numberPattern># ##0,00</numberPattern>
         <currencyPattern># ##0,00</currencyPattern>
         <integerPattern></integerPattern>
         <percentPattern></percentPattern>
      </format>
   </localization>
</configuration>

I've reloaded the config and refresh the web page.

Then I specified the format "number" with 2 decimals and thousand separator on the measures.

This format is properly applied on the preview of the list in standard mode but not applied once the pivot mode is enabled.
It comes back in the format: x,xxx.xx

NB: , is specified as decimal separator on the user.

In a 2nd test, I tried to modify the file like below :
      <default>en</default>

reload the config
connection in language EN
When the format has not been specified
- result in standard dynamic list : x xxx,xx
- result in pivot mode : x,xxx (no decimals displayed)

When the format is specified to number with 2 decimals and thousand separator
- result in standard dynamic list : x,xxx.xx
- result in pivot mode : x,xxx.xx

Maybe I missed something to have the same format x xxx,xx in both modes.

IF_Eduardo

Administrator

Registered: 2016-11-01

Website

Re: Format of number in standard mode vs pivot mode of dynamic lists

Hi FLU73,

I raised ticket RS-3282 for this. We will investigate why the format is not consistent in both modes.

Regards,
Eduardo