Multiple dropdowns populated with typeFex

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

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Platinum Member

posted

Sorry, that was a copy/paste error. They are named differently, with each having their name=id parms.

Thanks.

Mark
WF 7.6 Windows

Posts: 150 | Registered: July 26, 2007

Ignored post by MacLonghorn posted

Platinum Member

posted

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

Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005

Ignored post by Trav posted

Platinum Member

posted

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

Posts: 150 | Registered: July 26, 2007

Ignored post by MacLonghorn posted

Darin Lee

Virtuoso

posted

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

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Platinum Member

posted

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

Posts: 150 | Registered: July 26, 2007

Ignored post by MacLonghorn posted

Platinum Member

posted

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

Posts: 150 | Registered: July 26, 2007

Ignored post by MacLonghorn posted

Platinum Member

posted

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

Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005

Ignored post by Trav posted

Platinum Member

posted

Exact same code. I'm not too surprised though.

Thanks.

Mark
WF 7.6 Windows

Posts: 150 | Registered: July 26, 2007

Ignored post by MacLonghorn posted

Platinum Member

posted

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

Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005

Ignored post by Trav posted

Platinum Member

posted

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

Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005

Ignored post by Trav posted

Darin Lee

Virtuoso

posted

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)

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

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Platinum Member

posted

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

Posts: 150 | Registered: July 26, 2007

Ignored post by MacLonghorn posted

Platinum Member

posted

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

Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005

Ignored post by Trav posted