Focal Point
[SOLVED] Using a Field to Determine Another Fields Format

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

June 19, 2009, 07:19 AM
Tewy
[SOLVED] Using a Field to Determine Another Fields Format
I have found a couple examples where one field has been used to determine the display format of another. I am just looking for where this is documented, can someone point me to the correct manual.

I've tried searching the Technical Documentation Library but can't seem to hit upon the right search terms.

thanks

This message has been edited. Last edited by: Kerry,


WF 7.6.11
Output: HTML, PDF, Excel
June 19, 2009, 07:39 AM
trob
Are you referring to conditional formatting within a report. That may be one option which is in the style tab of the Report Options.

Also you can use computes with if statements if you would like to change the actual data within a computed field based on another.


------------------------------------------
DevStudio 8.2.03
WFS 8.2.03
June 19, 2009, 08:15 AM
<JG>
Tewy the search phrase you need is "Field-Based Reformatting"

It's in the Creating Reports With WebFOCUS Language manual.

basic example from it

DEFINE FILE CAR
CFORMAT/A8 = DECODE COUNTRY('ENGLAND' 'D10.1' 'JAPAN' 'D10' ELSE
'D10.2');
END
TABLE FILE CAR
SUM SALES/CFORMAT/C DEALER_COST/CFORMAT
BY COUNTRY
END
June 19, 2009, 08:37 AM
Tewy
Thanks JG that's what I was looking for.


WF 7.6.11
Output: HTML, PDF, Excel