hi friends ,

I am facing a very vague problem . I really apologise the way i am presenting the problem .
In my compound report, there are 3 FEXs. I am using Cascading prompt in the same report . Whenever user selects values from the listboxes and clicks run report button . Output is displayed , but sometimes the subfoot is not aligned properly , the border lines are getting distorted , they vanish and then they reappear.

I have used lot of stylesheet commands and alignment commands like headalign , but this issue happens frequently.

But the PDF and EXCEL2K format alignment is fine.

I am facing these issues in HTML ..

Does this happen in compound reports or am i missing something ??

Thank you very much

Arvind,

Because you have missing/NULL data, in conjunction with SQUEEZE, the columns will shrink.
Use HTMTABLE, SQUEEZE=OFF, and WRAP each column to a definitive length, if, the TITLEs don't do it for you...

Hope this helps...

Tom

Arvind,

This may be the issue with your setting.

1. Go to your Webfocus client http:\\servername\ibi_html\wfconsole.htm

2. Select Configuration --> Performance --> Change the setting for WF_BURST_OUTPUT to OFF

HI kamesh ,

I am not able to find the configuration and performance in my webfocus version. Anyway if i find it then i dont have the privilege to restart the server.,,



Tom ,

I tried your suggestion , the report is still distorted.

Thanks Tom
Thank you very much..

Do you have privilege to see your Webfocus Client?

For this setting no need to restart the webfocus server.

nope kamesh,

i dont think so.. Any other suggestions please ??

Thank you very much

Then you should talk to your Webfocus admin and try this setting on your test server.

Yes Kamesh ,

You are right , this seems to be the WF_BURST_OUT issue, but i have one more question this was an issue in WF release 5.3.3 , i am using 7.1.4 , dont you think in this release WF should display reports in excess of 16K in HTML format smoothly without ant alignment issues??

Just a thought>..

Thanks Kamesh everyone

https://forums.informationbuilders.com/eve/forums/a/tpc/...301048331#3301048331


After referring to the above posts , i set WF_BURST_OUT to OFF in CGVIR file. Still, the HTML output is distorted.

Am i missing something??

Thank you people

Arvind,

Post your code, so we can get by this...

Tom

Check in which cgivars.wfs file you did that change. The change should be in Client side cgivars.wfs file .

I am using 7.1.6 version and I too have the same issue as you mentioned.

hi TOM below is my first FEX ..

Styling for the second FEX and third FEX is exactly the same TOM..

