Decimal Precision issue for 2 decimal points
Posted: Fri May 25, 2018 11:21 am
Team,
When a report is designed for 2 decimal precision for any format like Number or Percentage the report rendering is inconsistent in different environments. For example I get exactly two decimals points in local environment but I may get three decimal points once the same template is deployed in cloud platform.
This is happening only when we put 2 decimal points in formatting. If I put any other value other than two it is working fine.
So to find what is happening I just tried different options in decimal precision and I happen to notice that when 2 decimal points are given the tag is not written to the MRT file. Please refer below for 2 decimal and 3 three decimal options for the same field.
I am using Stimulsoft 2018.2.1 version
For 3 decimal points:-
<TextFormat Ref="22" type="NumberFormat" isKey="true">
<DecimalDigits>3</DecimalDigits>
<GroupSeparator>,</GroupSeparator>
<NegativePattern>1</NegativePattern>
<UseLocalSetting>False</UseLocalSetting>
</TextFormat>
For 2 decimal points:-
<TextFormat Ref="22" type="NumberFormat" isKey="true">
<GroupSeparator>,</GroupSeparator>
<NegativePattern>1</NegativePattern>
<UseLocalSetting>False</UseLocalSetting>
</TextFormat>
Looks like because of this the report rendering is inconsistent. I manually added this tag to the report fields and deployed to cloud environment and then it worked for me.
Let me know if you need more information.
Please can you help to fix this? Thanks in advance.
When a report is designed for 2 decimal precision for any format like Number or Percentage the report rendering is inconsistent in different environments. For example I get exactly two decimals points in local environment but I may get three decimal points once the same template is deployed in cloud platform.
This is happening only when we put 2 decimal points in formatting. If I put any other value other than two it is working fine.
So to find what is happening I just tried different options in decimal precision and I happen to notice that when 2 decimal points are given the tag is not written to the MRT file. Please refer below for 2 decimal and 3 three decimal options for the same field.
I am using Stimulsoft 2018.2.1 version
For 3 decimal points:-
<TextFormat Ref="22" type="NumberFormat" isKey="true">
<DecimalDigits>3</DecimalDigits>
<GroupSeparator>,</GroupSeparator>
<NegativePattern>1</NegativePattern>
<UseLocalSetting>False</UseLocalSetting>
</TextFormat>
For 2 decimal points:-
<TextFormat Ref="22" type="NumberFormat" isKey="true">
<GroupSeparator>,</GroupSeparator>
<NegativePattern>1</NegativePattern>
<UseLocalSetting>False</UseLocalSetting>
</TextFormat>
Looks like because of this the report rendering is inconsistent. I manually added this tag to the report fields and deployed to cloud environment and then it worked for me.
Let me know if you need more information.
Please can you help to fix this? Thanks in advance.