Focal Point
Three Questions on Reports

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

April 04, 2006, 09:52 AM
Cyril Joy
Three Questions on Reports
I have three questions on report.

1. Is it possible to give an id to TR/TD/TABLE to the report output?

2. Is it possible to hide a part of data from the report based on some
condition. In the example below,

TABLE FILE CAR
PRINT COUNTRY DEALER_COST RETAIL_COST SALES
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=DEALER_COST,COLOR=RED,WHEN=COUNTRY EQ 'ITALY', $
ENDSTYLE
END

When Country is 'ITALY', I dont want the data to be displayed in the DEALER_COST
field. The DEALER_COST is a numeric field. Is there a command like,
TYPE=DATA,COLUMN=DEALER_COST,VISIBILITY=HIDDEN,WHEN=COUNTRY EQ 'ITALY', $

3. How to apply multiple when conditions?
For example, in the above example, i need RETAIL_COST to be BOLD when SALES is 0
and COUNTRY is ITALY.

Thanks for your time.


Regards,
Cyril Joy.

WF Production 8008 on Linux.
April 04, 2006, 10:45 AM
reFOCUSing
Here are some answers for you:

1) I'm not sure.

2)
TABLE FILE CAR
PRINT
     COUNTRY
     DEALER_COST
     RETAIL_COST
     SALES
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=DEALER_COST,COLOR=WHITE,WHEN=COUNTRY EQ 'ITALY', $
ENDSTYLE
END


3)
TABLE FILE CAR
PRINT
     COUNTRY
     DEALER_COST
     RETAIL_COST
     SALES
COMPUTE MK_BOLD/A1 = IF COUNTRY EQ 'ITALY' AND SALES EQ 0 THEN '1' ELSE '0'; NOPRINT
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET STYLE *
TYPE=DATA,COLUMN=SALES,STYLE=BOLD,WHEN=MK_BOLD EQ '1', $
ENDSTYLE
END

April 04, 2006, 11:52 AM
susannah
1) not directly, only if you hand code your html tags using an ALPHA output file.
2) how about this:
define file car
DCOST/D9.2 MISSING ON=IF COUNTRY EQ 'ITALY' THEN MISSING ELSE DCOST ;




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID