Method:Classic General Q&A

Re: Report Designer - Change the amount of decimal places

Method_Jason — Fri, 21 Jun 2013 14:29:53 GMT

David,

Try entering this text into the Format String field: {0:$0.00}

Jason

Re: Report Designer - Change the amount of decimal places

DavidD — Thu, 20 Jun 2013 22:16:29 GMT

Thanks for the quick response. When i go to the screen you mentioned in the report designer the "Format String" box is blank. I clicked on the 3 dots button to the right of the box and selected currency and then clicked 'ok', however after doing that the field still remains blank. Am I missing something here?

Report Designer - Change the amount of decimal places

Method_Jason — Thu, 20 Jun 2013 21:54:15 GMT

A user asked about how to change the decimal places on a field in the Report Designer.

Dave,

If you're editing your report in the Report Designer, click the small white arrow next to the field that is showing the wrong amount of decimal places. What does it say in the Format String field? If it doesn't look like the screenshot below, try clicking the three dots button beside the Format String field. Here you can change the field to currency if this is the format you are looking for. Let me know if this helps and reply on this forum if you're still having difficulties.

Jason