January 22, 2019, 03:37 PM
srajeevanHere is the styling part of the code.
I have 3 output formats other than HTML,i have added them as a drilldown calling the same procedure.
No log for default HTML output format,when i display other formats,the logo is being misplaced.
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLEMBEDIMG AUTO
ON TABLE SET ASNAMES ON
ON TABLE COLUMN-TOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(<AHTML,AHTML>,<Portable Document Format (PDF),PDF>,<Excel XLSX (XLSX),XLSX>).Select type of display output.
-IF &WFFMT EQ 'HTML' GOTO htmllabel;
-IF &WFFMT EQ 'PDF' GOTO pdflabel;
-IF &WFFMT EQ 'XLSX' GOTO excellabel;
-IF &WFFMT EQ 'AHTML' GOTO ahtmllabel;
-htmllabel
ON TABLE SUBHEAD
" <+0>Summary"
" <+0>"
"<PDFGIF <AHTMLGIF <XLGIF "
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,
$
LEFTMARGIN=1.000000,
RIGHTMARGIN=1.000000,
BOTTOMMARGIN=1.000000,
$
TYPE=REPORT,
$
GRAPHTYPE=DATA,
COLUMN=N4,
GRAPHCOLOR='GREEN',
$
GRAPHTYPE=DATA,
COLUMN=N5,
GRAPHCOLOR='GREEN',
$
TYPE=DATA,
FONT='CALIBRI',
SIZE=10,
COLOR=RGB(0 51 102),
BACKCOLOR=(RGB(235 235 240) RGB(255 255 255)),
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N3,
FONT='CALIBRI',
SIZE=10,
COLOR=RGB(0 51 102),
JUSTIFY=LEFT,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=FIELD,
ITEM=1,
TARGET='_blank',
FOCEXEC=/WFC/Repository/Apps/Procedure/Summary_Rpt.fex( \
WFFMT='PDF' \
),
$
TYPE=TABHEADING,
LINE=3,
OBJECT=FIELD,
ITEM=3,
TARGET='_blank',
FOCEXEC=/WFC/Repository/Apps/Procedure/Summary_Rpt.fex( \
WFFMT='XLSX' \
),
$
TYPE=TABHEADING,
LINE=3,
OBJECT=FIELD,
ITEM=2,
TARGET='_blank',
FOCEXEC=/WFC/Repository/Apps/Procedure/Summary_Rpt.fex( \
WFFMT='AHTML' \
),
$
TYPE=TITLE,
FONT='CALIBRI',
SIZE=14,
COLOR='WHITE',
BACKCOLOR=RGB(0 51 102),
STYLE=-UNDERLINE+BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=14,
COLOR=RGB(75 75 75),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR=RGB(0 32 95),
$
TYPE=HEADING,
SIZE=14,
COLOR=RGB(75 75 75),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR=RGB(0 32 95),
$
-*TYPE=DATA,COLUMN=N2,IMAGE=(ICON_PATH),SIZE=(.3 .3),$
TYPE=TABHEADING,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
COLOR=RGB(75 75 75),
STYLE=BOLD,
$
ENDSTYLE
-GOTO GOTSTYLE
-pdflabel
ON TABLE SUBHEAD
" <+0>-"
" <+0>-"
" <+0>Summary"
" <+0>-"
" <+0>-"
" <+0>-"
"<PDFGIF <AHTMLGIF <XLGIF "
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,
$
PAGESIZE='10 x 14',
ORIENTATION=LANDSCAPE,
$
TYPE = FOOTING,
JUSTIFY= LEFT,
$
TYPE=DATA,COLUMN=N2,IMAGE=(ICON),SIZE=(.3 .3),$
TYPE=REPORT,
$
GRAPHTYPE=DATA,
COLUMN=N4,
GRAPHCOLOR='GREEN',
$
GRAPHTYPE=DATA,
COLUMN=N5,
GRAPHCOLOR='GREEN',
$
TYPE=DATA,
FONT='CALIBRI',
SIZE=10,
COLOR=RGB(0 51 102),
BACKCOLOR=(RGB(235 235 240) RGB(255 255 255)),
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N3,
FONT='CALIBRI',
SIZE=10,
COLOR=RGB(0 51 102),
JUSTIFY=LEFT,
$
TYPE=TITLE,
FONT='CALIBRI',
SIZE=14,
COLOR='WHITE',
BACKCOLOR=RGB(0 51 102),
STYLE=-UNDERLINE+BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=14,
COLOR=RGB(75 75 75),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR=RGB(0 32 95),
$
TYPE=HEADING,
SIZE=14,
COLOR=RGB(75 75 75),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR=RGB(0 32 95),
$
TYPE=TABHEADING,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
COLOR=RGB(75 75 75),
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
IMAGE=IBFS:/WFC/Repository/Apps/Images/Logo.jpg,
POSITION=(+0.041667 +0.000000),
SIZE=(1.500000 1.000000),
$
TYPE=REPORT,
COLUMN=N4,
SQUEEZE=2.0000,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=2.0,
$
TYPE=REPORT,
COLUMN=+/-,
SQUEEZE=1.555556,
$
TYPE=REPORT,
COLUMN=N7,
SQUEEZE=0.916667,
$
ENDSTYLE
-GOTO GOTSTYLE
-excellabel
ON TABLE SUBHEAD
" <+0>-"
" <+0>-"
" <+0>Incident Summary"
" <+0>-"
" <+0>-"
" <+0>-"
"<PDFGIF <AHTMLGIF <XLGIF "
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,
$
LEFTMARGIN=1.000000,
RIGHTMARGIN=1.000000,
BOTTOMMARGIN=1.000000,
$
TYPE=REPORT,
$
GRAPHTYPE=DATA,
COLUMN=N4,
GRAPHCOLOR='GREEN',
$
GRAPHTYPE=DATA,
COLUMN=N5,
GRAPHCOLOR='GREEN',
$
TYPE=DATA,
FONT='CALIBRI',
SIZE=10,
COLOR=RGB(0 51 102),
BACKCOLOR=(RGB(235 235 240) RGB(255 255 255)),
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N3,
FONT='CALIBRI',
SIZE=10,
COLOR=RGB(0 51 102),
JUSTIFY=LEFT,
$
TYPE=TITLE,
FONT='CALIBRI',
SIZE=14,
COLOR='WHITE',
BACKCOLOR=RGB(0 51 102),
STYLE=-UNDERLINE+BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=14,
COLOR=RGB(75 75 75),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR=RGB(0 32 95),
$
TYPE=HEADING,
SIZE=14,
COLOR=RGB(75 75 75),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR=RGB(0 32 95),
$
TYPE=DATA,COLUMN=N2,IMAGE=(ICON),SIZE=(.3 .3),$
TYPE=TABHEADING,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
COLOR=RGB(75 75 75),
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
WIDTH=4.181,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
IMAGE=IBFS:/WFC/Repository/Apps/Images/Logo.jpg,
POSITION=(+0.041667 +0.000000),
SIZE=(1.500000 1.000000),
$
ENDSTYLE
-GOTO GOTSTYLE
-ahtmllabel
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SUBHEAD
" <+0>-"
" <+0>-"
" <+0>Summary"
" <+0>-"
" <+0>-"
" <+0>-"
"<PDFGIF <AHTMLGIF <XLGIF "
ON TABLE SET STYLE *
INCLUDE = IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,
$
LEFTMARGIN=1.000000,
RIGHTMARGIN=1.000000,
BOTTOMMARGIN=1.000000,
$
TYPE=REPORT,
$
GRAPHTYPE=DATA,
COLUMN=N4,
GRAPHCOLOR='GREEN',
$
GRAPHTYPE=DATA,
COLUMN=N5,
GRAPHCOLOR='GREEN',
$
TYPE=DATA,
FONT='CALIBRI',
SIZE=10,
COLOR=RGB(0 51 102),
BACKCOLOR=(RGB(235 235 240) RGB(255 255 255)),
JUSTIFY=CENTER,
$
TYPE=DATA,
COLUMN=N3,
FONT='CALIBRI',
SIZE=10,
COLOR=RGB(0 51 102),
JUSTIFY=LEFT,
$
TYPE=TITLE,
FONT='CALIBRI',
SIZE=14,
COLOR='WHITE',
BACKCOLOR=RGB(0 51 102),
STYLE=-UNDERLINE+BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=14,
COLOR=RGB(75 75 75),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR=RGB(0 32 95),
$
TYPE=HEADING,
SIZE=14,
COLOR=RGB(75 75 75),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR=RGB(0 32 95),
$
-*TYPE=DATA,COLUMN=N2,IMAGE=(ICON_PATH),SIZE=(.3 .3),$
TYPE=TABHEADING,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
COLOR=RGB(75 75 75),
STYLE=BOLD,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=2,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=3,
OBJECT=TEXT,
ITEM=2,
WIDTH=4.181,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=4,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=5,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
WIDTH=1.681,
$
TYPE=TABHEADING,
LINE=6,
OBJECT=TEXT,
ITEM=2,
COLOR='WHITE',
WIDTH=4.181,
$
TYPE=TABHEADING,
IMAGE=IBFS:/WFC/Repository/Images/Logo.jpg,
POSITION=(+0.041667 +0.000000),
SIZE=(1.200000 1.000000),
$
ENDSTYLE
-GOTSTYLE
END