Instead of using the Format field, do this .. - Set the field as character, right-justified - Set the expression to TRANSFORM(YourField, cFormatExpr)
Cathy Knight (formerly Pountney) -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Paul Newton Sent: Friday, January 06, 2012 10:47 AM To: profoxt...@leafe.com Subject: Format expression in report designer Hi all In the report designer Field Properties dialog, on the Format tab one can enter a format expression, for example 9999.999 (without quotes). I want the format expression to be based on a variable cFormatExpr where cFormatExpr might be 9999.99 or 9999.999. cFormatExpression would be declared globally/public before the report runs. I can't see how to do this so if anybody has any idea they would be much appreciated. Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/003c01cccca7$c272a600$4757f200$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