-TYPE WEBFOCUS CGIVAR WF_BURST_OUTPTUT=OFF
SET COMPOUND = OPEN
SET HOLDATTR = ON
SET ALL = PASS
SET PRINTPLUS = ON
DEFINE FILE RIPTEST/T_ORA_APPL_CAPBL_LFCY_V
CNT_APPL_LFCY/I8 = IF CNT_APPL_LFCY IS MISSING THEN 0 ELSE CNT_APPL_LFCY;
CNT_APPL_CAPBL/I8 = IF CNT_APPL_CAPBL IS MISSING THEN 0 ELSE CNT_APPL_CAPBL;
CNT_DEV_OWN/I8 = IF CNT_DEV_OWN IS MISSING THEN 0 ELSE CNT_DEV_OWN;
END
-DEFAULT &outcol1 = 'DEV_OWN';
-DEFAULT &outcol2 = 'LNG_N';
-DEFAULT &outcol3 = 'APPL_DESC';
-DEFAULT &outcol4 = 'PRIM_BPO';
-DEFAULT &outcol5 = 'OTHER_BPO';
-DEFAULT &outcol6 = 'APPL_TYPE';
-DEFAULT &outcol7 = 'APPL_LFCY';
-DEFAULT &outcol8 = 'BUS_FNCT_ASSESS';
-DEFAULT &outcol9 = 'PLN_SUNSET_DT';
-DEFAULT &outcol10 = 'PLN_RETIRE_DT';
-DEFAULT &outcol11 = 'ACTL_RETIRE_DT';
-DEFAULT &outcol12 = 'OTHER_CAPBL';
-DEFAULT &asdcol0 = 'HIGHEST';
-DEFAULT &asdcol1 = 'HIGHEST';
-DEFAULT &asdcol2 = 'HIGHEST';
-DEFAULT &asdcol3 = 'HIGHEST';
-DEFAULT &asdcol4 = 'HIGHEST';
-DEFAULT &asdcol5 = 'HIGHEST';
-DEFAULT &asdcol6 = 'HIGHEST';
-DEFAULT &asdcol7 = 'HIGHEST';
-DEFAULT &asdcol8 = 'HIGHEST';
-DEFAULT &asdcol9= 'HIGHEST';
-DEFAULT &asdcol10= 'HIGHEST';
-DEFAULT &asdcol11= 'HIGHEST';
-DEFAULT &WFFMT = 'HTML';
-DEFAULT &BPTW = 'LVL_1_BUS_CAPBL_N';
-DEFAULT &BPTH = 'LVL_2_BUS_CAPBL_N';
-DEFAULT &DO = 'DEV_OWN';
-SET &SORT1 = IF &outcol1 NE '' THEN 'BY &asdcol0.EVAL &outcol1.EVAL ' ELSE '';
-SET &SORT2 = IF &outcol2 NE '' THEN 'BY &asdcol1.EVAL &outcol2.EVAL ' ELSE '';
-SET &SORT3 = IF &outcol3 NE '' THEN 'BY &asdcol2.EVAL &outcol3.EVAL ' ELSE '';
-SET &SORT4 = IF &outcol4 NE '' THEN 'BY &asdcol3.EVAL &outcol4.EVAL ' ELSE '';
-SET &SORT5 = IF &outcol5 NE '' THEN 'BY &asdcol4.EVAL &outcol5.EVAL ' ELSE '';
-SET &SORT6 = IF &outcol6 NE '' THEN 'BY &asdcol5.EVAL &outcol6.EVAL ' ELSE '';
-SET &SORT7 = IF &outcol7 NE '' THEN 'BY &asdcol6.EVAL &outcol7.EVAL ' ELSE '';
-SET &SORT8 = IF &outcol8 NE '' THEN 'BY &asdcol7.EVAL &outcol8.EVAL ' ELSE '';
-SET &SORT9 = IF &outcol9 NE '' THEN 'BY &asdcol8.EVAL &outcol9.EVAL ' ELSE '';
-SET &SORT10 = IF &outcol10 NE '' THEN 'BY &asdcol9.EVAL &outcol10.EVAL ' ELSE '';
-SET &SORT11 = IF &outcol11 NE '' THEN 'BY &asdcol10.EVAL &outcol11.EVAL ' ELSE '';
-SET &SORT12 = IF &outcol12 NE '' THEN 'BY &asdcol11.EVAL &outcol12.EVAL ' ELSE '';
-SET &PARE = IF &BPTW NE 'FOC_NONE' THEN 'TOP_BUS_CAPBL_N' ELSE ' ';
-RUN
SET ORIENTATION = LANDSCAPE
SET NODATA = ''
SET PRINTPLUS = ON
SET HOLDLIST=PRINTONLY
TABLE FILE RIPTEST/T_ORA_APPL_CAPBL_LFCY_V
PRINT DST.TOP_BUS_CAPBL_I
WHERE (LVL_1_BUS_CAPBL_N EQ &BPTW.(OR(FIND LVL_1_BUS_CAPBL_N IN RIPTEST/T_ORA_APPL_CAPBL_LFCY_V)).LVL_1_BUS_CAPBL_N.);
ON TABLE HOLD AS TEMP_TBCN FORMAT ALPHA
END
TABLE FILE TEMP_TBCN
PRINT
COMPUTE V1/I1 = TOP_BUS_CAPBL_I;
ON TABLE HOLD AS TEMP_TB FORMAT ALPHA
END
-RUN
-READ TEMP_TB &TBC_I.I1.
-*TYPE AAA: &TBC_I;
-*IF TOP_BUS_CAPBL_I IN (TEMP_TBCN)
-*EXIT
TABLE FILE RIPTEST/T_ORA_APPL_CAPBL_LFCY_V
BY TOP_BUS_CAPBL_N NOPRINT
BY LVL_1_BUS_CAPBL_N NOPRINT
BY LVL_2_BUS_CAPBL_N NOPRINT
BY SUB_BUS_CAPBL_N NOPRINT
BY APPL_LFCY NOPRINT
&SORT1
&SORT2
&SORT3
&SORT4
&SORT5
&SORT6
&SORT7
&SORT8
&SORT9
&SORT10
&SORT11
&SORT12
WHERE TOP_BUS_CAPBL_I IN FILE TEMP_TB;
WHERE (LVL_1_BUS_CAPBL_N EQ 'NONE');
WHERE DEV_OWN EQ &DO.(OR(FIND DEV_OWN IN RIPTEST/T_ORA_APPL_CAPBL_LFCY_V)).DEV_OWN.;
ON APPL_LFCY SUBHEAD
" Top Business Capability : <TOP_BUS_CAPBL_N "
"Lifecycle : <APPL_LFCY , Total : <CNT_APPL_LFCY "
ON TOP_BUS_CAPBL_N SUBFOOT
" Count Of Applications :<CNT_APPL_CAPBL , Count Of Development owners : <CNT_DEV_OWN "
""
-IF &WFFMT EQ 'EXL2K' THEN GOTO NEXA#;
FOOTING
"PAGE :<TABPAGENO"
""
-NEXA#
ON TABLE SUBHEAD
"APPLICATION LIFECYCLE REPORT"
"TOP LEVEL BUSINESS CAPABILITIES"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<AHTML,AHTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<Excel Formula,EXL2K FORMULA>.Select type of display output. OPEN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='A2',
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
-IF &WFFMT EQ 'PDF' THEN GOTO NEXAA#;
-ELSE GOTO NEXBB#;
-NEXAA#
TYPE=REPORT,
GRID=ON,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
-GOTO DONY#;
-NEXBB#
TYPE=REPORT,
BORDER=LIGHT,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
-DONY#
TYPE=TABHEADING,
SIZE=10,
COLOR='WHITE',
BACKCOLOR=RGB(151 0 0),
STYLE=BOLD,
$
TYPE=DATA,
COLUMN=N4,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N4,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N8,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N6,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N9,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N10,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N11,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N13,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N14,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N16,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N17,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N18,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N19,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N5,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N7,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N15,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
JUSTIFY=RIGHT,
$
TYPE=SUBHEAD,
BY=1,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=2,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=SUBHEAD,
BY=5,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=8,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=SUBFOOT,
OBJECT=TEXT,
STYLE=BOLD,
HEADALIGN=INTERNAL,
COLSPAN=3,
$
TYPE=SUBFOOT,
STYLE=BOLD,
FONT='ARIAL',
$
TYPE=SUBFOOT,
BY=3,
STYLE=BOLD,
HEADALIGN=INTERNAL,
COLSPAN=3,
$
TYPE=SUBFOOT,
BY=4,
STYLE=BOLD,
HEADALIGN=INTERNAL,
COLSPAN=3,
$
TYPE=REPORT,
COLUMN=N8,
WRAP=1.680556,
$
TYPE=REPORT,
COLUMN=N6,
WRAP=1.263889,
$
TYPE=REPORT,
COLUMN=N9,
WRAP=0.763889,
$
TYPE=REPORT,
COLUMN=N10,
WRAP=0.652778,
$
TYPE=REPORT,
COLUMN=N11,
WRAP=1.013889,
$
TYPE=REPORT,
COLUMN=N12,
WRAP=1.305556,
$
TYPE=REPORT,
COLUMN=N13,
WRAP=1.930556,
$
TYPE=REPORT,
COLUMN=N14,
WRAP=1.277778,
$
TYPE=REPORT,
COLUMN=N16,
WRAP=1.125000,
$
TYPE=REPORT,
COLUMN=N17,
WRAP=2.055556,
$
TYPE=REPORT,
COLUMN=N18,
WRAP=1.055556,
$
TYPE=REPORT,
COLUMN=N19,
WRAP=1.625000,
$
TYPE=REPORT,
COLUMN=N5,
WRAP=1.180556,
$
TYPE=REPORT,
COLUMN=N7,
WRAP=1.305556,
$
TYPE=REPORT,
COLUMN=N15,
WRAP=1.180556,
$
ENDSTYLE
END
-RUN

