Hello All - When i am keeping a 'skip-line' on a sort field, I am getting a line space after the column title as well. Can some one pls help me resolve this? Any ideas are appreciated.. Thank you!
When i am keeping a 'skip-line' on a sort field, I am getting a line space after the column title as well. Can some one pls help me resolve this? Any ideas are appreciated.. Thank you!
On all pages or all but the first page?
Leah
March 28, 2007, 05:16 PM
mgrackin
Kal,
This is standard behavior for the SKIP-LINE command. Try using a SUBFOOT on your sort field instead of the SKIP-LINE command.
TABLE FILE CAR PRINT RCOST DCOST BY COUNTRY BY CAR ON COUNTRY SUBFOOT " " ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF,$ ENDSTYLE END
Thanks!
Mickey
FOCUS/WebFOCUS 1990 - 2011
March 29, 2007, 12:05 PM
Kal
Thanks for your valuable response! Hi Leah - Its the same on all pages
Thanks very much Mickey!! - your workaround suited for some of my screens (with skip-line on sort fields
Wondering if there is any similar workaround for removing linespace for 'Title Row' in case of skip-line with Cond. styling!!
Like for eg. when i have skip-line like TYPE=SKIPLINE, WHEN =FLG6 EQ 1, $ (OR)for ON COUNTRY SKIP-LINE WHEN FLG EQ 1
pls suggest!
Thanks a bunch!! -Kal.This message has been edited. Last edited by: Kal,
DEFINE FILE CAR FLG/I1 = IF COUNTRY EQ 'FRANCE' THEN 1 ELSE 0 ; END TABLE FILE CAR PRINT RCOST DCOST FLG BY COUNTRY BY CAR ON COUNTRY SKIP-LINE WHEN FLG EQ 1 -*ON COUNTRY SUBFOOT WHEN FLG EQ 1 -*" " ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF,$ -*TYPE=SUBFOOT, WHEN FLG EQ 1 ,$ -*TYPE=SKIPLINE, BY = COUNTRY, WHEN =FLG EQ 1, $ ENDSTYLE END
The same Condition('Flg EQ 1') is not working in case of SUBFOOT.
DEFINE FILE CAR FLG/I1 = IF COUNTRY EQ 'FRANCE' THEN 1 ELSE 0 ; END
Do a COMPUTE instead:
TABLE FILE CAR PRINT RCOST DCOST COMPUTE FLG/I1 = IF COUNTRY EQ 'FRANCE' THEN 1 ELSE 0 ; NOPRINT BY COUNTRY BY CAR ON COUNTRY SKIP-LINE WHEN FLG EQ 1 -*ON COUNTRY SUBFOOT WHEN FLG EQ 1 -*" " ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF,$ -*TYPE=SUBFOOT, WHEN FLG EQ 1 ,$ -*TYPE=SKIPLINE, BY = COUNTRY, WHEN =FLG EQ 1, $ ENDSTYLE END