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
March 08, 2005, 02:37 AM
Stan
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.
March 08, 2005, 12:10 PM
Kamesh
Hi Stan, MULTILINES didn't work. -Kamesh
March 08, 2005, 01:20 PM
reFOCUSing
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 ENDThis message has been edited. Last edited by: <Mabel>,
March 08, 2005, 01:29 PM
reFOCUSing
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 ENDThis message has been edited. Last edited by: <Mabel>,
March 08, 2005, 01:41 PM
<Pietro De Santis>
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
March 08, 2005, 04:36 PM
Kamesh
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.
March 08, 2005, 10:26 PM
<Sugiyama>
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
March 09, 2005, 04:18 PM
reFOCUSing
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.