Focal Point
mixed formats

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2761083172

February 13, 2008, 04:05 AM
FrankDutch
mixed formats
I have a report where some of the records need to have an other format than others.
Sometimes as integer sometimes as decimal.

DEFINE FILE FH0208FB
FMAT/A10=IF  NUMBER EQ 8 THEN 'I7' ELSE 'D7.1S';
END
TABLE FILE FH0208FB
SUM
     AMOUNT/FMAT AS ''
BY NUMBER
ACROSS PERIOD
END


This does not work, gives a left hand error....
But can this be done?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

February 13, 2008, 04:21 AM
GamP
Frank,

I think the format of the variable should not be A10 but A8.

Hope this helps...


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
February 13, 2008, 08:38 AM
FrankDutch
So simple.....




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7