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'm using webfocus 7.1 and recently I've been getting complains that a report that I posted on our intranet site is not working for some customers. It's an Employee directory. It has a launch page at the top that filters data based on first name or last name and Organization.For Organization I'm using a listbox which is dynamically populated and for the customers that the report is not working, the listbox is not even populated and the command boutton does not do any thing. Has this ever happened to anybody here? Here's my code minus style. Any help would be greatly appreciated:
< !-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<TITLE>HtmlPage
</TITLE>
<script id=clientEventHandlersJS type=text/javascript>
function button1_OnClick(ctrl)
{
// TODO: add validation code here
if (combobox1.value.length==0)
{
combobox1.value="FOC_NONE";
combobox1.style.color="#ffffff";
OnExecute(ctrl)
combobox1.value="";
combobox1.style.color="#000000";
}
else
OnExecute(ctrl)
}
function combobox1_onload(ctrl)
{
combobox1.focus();
}
function combobox1_onkeydown(ctrl)
{
if(window.event.keyCode==13)
{
OnExecute(button1)
}
}
</SCRIPT>
<script id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls2";
var multidrill = "multidrill";
var mntFormValidate = "mntFormValidate";
var dyncalendar = "dyncalendar";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";
var ibiOptions = new Array(cgipath,ibirls,mntFormValidate,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>
</HEAD>
<BODY>
<iframe id=report1 style="Z-INDEX: 6; BORDER-LEFT-COLOR: #666699; LEFT: 10px; BORDER-BOTTOM-COLOR: #666699; WIDTH: 1500px; BORDER-TOP-STYLE: outset; BORDER-TOP-COLOR: #666699; BORDER-RIGHT-STYLE: outset; BORDER-LEFT-STYLE: outset; POSITION: absolute; TOP: 100px; HEIGHT: 100%; BORDER-RIGHT-COLOR: #666699; BORDER-BOTTOM-STYLE: outset" tabIndex=6 name=report1 src="http://locationofthereport:8080/ibi_apps/WFServlet?IBIF_ex=Nameofthereport1.fex" onload=combobox1_onload(combobox1); executebuttonId="button1" requests_list="0" autoExecute="False" elementtype="2">
</IFRAME>
<INPUT id=combobox1 onkeydown=combobox1_onkeydown[this) style="LEFT: 180px; WIDTH: 150px; POSITION: absolute; TOP: 20px; HEIGHT: 22px" tabIndex=2 accept=0 size=0 name=NAME multiple="false" displayfield="@RETURN_VALUE" datafield="@RETURN_VALUE" addalloption="0" operation="NONE" datasource="sprobab.mas" datatype="0" datafieldtype="INTEGER" sourcetype="typeMaster">
<SPAN id=text1 style="Z-INDEX: 3; LEFT: 340px; WIDTH: 110px; POSITION: absolute; TOP: 20px; HEIGHT: 22px" tabIndex=3>Organization
</SPAN>
<SELECT id=combobox2 style="LEFT: 450px; WIDTH: 370px; POSITION: absolute; TOP: 20px; HEIGHT: 70px" tabIndex=4 multiple size=2 name=Org displayfield="ORGANIZATION" datafield="ORGANIZATION" addalloption="1" operation="OR" datasource="SPROBAB.mas" datatype="1" datafieldtype="CHAR" sourcetype="typeMaster" labelid="text1" accept="0">
</SELECT>
<INPUT language=java_script id=button1 style="Z-INDEX: 4; LEFT: 830px; WIDTH: 80px; POSITION: absolute; TOP: 20px; HEIGHT: 30px" onclick=button1_OnClick[this) tabIndex=5 type=button size=12 value=Search name=button1 requests_list="0">
<SPAN id=text2 style="FONT-SIZE: 10pt; Z-INDEX: 5; LEFT: 10px; WIDTH: 170px; FONT-FAMILY: 'Arial Narrow'; POSITION: absolute; TOP: 20px; HEIGHT: 30px" tabIndex=6>First Name OR Last Name
</SPAN>
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value="dcatest ibisamp ibinccen baseapp" name=ibiapp_app>
<xml id=ibi_requests>
<requests>
<request requestid="0" targetname="report1" ibif_ex="report1" targettype="0" sourcetype="typeAdhocfex" ibiapp_app="">
< ![CDATA[-*-IF &NAME EQ 'FOC_NONE' THEN GOTO SkipSelName;
-*-SkipSelName
-*-IF &Org EQ 'FOC_NONE' THEN GOTO SkipSelOrg;
-*-SkipSelOrg
-SET &NAMELEN='A'||&NAME.LENGTH;
-SET &NAME1=UPCASE(&NAME.LENGTH, &NAME, '&NAMELEN');
-SET &NAME1=IF &NAME1 EQ '' THEN FOC_NONE ELSE &NAME1;
-SET &HowMany=&LINES;
-DEFAULT &NAME=''
DEFINE FILE SPROBAB
L_NAME/A40V=UPCASE(40, LASTNAME, 'A40V');
F_NAME/A30V=UPCASE(30,FIRSTNAME, 'A30V');
END
TABLE FILE SPROBAB
-*WHERE L_NAME LIKE '&NAME1.%';
PRINT
FIRSTNAME AS 'First Name'
LASTNAME AS 'Last Name'
BUSINESSPHONENUMBER AS 'Business Phone ,Number'
BUSINESSMOBILEPHONENUMBER AS 'Business MobilePhone ,Number'
ACTUALPHONENUMBER AS 'Actual Phone ,Number'
LOCATION AS 'Location'
EMAIL AS 'Email'
ORGANIZATION AS 'Organization'
WHERE ORGANIZATION EQ &Org.(OR(FIND ORGANIZATION IN SPROBAB)).Org.;
WHERE L_NAME LIKE '&NAME1.%' OR F_NAME LIKE '&NAME1.%';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
END
-IF &RECORDS GT 0 GOTO RecCount;
-HTMLFORM BEGIN
<h4>Search is complete. No Matches were found.</h4>
-HTMLFORM END
-EXIT
-RecCount
-HTMLFORM BEGIN
<H4>Search returned &LINES Record(s).</H4>
-HTMLFORM END
END]]>
<variables>
<variable field="" file="sprobab.mas" desc="" datatype="0" operation="" name="NAME" accept="0" type="unresolved" select="0">
</variable>
<variable field="ORGANIZATION" file="SPROBAB.mas" desc="Org" datatype="1" operation="OR" name="Org" accept="0" type="unresolved" select="1">
</variable>
</variables>
</request>
</requests>
</xml>
</BODY>
</HTML>
This message has been edited. Last edited by: Robab,
WebFocus 7.1 Developer Studio
Posts: 35 | Location: Tallahassee,Florida | Registered: March 16, 2007
Hi Rohab, Sounds like it's NOT an issue with your html page, but something in your environment. Check to see whats different between one that works and the one that fails. Check the browser versions, settings, javas, etc. Hope this helps. Rich
WebFOCUS 8202 Win 2012 Test - WebFOCUS 8203 on Win 2012
Thanks for responding RichH. Where do I look to check for Java and Javascript versions? I am using javascript version in the report, but is webfocus java-based?
WebFocus 7.1 Developer Studio
Posts: 35 | Location: Tallahassee,Florida | Registered: March 16, 2007
I get the "Page Cannot be dispalyed" error when I click on your link. I took the CSS out of my code and it doesn't have the real name of the reports so I'm sure you'll get an error trying to run it, but I can copy the whole report if you think it helps in diagnosing the problem.
Thank you, Robab
WebFocus 7.1 Developer Studio
Posts: 35 | Location: Tallahassee,Florida | Registered: March 16, 2007
Are the end users all using the same browser? I've ran into problems where listboxes won't populate dynamically from xml hold files when using FireFox. This was a WF bug which is fixed in 7.1.4
WF 7.7.05 HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files HTML, Excel, PDF
Yes. I checked that yesterday and the users that had problem were using IE7 which is the same one I'm using and a lot of other users and none of us is having a problem.
WebFocus 7.1 Developer Studio
Posts: 35 | Location: Tallahassee,Florida | Registered: March 16, 2007
Don't know if you were aware, but there is a software patch if you are using IE7 browser. That doesn't explain why yours works and others don't, but that's one of the first things Tech support will suggest.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
The software patch is it an IE7 patch or a WF patch? I am having issues with when I run a fex and leave the IE window up, then run the fex again I get the error "No query information to decode" If I close the window and run it again it works fine. Any ideas anyone?