To reproduce:
1. Create report calchighestbug with the expression field in
page footer with expression
iif(t, tekst,'')
2. Select Calculate : Highest for this field
3. Run the following code
CREATE CURSOR t ( t l, tekst c(60) )
INSERT INTO t VALUES ( .f., '' )
INSERT INTO t VALUES ( .t., 'aaaa' )
REPORT FORM calchighestbug preview
Observed result:
print preview is empty
Expected result:
print preview must contain letters aaaa
Occurs in VFP 9 SP 1 with all set enginebehaviour settings.
Notes
Does not occur in VFP 7
Does not occur is expression is changed to iif(t, tekst,' ')
Repro code is available at
www.eetasoft.ee/calchighestbug.zipPlease confirm that this is bug introduced by VFP 9
Any idea how to fix it without changing report ?
Andrus