So no need to post it..Do you still think that this issue is due to styling??

Thank you TOM

second fex

SET ALL = PASS
SET ORIENTATION = LANDSCAPE
SET NODATA = ''
SET PRINTPLUS = ON
TABLE FILE RIPTEST/T_ORA_APPL_CAPBL_LFCY_V
BY TOP_BUS_CAPBL_N NOPRINT
BY LVL_1_BUS_CAPBL_N NOPRINT
BY LVL_2_BUS_CAPBL_N NOPRINT
BY SUB_BUS_CAPBL_N NOPRINT
BY APPL_LFCY NOPRINT
&SORT1
&SORT2
&SORT3
&SORT4
&SORT5
&SORT6
&SORT7
&SORT8
&SORT9
&SORT10
&SORT11
&SORT12
WHERE DEV_OWN EQ &DO.(OR(FIND DEV_OWN IN RIPTEST/T_ORA_APPL_CAPBL_LFCY_V)).DEV_OWN.;
WHERE (LVL_1_BUS_CAPBL_N EQ &BPTW.(OR(FIND LVL_1_BUS_CAPBL_N IN RIPTEST/T_ORA_APPL_CAPBL_LFCY_V)).LVL_1_BUS_CAPBL_N.)
AND (LVL_2_BUS_CAPBL_N EQ 'NONE');
ON APPL_LFCY SUBHEAD
" Top Business Capability : <TOP_BUS_CAPBL_N "
"Level 1 Business Capability : <LVL_1_BUS_CAPBL_N"
"Lifecycle : <APPL_LFCY , Total : <CNT_APPL_LFCY "
ON LVL_1_BUS_CAPBL_N SUBFOOT
" Count Of Applications :<CNT_APPL_CAPBL , Count Of Development owners : <CNT_DEV_OWN "
""
ON TABLE SUBHEAD
"APPLICATION LIFECYCLE REPORT"
"LEVEL 1 BUSINESS CAPABILITIES"
ON TABLE SET FOCFIRSTPAGE &FOCNEXTPAGE
-IF &WFFMT EQ 'EXL2K' THEN GOTO NEXB#;
FOOTING
"PAGE :<TABPAGENO"
""
-NEXB#
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<AHTML,AHTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<Excel Formula,EXL2K FORMULA>.Select type of display output.
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='A2',
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
-IF &WFFMT EQ 'PDF' THEN GOTO NEXAC#;
-ELSE GOTO NEXBC#;
-NEXAC#
TYPE=REPORT,
GRID=ON,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
-GOTO DONYR#;
-NEXBC#
TYPE=REPORT,
BORDER=LIGHT,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
-DONYR#
TYPE=DATA,
COLUMN=N4,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N4,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N8,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N6,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N9,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N10,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N11,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N13,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N14,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N16,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N17,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N18,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N19,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=10,
COLOR='WHITE',
BACKCOLOR=RGB(151 0 0),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N5,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N7,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N15,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
JUSTIFY=RIGHT,
$
TYPE=SUBHEAD,
BY=1,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=2,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=SUBHEAD,
BY=5,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=8,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=SUBFOOT,
OBJECT=TEXT,
STYLE=BOLD,
HEADALIGN=INTERNAL,
COLSPAN=3,
$
TYPE=SUBFOOT,
STYLE=BOLD,
FONT='ARIAL',
$
TYPE=SUBFOOT,
BY=3,
STYLE=BOLD,
HEADALIGN=INTERNAL,
COLSPAN=3,
$
TYPE=SUBFOOT,
BY=4,
STYLE=BOLD,
HEADALIGN=INTERNAL,
COLSPAN=3,
$
TYPE=REPORT,
COLUMN=N8,
WRAP=1.680556,
$
TYPE=SUBFOOT,
STYLE=BOLD,
FONT='ARIAL',
HEADALIGN=INTERNAL,
COLSPAN=3,
$
TYPE=REPORT,
COLUMN=N6,
WRAP=1.263889,
$
TYPE=REPORT,
COLUMN=N9,
WRAP=0.763889,
$
TYPE=REPORT,
COLUMN=N10,
WRAP=0.652778,
$
TYPE=REPORT,
COLUMN=N11,
WRAP=1.013889,
$
TYPE=REPORT,
COLUMN=N12,
WRAP=1.305556,
$
TYPE=REPORT,
COLUMN=N13,
WRAP=1.930556,
$
TYPE=REPORT,
COLUMN=N14,
WRAP=1.277778,
$
TYPE=REPORT,
COLUMN=N16,
WRAP=1.125000,
$
TYPE=REPORT,
COLUMN=N17,
WRAP=2.055556,
$
TYPE=REPORT,
COLUMN=N18,
WRAP=1.055556,
$
TYPE=REPORT,
COLUMN=N19,
WRAP=1.625000,
$
TYPE=REPORT,
COLUMN=N5,
WRAP=1.180556,
$
TYPE=REPORT,
COLUMN=N7,
WRAP=1.305556,
$
TYPE=REPORT,
COLUMN=N15,
WRAP=1.180556,
$
ENDSTYLE
END
-RUN

