Add leading ***** and a $ sign to check report 1

[GCL2007]

Hello,
I am trying to create a report for check writing. The request was to format the amount value like this: ************$123.44 with the leading *s and a $ immediately preceding the field value(which is 123.44)
I would like the total field to be a fixed size, so if the value was larger, I would require less * characters preceding the $ and field value. Any thoughts?
Thanks!!!!!

 

[pmax9999]

I'd use a formula lke this:

[Code {@DisplayFormula}]
Right('*********************$' + ToText({Table.Field},2,','), 20)
[/Code]

Depending on the fixed width you want to achieve you will need to play around with the number of "*" in the formula, and/or the number of characters applying to the "Right" function. I've also assumed you want a "," as the thousands separator - amend this as required.

Hope this helps.

Cheers, Pete.

 

[GCL2007]

Thank you Pete - I think that will work for me..
Thanks!!!!!