Thanks for your suggestion, Ali. Unfortunately I need the field to be numeric because it is being sent through XFRX to produce an Excel spreadsheet.
-----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ali Ihsan Turkoglu Sent: 06 January 2012 17:04 To: profoxt...@leafe.com Subject: RE: Format expression in report designer I don't know a way to change report format dynamically but: Before printing, you may add a character field to your cursor, and with Transform() function fill that field as your format expression. And print that field on report. Aliihsan > -----Original Message----- > From: profoxtech-boun...@leafe.com [mailto:profoxtech- > boun...@leafe.com] On Behalf Of Paul Newton > Sent: Friday, January 06, 2012 5:47 PM > 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/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.
