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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
Graph labels
 Login/Join
 
Platinum Member
posted
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?

 
<!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var rltVersion = "714";
var cgipath = "cgipath";
var ibirls = "ibirls2";
var multidrill = "multidrill";
var mntFormValidate = "mntFormValidate";
var dyncalendar = "dyncalendar";
var olap="olap";
var olappanebase="olappanebase";
var ibixmltree="ibixmltree";
var ibilangtrans="ibilangtrans";
var olapdrill="olapdrill";
var ibiOptions = new Array(cgipath,ibirls,mntFormValidate,ibilangtrans,dyncalendar,olap,olappanebase,olapdrill,multidrill);
</SCRIPT>

<SCRIPT id=IBI_nls src="/ibi_html/javaassist/nls.js" type=text/javascript></SCRIPT>

<SCRIPT id=IBI_ibigbl src="/ibi_html/javaassist/ibi/html/js/ibigbl.js" type=text/javascript></SCRIPT>

<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);</SCRIPT>

<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
<TITLE>HtmlPage
</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
}

function button1_OnClick(ctrl) {
// TODO: Add your event handler code here
OnExecute(ctrl)
}
</SCRIPT>

<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto">
<INPUT language=javascript id=button1 style="Z-INDEX: 1; LEFT: 100px; WIDTH: 70px; POSITION: absolute; TOP: 40px; HEIGHT: 20px" onclick=button1_OnClick(this) tabIndex=1 type=button value=Button name=button1 requests_list="0">
<SPAN id=ITEM1 style="Z-INDEX: 2; LEFT: 10px; WIDTH: 81px; POSITION: absolute; TOP: 10px; HEIGHT: 16px" tabIndex=2>TEAMID
</SPAN>
<SELECT id=combobox1 style="Z-INDEX: 3; LEFT: 100px; POSITION: absolute; TOP: 10px" tabIndex=3 size=1 name=TEAMID sourcetype="typeFex" datafieldtype="INTIGER" datatype="1" requiredfield="104415728" datasource="app/teams.fex" displayfield datafield operation="NONE" accept="0" addalloption="1" labelid="ITEM1" IBIMR_folder="#annuitywi396" IBIMR_dir="#blrqhb0qviiz" ibiapp_app>
</SELECT>
<IFRAME id=iframe1 style="Z-INDEX: 4; LEFT: 10px; WIDTH: 520px; POSITION: absolute; TOP: 70px; HEIGHT: 240px" tabIndex=4 name=chart frameBorder=no scrolling=no>
</IFRAME>
<INPUT id=IBIMR_domain style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=untitled/untitled.htm name=IBIMR_domain>
<INPUT id=IBIMR_folder style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=#blrqhb0qviiz name=IBIMR_folder>
<INPUT id=ibif_ex style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=app/testdash.htm name=ibif_ex>
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=EPDATA name=ibiapp_app ismre="1">
<INPUT id=ibic_server style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=EDASERVE name=ibic_server>
<xml id=ibi_requests>
<requests>

<request requestid="0" sourcetype="typeFex" targettype="0" targetname="chart" ibif_ex="app/b2t98bba.fex" IBIMR_folder="#annuitywi396" IBIMR_dir="#blrqhb0qviiz" ibiapp_app="">

<variables>

<variable field="TEAMID" file="test50.mas" desc="TEAMID" datatype="0" operation="" default="" name="TEAMID" accept="0" type="unresolved" select="0" controltype="8">

</variable>

</variables>

</request>
</requests>
</xml>
</BODY>
</HTML>
 


Graph Code:

 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


Test: WebFOCUS 7.6.11


Dev: WebFOCUS 7.6.11
 
Posts: 125 | Location: Columbus, Ohio | Registered: March 31, 2006Report This Post
Virtuoso
posted Hide Post
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, 2006Report This Post
Platinum Member
posted Hide Post
Ran it without the HTML and same thing happens the 45 angle label gets chopped off. The graphing manual is worthless with explaining that stuff.

Also changed the iFrame to the same size andsame issue.


Currenly working @ Learning Circle Education Services
Previously worked @ Nationwide Insurance
Prod: WebFOCUS 7.6.11


Test: WebFOCUS 7.6.11


Dev: WebFOCUS 7.6.11
 
Posts: 125 | Location: Columbus, Ohio | Registered: March 31, 2006Report This Post
Virtuoso
posted Hide Post
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, 2006Report This Post
Virtuoso
posted Hide Post
quote:
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 agree with Frank, I've had similar issue when doing a graph and changing font seems to help. Not that I do many graphs.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Platinum Member
posted Hide Post
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! Wink


Currenly working @ Learning Circle Education Services
Previously worked @ Nationwide Insurance
Prod: WebFOCUS 7.6.11


Test: WebFOCUS 7.6.11


Dev: WebFOCUS 7.6.11
 
Posts: 125 | Location: Columbus, Ohio | Registered: March 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders