Focal Point
Multiple dropdowns populated with typeFex

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1231018372

February 28, 2008, 01:38 PM
MacLonghorn
Multiple dropdowns populated with typeFex
I have 2 dropdowns on a page that are populated with 2 separate FEXs. Everything is in the same folder. The problem is only one will get populated. When I remove either one, the remaining dropdown gets populated. Here are my selects:

<SELECT id="rptParmWeek" name="rptParmWeek" disabled datafield displayfield datasource="app/prutil02f.fex" datatype="1" sourcetype="typeFex" IBIMR_folder="#productionre" ibiapp_app IBIMR_domain="mydomain/mydomain.htm"></SELECT>
<SELECT id="rptParmWeek" name="rptParmWeek" disabled datafield displayfield datasource="app/prutil01f.fex" datatype="1" sourcetype="typeFex" IBIMR_folder="#productionre" ibiapp_app IBIMR_domain="mydomain/mydomain.htm"></SELECT>


Each proc (prutil01f and prtuil02f) is querying the same table, but using different criteria and returning different columns.

Any ideas?


Thanks.

Mark
WF 7.6 Windows
February 28, 2008, 01:52 PM
Darin Lee
I'm not an HTML guru, but I think the problem is that both of your select boxes are given the same name, so when the fexes are run, they both return values for the drop-down box to the same control. Try changing the name/id's to rptParmWeek1 and rptParmWeek2.


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
February 28, 2008, 02:59 PM
MacLonghorn
Sorry, that was a copy/paste error. They are named differently, with each having their name=id parms.


Thanks.

Mark
WF 7.6 Windows
February 29, 2008, 12:08 PM
Trav
Did you try doing it in the GUI? Sometimes if I flub something up in text I revert back to doing it in the GUI (from scratch) to see if it works there...



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
March 03, 2008, 11:15 AM
MacLonghorn
Yes, I did actually...which is why I was surprised. I know there are some "gotchas" like if you use a master file for chained dropdowns, I think it must be the same master file for both in order to work. I wonder if there's a similar "gotcha" when using a FEX to populate dropdowns. To clarify, my two dropdowns are not chained and they each have their own FEX. The only thing though is that each fex is using the same table, returning different results.


Thanks.

Mark
WF 7.6 Windows
March 03, 2008, 11:35 AM
Darin Lee
Without seeing all of your actual HTML page and fexes, it's hard to go much further. Do you have something simple created using CAR?

There is also another way of doing this that we used before this functionality was put in the GUI. We created fexes to manually construct the HTML for the values in the dropdown boxes and save format alpha, then use -HTMLFORM to the launch page which contains the !IBI.FIL.filename; in the appropriate places. I can give you more details if you can't get it working the other way and need a workaround.


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
March 03, 2008, 12:11 PM
MacLonghorn
Yeah, I know how to do that as well...that is an option I suppose if I don't get this working. I just thought there might be some obscure rule I was missing. I'll try to reproduce the problem with CAR.


Thanks.

Mark
WF 7.6 Windows
March 03, 2008, 12:24 PM
MacLonghorn
ok, here's the code. for dd1.fex:

TABLE FILE CAR
PRINT DST.COUNTRY
ON TABLE PCHOLD FORMAT XML
END

for dd2.fex:

TABLE FILE CAR
PRINT DST.CAR
ON TABLE PCHOLD FORMAT XML
END

To reproduce, it's easy...just add 2 dropdown lists and assign dd1.fex to one, and dd2 to the other.


Thanks.

Mark
WF 7.6 Windows
March 03, 2008, 12:34 PM
Trav
Works perfect for me. Here is the entire HTML that the layout painter produced. Try comparing this to what yours produced.

<!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<TITLE>HtmlPage
</TITLE>
<BASE href=HTTP://kmsbapp2:80>
<META content="MSHTML 6.00.6000.16608" name=GENERATOR>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
}
</SCRIPT>

<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto">
<SELECT id=combobox1 style="Z-INDEX: 1; LEFT: 40px; WIDTH: 280px; POSITION: absolute; TOP: 50px" tabIndex=1 name=combobox1 ibiapp_app IBIMR_folder="#travjunkvacr" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/dd1.fex">
</SELECT>
<SELECT id=combobox2 style="Z-INDEX: 2; LEFT: 40px; WIDTH: 330px; POSITION: absolute; TOP: 110px" tabIndex=2 name=combobox2 ibiapp_app IBIMR_folder="#travjunkvacr" sourcetype="typeFex" datatype="1" datafield displayfield datasource="app/dd2.fex">
</SELECT>
</BODY>
</HTML>




Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
March 03, 2008, 12:54 PM
MacLonghorn
Exact same code. I'm not too surprised though. Frowner


Thanks.

Mark
WF 7.6 Windows
March 03, 2008, 01:31 PM
Trav
Just tried it on 7.6.4 and it worked there too.

Here's the code it produced.
<!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<TITLE>HtmlPage</TITLE>
<BASE href=HTTP://localhost:80>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
</SCRIPT>

