Thanks for your suggestion, Dave. The best solution I have come up with so far, without using ReportListeners, is to change the report expression to Eval("Cast(st_trbal As Numeric("+cFormatExpr +"))").
Paul -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 09 January 2012 08:03 To: profoxt...@leafe.com Subject: RE: Format expression in report designer Use ReportListeners and you can dynamically change anything at runtime. Dave -----Original Message----- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Paul Newton Sent: 06 January 2012 15:47 To: profox@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/96d5b71c2b277647a0ecf548f1ebf52706674c7...@ukfawexmb2.infor.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.