Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     DISTORTED HTML output IN COMPOUND REPORT

Read-Only Read-Only Topic
Go
Search
Notify
Tools
DISTORTED HTML output IN COMPOUND REPORT
 Login/Join
 
Platinum Member
posted
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


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Expert
posted Hide Post
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


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Master
posted Hide Post
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


WFConsultant

WF 8105M on Win7/Tomcat
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Platinum Member
posted Hide Post
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..


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Master
posted Hide Post
Do you have privilege to see your Webfocus Client?

For this setting no need to restart the webfocus server.


WFConsultant

WF 8105M on Win7/Tomcat
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Platinum Member
posted Hide Post
nope kamesh,

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

Thank you very much


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Master
posted Hide Post
Then you should talk to your Webfocus admin and try this setting on your test server.


WFConsultant

WF 8105M on Win7/Tomcat
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Platinum Member
posted Hide Post
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


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Platinum Member
posted Hide Post
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


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Expert
posted Hide Post
Arvind,

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

Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Master
posted Hide Post
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.


WFConsultant

WF 8105M on Win7/Tomcat
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Platinum Member
posted Hide Post
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>Wink.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


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Platinum Member
posted Hide Post
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>Wink.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

  
  


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Platinum Member
posted Hide Post
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>Wink.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 ..


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Expert
posted Hide Post
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


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Expert
posted Hide Post
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.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Expert
posted Hide Post
First, Ginny,

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

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,


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Expert
posted Hide Post
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).


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Platinum Member
posted Hide Post
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 Red Face...

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


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Platinum Member
posted Hide Post
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 Wink Big Grin Smiler..


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Expert
posted Hide Post
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


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Platinum Member
posted Hide Post
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..


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     DISTORTED HTML output IN COMPOUND REPORT

Copyright © 1996-2020 Information Builders