Method:Classic General Q&A

Re: Report designer expanding decimal places

Andy K — Fri, 06 Jan 2012 19:09:32 GMT

Beautiful. Thank you, Michael.

Re: Report designer expanding decimal places

Method_Michael — Fri, 06 Jan 2012 19:05:27 GMT

Andy-

One last detail-

If you want a $ use {0:$#.00###}

-Michael

Re: Report designer expanding decimal places

Method_Michael — Fri, 06 Jan 2012 18:59:58 GMT

Andy-

You can use a format string like the following {0:#.00###}

This will show at least 2 decimal but up to 5 if needed.

-Michael

Report designer expanding decimal places

Andy K — Fri, 06 Jan 2012 18:44:42 GMT

We have a few items where it is necessary for us to invoice the Unit price down to fractions of a penny. So for example, $0.0243 per gram and $0.01856 per gram. This works fine within Method since we can go as many decimal places as we need in that field, but when we print the invoice in report designer, it rounds to $0.02 for both scenarios. It's just a handful of items that require this, so we still want two decimal places to show up as the default when we print in all other cases.

Question: Is it possible in report designer to format the label for Unit Price so that it expands if the field has more than 2 decimal places, but reverts to the default of 2 decimal places if the number in the field has 2 or less decimal places?

Thanks,
Andy