April 04, 2006, 09:52 AM
Cyril JoyThree 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.
April 04, 2006, 10:45 AM
reFOCUSingHere 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
susannah1) 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 ;