third FEX

SET ALL = PASS
SET ORIENTATION = LANDSCAPE
SET NODATA = ''
SET PRINTPLUS = ON
TABLE FILE RIPTEST/T_ORA_APPL_CAPBL_LFCY_V
BY TOP_BUS_CAPBL_N NOPRINT
BY LVL_1_BUS_CAPBL_N NOPRINT
BY LVL_2_BUS_CAPBL_N NOPRINT
BY SUB_BUS_CAPBL_N NOPRINT
BY APPL_LFCY NOPRINT
&SORT1
&SORT2
&SORT3
&SORT4
&SORT5
&SORT6
&SORT7
&SORT8
&SORT9
&SORT10
&SORT11
&SORT12
WHERE (LVL_1_BUS_CAPBL_N EQ &BPTW.(OR(FIND LVL_1_BUS_CAPBL_N IN RIPTEST/T_ORA_APPL_CAPBL_LFCY_V)).LVL_1_BUS_CAPBL_N.)
AND (LVL_2_BUS_CAPBL_N EQ &BPTH.(OR(FIND LVL_2_BUS_CAPBL_N IN RIPTEST/T_ORA_APPL_CAPBL_LFCY_V)).LVL_2_BUS_CAPBL_N.);
WHERE DEV_OWN EQ &DO.(OR(FIND DEV_OWN IN RIPTEST/T_ORA_APPL_CAPBL_LFCY_V)).DEV_OWN.;
ON APPL_LFCY SUBHEAD
" Top Business Capability : <TOP_BUS_CAPBL_N "
"Level 1 Business Capability : <LVL_1_BUS_CAPBL_N"
"Level 2 Business Capability : <LVL_2_BUS_CAPBL_N"
"Sub Business Capability : <SUB_BUS_CAPBL_N"
"Lifecycle : <APPL_LFCY , Total : <CNT_APPL_LFCY "
ON SUB_BUS_CAPBL_N SUBFOOT
" Count Of Applications :<CNT_APPL_CAPBL , Count Of Development owners : <CNT_DEV_OWN "
""
ON TABLE SUBHEAD
"APPLICATION LIFECYCLE REPORT"
"SUB BUSINESS CAPABILITIES"
ON TABLE SET FOCFIRSTPAGE &FOCNEXTPAGE
-IF &WFFMT EQ 'EXL2K' THEN GOTO NEXC#;
FOOTING
"PAGE :<TABPAGENO"
""
-NEXC#
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<AHTML,AHTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<Excel Formula,EXL2K FORMULA>.Select type of display output. CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='A2',
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
$
-IF &WFFMT EQ 'PDF' THEN GOTO NEXAAX#;
-ELSE GOTO NEXBBX#;
-NEXAAX#
TYPE=REPORT,
GRID=ON,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
-GOTO DONYX#;
-NEXBBX#
TYPE=REPORT,
BORDER=LIGHT,
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
-DONYX#
TYPE=DATA,
COLUMN=N4,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=TITLE,
COLUMN=N4,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N8,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N6,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N9,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N10,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N11,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N12,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N13,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N14,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N16,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N17,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N18,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N19,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N5,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=TITLE,
COLUMN=N7,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TITLE,
COLUMN=N15,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=CENTER,
$
TYPE=TABHEADING,
SIZE=10,
COLOR='WHITE',
BACKCOLOR=RGB(151 0 0),
STYLE=BOLD,
$
TYPE=FOOTING,
JUSTIFY=RIGHT,
$
TYPE=SUBHEAD,
BY=1,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=2,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
JUSTIFY=LEFT,
$
TYPE=SUBHEAD,
BY=5,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=SUBHEAD,
BY=8,
BACKCOLOR=RGB(153 153 153),
STYLE=BOLD,
$
TYPE=SUBFOOT,
OBJECT=TEXT,
STYLE=BOLD,
HEADALIGN=INTERNAL,
COLSPAN=3,
$
TYPE=SUBFOOT,
STYLE=BOLD,
FONT='ARIAL',
$
TYPE=SUBFOOT,
BY=3,
STYLE=BOLD,
HEADALIGN=INTERNAL,
COLSPAN=3,
$
TYPE=SUBFOOT,
BY=4,
STYLE=BOLD,
HEADALIGN=INTERNAL,
COLSPAN=3,
$
TYPE=REPORT,
COLUMN=N8,
WRAP=1.680556,
$
TYPE=REPORT,
COLUMN=N6,
WRAP=1.263889,
$
TYPE=REPORT,
COLUMN=N9,
WRAP=0.763889,
$
TYPE=REPORT,
COLUMN=N10,
WRAP=0.652778,
$
TYPE=REPORT,
COLUMN=N11,
WRAP=1.013889,
$
TYPE=REPORT,
COLUMN=N12,
WRAP=1.305556,
$
TYPE=REPORT,
COLUMN=N13,
WRAP=1.930556,
$
TYPE=REPORT,
COLUMN=N14,
WRAP=1.277778,
$
TYPE=REPORT,
COLUMN=N16,
WRAP=1.125000,
$
TYPE=REPORT,
COLUMN=N17,
WRAP=2.055556,
$
TYPE=REPORT,
COLUMN=N18,
WRAP=1.055556,
$
TYPE=REPORT,
COLUMN=N19,
WRAP=1.625000,
$
TYPE=REPORT,
COLUMN=N5,
WRAP=1.180556,
$
TYPE=REPORT,
COLUMN=N7,
WRAP=1.305556,
$
TYPE=REPORT,
COLUMN=N15,
WRAP=1.180556,
$
ENDSTYLE
END
-RUN

