I would like to format an amount field with leading zeros and remove the decimal but keep the 2 digit cents. I would also like to have trailing spaces for a text field. Does anyone know how to accomplish this? I've tried several things like right('0000000000' + [Amount],12).
just format the measure in the list/crosstab, in the formatting options select Number, there you will find No. of Decimal Places, Minimum No. of Digits and Padding Character