Create two fields, one for each format type, place them on top of each other and then conditionaly print them based on your variable.
Rick Q [email protected] On Mon, Jan 9, 2012 at 3:51 AM, Paul Newton <[email protected]>wrote: > 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: [email protected] [mailto:[email protected]] > On Behalf Of Ali Ihsan Turkoglu > Sent: 06 January 2012 17:04 > To: [email protected] > 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: [email protected] [mailto:profoxtech- > > [email protected]] On Behalf Of Paul Newton > > Sent: Friday, January 06, 2012 5:47 PM > > 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/CADaZP2=Wx5uKye8xnGQE8Kq86tY4zUtE8EcAs=906kjhynw...@mail.gmail.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.