Thanks TOM ..

Arvind,

1. Do you do everything in the GUI? or Do you code outside the GUI?

2. HTML / AHTML do not function in Compound Reports the way PDF, PPT, or EXL2K/EXCEL do.
3. Have you tried TYPE=DATA, COLUMN=N17, WRAP=2.055556, $ instead of TYPE=REPORT, COLUMN=N17, WRAP=2.055556, $ for ALL of these

 
4. ON TABLE PCHOLD FORMAT &WFFMT.(<HTML,HTML>,<AHTML,AHTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<Excel Formula,EXL2K FORMULA>.Select type of display output. 

You do NOT need these in FEX 2 or 3


5. I "JUST" tried a compound report with AHTML; Does not work on 7.6.5. Active Reports ONLY work with drilldowns, it is 1 report, in, XML
6. This is BAD code:

 
-IF &WFFMT EQ 'PDF' THEN GOTO NEXAAX#;
-ELSE GOTO NEXBBX#;

 S/B

-IF &WFFMT EQ 'PDF' GOTO NEXAAX#;
-GOTO NEXBBX#

For HTML and AHTML, your code needs to change. Below is an example, I will hope others will chime in with their thoughts:
At the top of Fex #1:

  
-PROMPT &WFFMT.(<HTML,HTMTABLE>,<Active Report,AHTML>,<PDF,PDF>,<Excel 2000,EXL2K>,<Excel Formula,EXL2K FORMULA>.Select display output. 

Then, create a few variables

 
-SET &RPT = RPT1;
-SET &OUTPUT = IF &WFFMT CONTAINS 'HTML' THEN 'ON TABLE HOLD AS ' | &RPT | ' FORMAT ' | &WFFMT ELSE
-                 'ON TABLE PCHOLD FORMAT ' | &WFFMT;
-SET &OPEN   = IF &WFFMT CONTAINS 'HTML' THEN ' ' ELSE 'OPEN'; 
-SET &CLOSE  = IF &WFFMT CONTAINS 'HTML' THEN ' ' ELSE 'CLOSE'; 

Then REPLACE the code above, #4, with &OUTPUT &OPEN in fex #1, &OUTPUT in Fex #2, &OUTPUT &CLOSE in Fex #3,
ADD, at the top of each fex(2,3) -SET &RPT = RPT2; in Fex #2, -SET &RPT = RPT3; in Fex #3

At the BOTTOM of Fex #3,

 
-IF &WFFMT OMITS 'HTML' GOTO EOJ;
-HTMLFORM BEGIN
<TABLE>
<TR>
<TD>
!IBI.FIL.RPT1;
</TD>
<TD>
!IBI.FIL.RPT2;
</TD>
<TD>
!IBI.FIL.RPT3;
</TD>
</TR>
</TABLE>
-HTMLFORM END
-EOJ

These reports will be side-by-side; if you want them on top, do this:

 

-HTMLFORM BEGIN
<TABLE>
<TR>
<TD>
!IBI.FIL.RPT1;
</TD>
</TR>
<TR>
<TD>
!IBI.FIL.RPT2;
</TD>
</TR>
<TR>
<TD>
!IBI.FIL.RPT3;
</TD>
</TR>
</TABLE>
-HTMLFORM END
-EOJ

All other ideas are welcomed...

Hope this helps...

Tom

Good points, Tom.

Arvind, you really didn't say much about AHTML in your previous posts on this topic. I'm assuming you have a license.

First of all, wrapping doesn't work at all in AHTML. The output is more javascript and XML than html.

Secondly, as Tom so aptly put, you cannot do multiple AHTML reports using the compound syntax you can use with the other standard formats. You can go to the HTML Layout Painter and develop an active dashboard that combines multiple active reports. There are even more capabilities in 7.6.5.

I would definitely take AHTML out of your list of possible output formats.

First, Ginny,

Congratulations on reaching 1000 posts today. You have assisted so many of us, THANKS!!!

Arvind,
I made a couple of mistakes, since I put this together rather quickly:

 
-SET &RPT = 'RPT1';   NEED QUOTES 

&OUTPUT NEEDS TO BE PLACED IN FEX 2 AND 3 FOR RPT2 AND RPT3 TO WORK - SORRY ABOUT THAT

-SET &OUTPUT = IF &WFFMT CONTAINS 'HTML' THEN 'ON TABLE HOLD AS ' | &RPT | ' FORMAT ' | &WFFMT ELSE
-                 'ON TABLE PCHOLD FORMAT ' | &WFFMT;

 

OR

 

-SET &RPT    = IF &WFFMT CONTAINS 'HTML' THEN ' ' ELSE 'RPT1'; 
-SET &OUTPUT = IF &WFFMT CONTAINS 'HTML' THEN 'ON TABLE HOLD ' ELSE 'ON TABLE PCHOLD ';
 

Then, for your output:

 
&OUTPUT &RPT FORMAT &WFFMT &OPEN  Fex 1
&OUTPUT &RPT FORMAT &WFFMT        Fex 2
&OUTPUT &RPT FORMAT &WFFMT &CLOSE Fex 3

Then set &RPT to RPT2 in Fex #2, RPT3 in Fex #3

Different ways to do it, "YOU" may have come up with an alternative as well!!!!!

Tom

This message has been edited. Last edited by: Tom Flynn,

Thank you, thank you very much (said in an Elvis accent)

or

Thank you, thank you so much (said in a Brenda Lee Johnson from The Closer accent).

Tom ,

You are a genius.. thank you for patiently reading my code and finding out the mistakes..

I will defy try your code and let you know..

Ginny , So Sorry , i am not using AHTML format in my compound report..
Dunno y i have written in the WFFMT statement ...

Congratulations Ginny , Hey you forgot the
Hillary clinton accent when she was canvassing

Tom ,

You are a genius..works like a charm...hats off to you..

I learnt one thing..i have a bad habit of assuming things , i thought that even in compound report normal styling for HTML will work.. and I dint tweak the code enough for the output format the way you did..

That was great..will do more research and study more manuals..

I owe a lot to all geniuses and wizards in this forum..

You can send your invoice anytime ..

arvind,

I am nowhere close to a genius, too many senior moments! Experience "always" counts...

Glad it worked out, even with some syntax erros on my part:

 
IF &WFFMT CONTAINS 'HTML' 

S/B

IF &WFFMT CONTAINS 'HTM' 

Could have done without winky, though, definitely don't want to go there.

I have to get in line behind Tony, Ginny, Francis, AND, a few others before I can send my invoice...

Tom

hi tom ,

Never mind the syntax errors , i corrected them,..But what is important is you concpet and the way u tweaked the code..

Yup , you can be on par with the wizards..

I owe a lot to all of you..