[CLOSED] Remove blank lines between the Column TITLE and header in Excel compound rpt
Is there a way to remove the blank line displays between report heading and report data in Excel Compound report ?
with this command its not working "ONLINE-FMT"
TABLE FILE CAR
PRINT
COUNTRY CAR SEATS
WHERE RECORDLIMIT EQ 3
HEADING CENTER
"CAR REPORT1"
-*ON TABLE SET ONLINE-FMT EXL07 OPEN NOBREAK
ON TABLE PCHOLD FORMAT EXL07 OPEN NOBREAK
ON TABLE SET STYLE *
TYPE=TITLE, BORDER=LIGHT,BORDER-COLOR=WHITE,$
END
TABLE FILE CAR
PRINT
COUNTRY CAR MODEL
WHERE RECORDLIMIT EQ 4
HEADING CENTER
"CAR REPORT2"
-*ON TABLE SET ONLINE-FMT EXL07 NOBREAK
ON TABLE PCHOLD FORMAT EXL07 NOBREAK
ON TABLE SET STYLE *
TYPE=TITLE, BORDER=LIGHT,BORDER-COLOR=WHITE,$
END
TABLE FILE CAR
PRINT
COUNTRY CAR BODYTYPE
WHERE RECORDLIMIT EQ 4
HEADING CENTER
"CAR REPORT3
-*ON TABLE SET ONLINE-FMT EXL07 CLOSE
ON TABLE PCHOLD FORMAT EXL07 CLOSE
ON TABLE SET STYLE *
TYPE=TITLE, BORDER=LIGHT,BORDER-COLOR=WHITE,$
END
This message has been edited. Last edited by: FP Mod Chuck,
Originally posted by Tom Flynn: Version 7.6.9? Good Luck!
SET DROPBLNKLINE={OFF|ON|BODY|HEADING|ALL}
This will is work only for positioned formats such as PDF, PS, DHTML, and PPT not in excel
how can i achieve this ?
WebFOCUS 8202
February 20, 2018, 04:53 PM
FP Mod Chuck
Deverloper
Looks like you better open a case with techsupport to get an answer to this..
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator WebFOCUS 7x and 8x, Windows, Linux All output Formats
November 12, 2018, 09:06 AM
Aj_BI
Hi All, as per the information available over various earlier posts for similar issue and per the IBI documentation, the DROPBLNKLINE is not applicable to EXCEL format and there seems no straight forward way to achieve the same. As soon as we apply border to the DATA/REPORT, the blank line between HEADER and TITLE appears automatically. However, I have generated a workaround that meets the requirement. I have done the PoC on only three columns and anyone can extend the same as per the real time requirement.
Guys, again this is perhaps my first reply over the WebFOCUS community so I'd be more that glad to receive your positive up-votes and feedback. These would help me keep energetic for more replies
TABLE FILE CAR PRINT COMPUTE COUNTRY/A10 = 'COUNTRY'; COMPUTE CAR/A16 = 'CAR'; COMPUTE MODEL/A24 = 'MODEL'; BY HIGHEST 1 COUNTRY NOPRINT ON TABLE HOLD AS CAR_TITLE END -RUN
TABLE FILE CAR PRINT CAR.ORIGIN.COUNTRY CAR.COMP.CAR CAR.CARREC.MODEL BY COUNTRY NOPRINT ON TABLE HOLD AS CAR_DATA END -RUN
TABLE FILE CAR_TITLE PRINT COUNTRY CAR MODEL ON TABLE HOLD AS CAR_FNL MORE FILE CAR_DATA END -RUN
TABLE FILE CAR_FNL PRINT COUNTRY AS '' CAR AS '' MODEL AS '' BY COMPUTE BLK/A1 = ''; NOPRINT ON BLK SUBHEAD "Markets and Discounts" ON TABLE SET PAGE OFF ON TABLE PCHOLD FORMAT XLSX ON TABLE SET BYDISPLAY ON ON TABLE SET DROPBLNKLINE HEADING ON TABLE SET EMPTYREPORT ON ON TABLE SET SHOWBLANKS OFF ON TABLE SET STYLE * TYPE=DATA,BORDER-TOP=LIGHT,BORDER-BOTTOM=LIGHT,BORDER-LEFT=LIGHT,BORDER-RIGHT=LIGHT,SIZE=10,$ TYPE=DATA, COLUMN=COUNTRY, FONT='CALIBRI',SIZE=14,COLOR='WHITE',BACKCOLOR=RGB(83 141 213),STYLE=BOLD,JUSTIFY=CENTER,WHEN=COUNTRY EQ 'COUNTRY', $ TYPE=DATA, COLUMN=CAR, FONT='CALIBRI',SIZE=14,COLOR='WHITE',BACKCOLOR=RGB(83 141 213),STYLE=BOLD,JUSTIFY=CENTER,WHEN=CAR EQ 'CAR', $ TYPE=DATA, COLUMN=MODEL, FONT='CALIBRI',SIZE=14,COLOR='WHITE',BACKCOLOR=RGB(83 141 213),STYLE=BOLD,JUSTIFY=CENTER,WHEN=MODEL EQ 'MODEL', $ TYPE=SUBHEAD, FONT='CAMBRIA',SIZE=16,COLOR=RGB(31 73 125),STYLE=BOLD, JUSTIFY=CENTER,$ ENDSTYLE END