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.
I have a Line graph that I am displaying in HTML using the HTML Layout Painter. I have a drop down menu where I select a TEAM then when I cubmit it displays the Teams Line graph below in a iFrame. Even with scrolling on or off the labels(which I have set at a 45 degree angle), the first label on the bottom on the left gets cut off. How can I stop the graph from getting cut off?
Here is the code for the HTML I also have the FEX file that creates the image below?
ENGINE SQLMSS SET DEFAULT_CONNECTION SR179
APP PATH NFSSHOLD
DEFINE FILE TEST50
AUX0 = AUX0DEPTAVG * 100;
END
TABLE FILE TEST50
SUM
AUX0/D20.2%
ON TABLE SET PAGE-NUM OFF
ON TABLE SET FORMULTIPLE ON
ON TABLE NOTOTAL
ON TABLE HOLD AS MEDIAN FORMAT FOCUS
END
-RUN
TABLE FILE MEDIAN
PRINT AUX0/D20.2c
ON TABLE HOLD FORMAT ALPHA
END
-RUN
-READ HOLD &AUX0.A20
-SET &AUX00= TRUNCATE(&AUX0);
END
TABLE FILE TEST51
SUM
Total_Hours/D20.18
Aux0/D20.18
Aux0PER/D20.18
AUX0DEPTAVG/D20.18
BY TeamID
BY AGENT
ON TABLE HOLD AS SR2 FORMAT FOCUS
END
DEFINE FILE SR2
Aux0PER0 = Aux0PER * 100;
END
GRAPH FILE SR2
SUM
SR2.SEG01.AUX0DEPTAVG/D20.18 AS '&AUX00 %- Inbound Median'
SR2.SEG01.Aux0PER/D20.18 AS 'AUX 0 - Default'
BY SR2.SEG01.TeamID
BY SR2.SEG01.AGENT AS 'Employee'
WHERE TeamID EQ '&TEAMID';
ON GRAPH SET LOOKGRAPH VLINE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRWIDTH 0
ON GRAPH SET HAXIS 500
ON GRAPH SET VAXIS 205
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(true);
setAxisAssignment(0,0);
setAxisAssignment(1,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),4);
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTitleString("&TEAMID Aux 0 - Default");
setFontSizeAbsolute(getTitle(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setTextJustHoriz(getO1Title(),1);
setFontSizeAbsolute(getO1Title(),true);
setFontSize(getO1Title(),10);
setTextRotation(getO1Title(),0);
setTextWrap(getO1Title(),false);
setTextJustHoriz(getO1Label(),1);
setFontSizeAbsolute(getO1Label(),true);
setFontSize(getO1Label(),10);
setFontStyle(getO1Label(),2);
setTextRotation(getO1Label(),3);
setTextWrap(getO1Label(),false);
setPlaceResize(getO1Title(),0);
setPlaceRotate(getO1Title(),0);
setPlaceAlign(getO1Title(),0);
setPlaceWordWrap(getO1Title(),0);
setPlaceResize(getO1Label(),0);
setPlaceRotate(getO1Label(),0);
setPlaceAlign(getO1Label(),0);
setPlaceWordWrap(getO1Label(),0);
setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
TITLETEXT='Aux 0 - Default',
$
TYPE=REPORT,GRID=OFF,FONT='ARIAL',SIZE=10,BACKCOLOR='NONE',STYLE=NORMAL,$
TYPE=DATA,COLUMN=N4,COLOR='NAVY',$
TYPE=DATA,COLUMN=N3,COLOR=RGB(255 102 0),$
TYPE=DATA,ACROSSCOLUMN=N1,COLOR=RGB(255 102 0),$
TYPE=DATA,ACROSSCOLUMN=N2,COLOR='NAVY',$
TYPE=HEADING,LINE=1,OBJECT=FIELD,ITEM=1,COLOR='BLACK',$
ENDSTYLE
END
END
Currenly working @ Learning Circle Education Services Previously worked @ Nationwide Insurance Prod: WebFOCUS 7.6.11
your I-frame i\you have created is 520*240 the graph is 500*205. I would firts set the frame to 600*300 that might help, but I wonder what the graph will look like if you run the report just without the html startup page.
Would you be so kind to update your signature so we all know what version you use.
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006
it's not a solution but do try to change the font size of the x labels, so you get more free space to the left of the graph. I think than the cut of will disappear. it seems as if the application does not look att the length of the 45 degrees labels.
Frank
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006
Thanks Both! I am doing that and it is viewable, however I already know the biggest complaint is going to be "I can hardly read this!" hehe. If I make the labels vertical then I cannot fit all the graphs I have in one page and this is for a summary page. The 45 degrees helps for people to read. The dilemmas we create!
Currenly working @ Learning Circle Education Services Previously worked @ Nationwide Insurance Prod: WebFOCUS 7.6.11