Thanks for your suggestion, Cathy. Unfortunately I need the field to be numeric because it is being sent through XFRX to produce an Excel spreadsheet.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Cathy Knight Sent: 06 January 2012 19:17 To: [email protected] Subject: RE: Format expression in report designer 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: [email protected] [mailto:[email protected]] On Behalf Of Paul Newton Sent: Friday, January 06, 2012 10:47 AM To: [email protected] 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: [email protected] 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/[email protected] ** 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.
