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.

Reply via email to