<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>

<META content="MSHTML 6.00.3790.2817" name=GENERATOR></HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true">
<SELECT id=combobox1 style="Z-INDEX: 1; LEFT: 50px; WIDTH: 250px; POSITION: absolute; TOP: 30px" tabIndex=1 name=combobox1 datasource="app/dd1.fex" datatype="1" sourcetype="typeFex" IBIMR_domain="developm/developm.htm" IBIMR_folder="#travjunkp0x1" ibiapp_app></SELECT> 
<SELECT id=combobox2 style="Z-INDEX: 2; LEFT: 140px; WIDTH: 280px; POSITION: absolute; TOP: 90px" tabIndex=2 name=combobox2 datasource="app/dd2.fex" datatype="1" sourcetype="typeFex" IBIMR_domain="developm/developm.htm" IBIMR_folder="#travjunkp0x1" ibiapp_app></SELECT> </BODY></HTML>




Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
March 03, 2008, 01:33 PM
Trav
Here is the "FULL" html that is produced in 7.6.4 -- not just what you see on the HTML tab in the HTML painter...

You might compare this to yours just in case...

<!-- Generated by Report Layout Painter -->
<HTML>
<HEAD>
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>

<SCRIPT id=IBI_OptionsScript type=text/javascript>
var rltVersion = "764";
var cgipath = "cgipath";
var ibirls = "ibirls2";

var rltdyncalendar = "rltdyncalendar";
var gmap = "ibigmap";
var olap="olap";
var olappanebase="olappanebase";
var olapdrill="olapdrill";

var ibixmltree="ibixmltree";

var ibiOptions = new Array(cgipath,ibirls);
</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>
<TITLE>HtmlPage</TITLE>
<SCRIPT id=clientEventHandlersJS type=text/javascript>
//Begin function window_onload
function window_onload() {
UpdateData();
// TODO: Add your event handler code here
//add onInitialUpdate() function to make changes before initial run of the reports
}
//End function window_onload
</SCRIPT>

<SCRIPT for=window eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>
</HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true">
<SELECT id=combobox1 style="Z-INDEX: 1; LEFT: 50px; WIDTH: 250px; POSITION: absolute; TOP: 30px" tabIndex=1 name=combobox1 ibiapp_app IBIMR_folder="#travjunkp0x1" IBIMR_domain="developm/developm.htm" sourcetype="typeFex" datatype="1" datasource="app/dd1.fex"></SELECT>
<SELECT id=combobox2 style="Z-INDEX: 2; LEFT: 140px; WIDTH: 280px; POSITION: absolute; TOP: 90px" tabIndex=2 name=combobox2 ibiapp_app IBIMR_folder="#travjunkp0x1" IBIMR_domain="developm/developm.htm" sourcetype="typeFex" datatype="1" datasource="app/dd2.fex"></SELECT>
<INPUT id=layoutinfo style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden inputcontrolids="combobox1;combobox2">
<INPUT id=IBIMR_domain style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=developm/developm.htm name=IBIMR_domain>
<INPUT id=IBIMR_folder style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=#travjunkp0x1 name=IBIMR_folder>
<INPUT id=ibif_ex style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=app/dd1_2_test.htm name=ibif_ex>
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden name=ibiapp_app ismre="1">
<INPUT id=ibic_server style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=EDASERVE name=ibic_server></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
getActiveReportJscript();
setUserInfo();
</SCRIPT>
</HTML>




Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF
March 03, 2008, 02:07 PM
Darin Lee
quote:
Exact same code. I'm not too surprised though


Exact same as compared to what? There are a lot of difference between this and what was in you original post. If it was the exact same code, it would work the same way. (uh.. in theory) Smiler

I think what Trav is trying to say is that this isn't a problem with WF. WF is creating things just fine. There's something in your fex or something else we can't see that is causing the problem. Use the dd1 and dd2 fexes against car and create a new HTML page to run a report including those parms. something like:
TABLE FILE CAR
PRINT COUNTRY CAR
WHERE COUNTRY EQ '&COUNTRY'
WHERE CAR EQ '&CAR'
END

If that works then just make your code "more" exactly like the sample code.


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
March 03, 2008, 05:53 PM
MacLonghorn
I tried each of the HTML code segments posted, adjusting the folders, domains, etc, and it's still not working for me. So I guess there's something else going on.


Thanks.

Mark
WF 7.6 Windows
March 03, 2008, 05:59 PM
Trav
Hate to say it, but I think you're at a point where you need to open a case. This is fairly basic functionality that we're talking about not working. Agreed that it might be a little unique, but not so much that it shouldn't work.

Tech Support is going to want traces and such and that might be the only thing that really reveals what is going on.

It's either going to be something really silly that we're not thinking of or that is configured differently on your end -- or you're looking at some deeper rooted issue...

Good luck.



Production: 7.6.6 WF Server  <=>  7.6.6 WF Client  <=>  7.6.6 Dev Studio
Testing: <none>
Using MRE & BID.  Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF