quote:Table file temp_hold
col1
col2 &NPCUR
col3
col4
by col5
ON TABLE HOLD FORMAT pdf
ON TABLE SET STYLE *
----
end
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
In Focus since 1993. WebFOCUS 7.7.03 Win 2003 |
col5 col1 col2 col3 col4 USD 123 xxx aaa 222 aaa bbb EUR 250 300 axc ccx GBP 100 180 cxs xxs
DEFINE FILE xxx COL3X/D12S=IF COL5 EQ 'USD' THEN 0 ELSE COL3; END TABLE FILE xxx PRINT COL1 COL2X COL3 COL4 BY COL5 END
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 |
quote:Originally posted by FrankDutch:
I think Susannah's solution only works if you print only USD or only not USD.
In a mixed report it will not work.
I think what you want iscol5 col1 col2 col3 col4 USD 123 xxx aaa 222 aaa bbb EUR 250 300 axc ccx GBP 100 180 cxs xxs
If this is what you want thenDEFINE FILE xxx COL3X/D12S=IF COL5 EQ 'USD' THEN 0 ELSE COL3; END TABLE FILE xxx PRINT COL1 COL2X COL3 COL4 BY COL5 END
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 |