We have build a paginated report that goes out to our stakeholders everyday. We currently have 2 fields we have included in this report, premium_change_amount and commission_pcnt
We have set these fields to be decimals upto 2 decimal places but they still come out as rounded whole values every time.
For e.g, if premium_change_amount was 159.72 then the paginated report shows it off as 160.
if commission_pcnt was 78.80 then it shows as 79
We have tried troubleshooting it before, rebuilding the paginated report in Report Builder and a few other things but have had no luck. Can we get some suggestions or possible solutions?