Posted: 7 Aug 2017 20:35 EDT Last activity: 7 Aug 2017 22:29 EDT
Only 3 decimal places show in exported excel report
We have a report definition and contains one column which has 5 decimal places value like "100.12345". It shows 5 decimal places on report browser and exported PDF, but when I export this report to excel this column only shows 3 decimal places like "100.123".
I have attempted to modify the property UI control by changing the Decimal Places to "ALL" but it does not work on exported excel report.
Could anyone tell me how to change the decimal places showing when exported excel?
In the Query tab of Report definition, after the Sort Order column there will be a Settings gear icon. Click on that icon and select Number(left align) as the column format. You will then get the decimal values as expected.