The column is a "Price Each" value, but its datatype is Double. There can be values with no decimal places, and up to 4 decimal places. In the report, I want to show the price with 2 decimal places if there are < 2 decimal places, yet be able to retain all decimal places if >2. Anyone think of a set of report expressions or a stored procedure call to easily do that?
Examples (hope this formats): Data Report shows 25 25.00 25.1 25.10 25.2015 25.2015 Thanks! Karen
