[SOLVED]FML Report Question

May 02, 2013, 11:20 AM

How can I remove the bar for one field in FML report?

In the below example, how can I remove the bar only for the Period column?

DEFINE FILE CAR
PERIOD/A20=IF CAR EQ 'AUDI' THEN '12/31/11'
ELSE IF CAR EQ 'BMW' THEN '1/1/12 - 12/31/12'
ELSE IF CAR EQ 'DATSUN' THEN '12/31/12'
ELSE IF CAR EQ 'JAGUAR' THEN '12/31/12'
ELSE IF CAR EQ 'JENSEN' THEN '1/1/12 - 12/31/12'
ELSE IF CAR EQ 'MASERATI' THEN '1/1/12 - 12/31/12'
ELSE IF CAR EQ 'TOYOTA' THEN '12/31/12'
ELSE '';
END

TABLE FILE CAR
SUM
PERIOD DEALER_COST RETAIL_COST
FOR CAR
AUDI AS 'PENDING' OVER
BMW AS 'NEW' OVER
BAR OVER
JAGUAR AS 'NET' OVER
BAR AS '=' OVER
JENSEN AS 'NOT VALID'
WHERE CAR EQ 'AUDI' OR 'BMW' OR 'JAGUAR' OR 'JENSEN'
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,FONT=ARIAL,SIZE=9,$
TYPE=TITLE,COLUMN=LIFE,JUSTIFY=RIGHT,$
ENDSTYLE
END
-EXIT

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

May 02, 2013, 12:58 PM

Alan B

DEFINE FILE CAR
PERIOD/A20=IF CAR EQ 'AUDI' THEN '12/31/11'
ELSE IF CAR EQ 'BMW' THEN '1/1/12 - 12/31/12'
ELSE IF CAR EQ 'DATSUN' THEN '12/31/12'
ELSE IF CAR EQ 'JAGUAR' THEN '12/31/12'
ELSE IF CAR EQ 'JENSEN' THEN '1/1/12 - 12/31/12'
ELSE IF CAR EQ 'MASERATI' THEN '1/1/12 - 12/31/12'
ELSE IF CAR EQ 'TOYOTA' THEN '12/31/12'
ELSE '';
END

TABLE FILE CAR
SUM
 PERIOD DEALER_COST RETAIL_COST
FOR CAR
AUDI AS 'PENDING' LABEL PEND OVER
BMW AS 'NEW' OVER
RECAP NEWBAR1(2,3)/A20 = '--------------------';  AS '' OVER 
JAGUAR AS 'NET' OVER
RECAP NEWBAR2(2,3)/A1 = ' ';  AS '' OVER 
JENSEN AS 'NOT VALID' 
WHERE CAR EQ 'AUDI' OR 'BMW' OR 'JAGUAR' OR 'JENSEN'
ON TABLE SET PAGE-NUM NOPAGE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,FONT=ARIAL,SIZE=9,$
TYPE=TITLE,COLUMN=LIFE,JUSTIFY=RIGHT,$
TYPE=REPORT, LABEL=NEWBAR2, BORDER-TOP=LIGHT, COLUMN=N3, BORDER-STYLE=DOTTED, $
TYPE=REPORT, LABEL=NEWBAR2, BORDER-TOP=LIGHT, COLUMN=N4, BORDER-STYLE=SOLID, $
ENDSTYLE
END