hi,
I'm using UNDER-LINE when sort field changes. If I have only one value then I dont need underline. But it displays UNDER-LINE always.

example
TABLE FILE CAR
PRINT FIELD1
BY FIELD2 NOPRINT
ON FIELD2 UNDER-LINE
END

I need underline only when I have more than one record on FIELD2.

-Kamesh

I'm at home so I can't try it, but you might add the word MULTILINES after your underline. I think Multilines only works with subtotals, etc, so it probably won't work, but off the top of my head it was all I could think of.

Hi Stan, MULTILINES didn't work. -Kamesh

Try using the WHEN as part of the ON statement. Hope this code works for you.



TABLE FILE CAR
SUM
RETAIL_COST
DEALER_COST

COMPUTE LINE/I2 = IF COUNTRY EQ LAST COUNTRY THEN LAST LINE + 1 ELSE 0;
BY
COUNTRY
BY
CAR

ON COUNTRY UNDER-LINE
WHEN LINE GE 1;
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.000000,
$
ENDSTYLE
END

This message has been edited. Last edited by: <Mabel>,

Here is another option you could do:


TABLE FILE CAR
SUM
RETAIL_COST
DEALER_COST

COMPUTE LINE/I2 = IF COUNTRY EQ LAST COUNTRY THEN LAST LINE + 1 ELSE 0;
BY
COUNTRY
BY
CAR

ON COUNTRY SUBFOOT
" "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.000000,
$
TYPE=SUBFOOT,
SIZE=1,
$
TYPE=SUBFOOT,
BORDER-TOP=LIGHT,
WHEN=N5 GE 1,
$
ENDSTYLE
END

This message has been edited. Last edited by: <Mabel>,

DEFINE FILE CAR
CNT_MODEL/I4 = 1;
END
TABLE FILE CAR
SUM
MODEL
CNT_MODEL
BY COUNTRY NOPRINT
ON COUNTRY UNDER-LINE WHEN CNT_MODEL GT 1
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLESHEET *
TYPE=REPORT, GRID=OFF,
FONT='VERDANA', SIZE=8, $
ENDSTYLE
END

I tried the options you suggested but it didn't work properly. I can't do SUM, so, I'm using PRINT on my code.

I think so. Please try.

DEFINE FILE CAR
WCNT/I5 = 1;
END
TABLE FILE CAR
SUM WCNT NOPRINT
BY COUNTRY
PRINT CAR DCOST RCOST
BY COUNTRY
ON COUNTRY UNDER-LINE
WHEN WCNT GT 1;
ON TABLE SET STYLE *
GRID = OFF ,$
ENDSTYLE
END

Kamesh, both of the options I gave you should work with a PRINT instead of the SUM since they are doing a COMPUTE. Give it a try and let me know if it works.