Focal Point
[UNHAPPILY CLOSED] Dev Studio HTML Composer: Why can't I chain two select list boxes?

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

February 02, 2011, 12:03 AM
Francis Mariani
[UNHAPPILY CLOSED] Dev Studio HTML Composer: Why can't I chain two select list boxes?
I have a simple HTML page. I add two select list boxes. I select these two controls and try to chain them by clicking the "Add to chain" button, but it's inactive. Why? Is it because neither have a Parameter assigned? Why do I need parameters?

Puzzled and annoyed.

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 02, 2011, 05:16 AM
Ramkumar - Webfous
Basically in HTML composer, you can chain the list boxes with parameters only...

That too till 714, you can chain only the Dynamically populated control, thro' Datasource or FEX.

But From 769, Staically populated controls can be added as part of chaining.

Please Go through This link.

But Select or List or Radio button without parameters cant be chained at all...


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
February 02, 2011, 11:20 AM
Francis Mariani
Ramkumar, thanks for letting me know. Until IBI describes why, it seems like an arbitrary decision. From an existing form, I want to open a new window that has chained select lists and also a double list control.

I suppose I will have to fake it.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 02, 2011, 01:12 PM
Doug
Francis,

Can you provide that in an example (code)? I'd like to check it out and see what can be done about it.
Doug




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
February 02, 2011, 02:42 PM
Francis Mariani
Created in baseapp:

<!-- Generated by Report Layout Painter -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META id=mycharsetmeta http-equiv=Content-Type content="text/html; charset=ISO-8859-1">
<META id=Generation content="Created in release 7611, Generation 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>
 
<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";
 
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_nlsVars src="/ibi_html/javaassist/nlsvars.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);
addIntlTranslatedJS("composertrans.js");
</SCRIPT>
<TITLE>HtmlPage</TITLE>
<META content="MSHTML 6.00.2900.6049" name=GENERATOR>
<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" persistentuniqueid="compUid_1" nextelementuniquenumber="5" elementtype="21" edaconnectionrequired="false">
<SPAN id=panel1 style="Z-INDEX: 1; LEFT: 60px; WIDTH: 790px; POSITION: absolute; TOP: 50px; HEIGHT: 600px" tabIndex=1 persistentuniqueid="compUid_2" elementtype="34">
<SELECT id=combobox1 style="Z-INDEX: 2; LEFT: 110px; WIDTH: 150px; POSITION: absolute; TOP: 40px" tabIndex=2 persistentuniqueid="compUid_3" name="combobox1"></SELECT>
<SELECT id=combobox2 style="Z-INDEX: 3; LEFT: 110px; WIDTH: 150px; POSITION: absolute; TOP: 80px" tabIndex=3 persistentuniqueid="compUid_5" name="combobox2"></SELECT></SPAN>
<INPUT id=layoutinfo style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden>
<INPUT id=ibiapp_app style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=baseapp name="ibiapp_app">
<INPUT id=ibic_server style="LEFT: -100px; POSITION: absolute; TOP: -100px" type=hidden value=EDASERVE isdataserversarea="1" name="ibic_server">
<xml id=focus_xmlelement>
<script type="text/xml">
<rootxmlnode>
<variables></variables>
<input_controls>
<input_control bindcontrolid="compUid_3" elementtype="8" name="combobox1" id="combobox1" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info></data_info></condition></link></input_control>
<input_control bindcontrolid="compUid_5" elementtype="8" name="combobox2" id="combobox2" multiple="0" onetimepopulated="1">
<link linktype="default">
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
<data_info></data_info></condition></link></input_control></input_controls>
<other_bound_objects></other_bound_objects>
<requests></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>
 



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 03, 2011, 02:19 AM
Ramkumar - Webfous
But Francis,

What's that we are going to achieve by chaining select boxes without any parameters. ?

If Static lists, you can simulate chaining using Javascript itself.

But without any paramters, chaining does not make any much difference I guess....


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
February 03, 2011, 12:18 PM
Doug
Francis,

I took the code which you provided and went to the parameters tab (in the html composer) and assigned a dynamic / embedded procedure using mdbdates.mas which has the following contents
YEAR_NUM WEEK_NUM 
2011 1 
2010 52 
2010 51 
2010 50 
2010 49 
2010 48 
2010 47 
2010 46 
2010 45 
2010 44 
2010 43
More years and weeks follow...

I assicted the first one to year and the second on to week. then I clicked on combobox1 and dragged it (the little gray box) to combobox2. And, Wah La, done with chaining.

Is there something else that I'm missing in the solution which you seek? Cool

Note the embedded code:
SUM FST.MDBDATES.SEG01.WEEK_NUM
 BY MDBDATES.SEG01.WEEK_NUM
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END



Here's the new code
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Created in release 7611, Generation 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>

<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";

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 type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>

<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>

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

<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</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 type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>

<META name=GENERATOR content="MSHTML 8.00.6001.18975"></HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" nextelementuniquenumber="5" persistentuniqueid="compUid_1">
<SPAN style="Z-INDEX: 1; POSITION: absolute; WIDTH: 790px; HEIGHT: 600px; TOP: 50px; LEFT: 60px" id=panel1 tabIndex=1 elementtype="34" persistentuniqueid="compUid_2">
<SELECT style="Z-INDEX: 2; POSITION: absolute; WIDTH: 150px; TOP: 40px; LEFT: 110px" id=combobox1 tabIndex=2 persistentuniqueid="compUid_3" name="combobox1"></SELECT> 
<SELECT style="Z-INDEX: 3; POSITION: absolute; WIDTH: 150px; TOP: 80px; LEFT: 110px" id=combobox2 tabIndex=3 persistentuniqueid="compUid_5" name="combobox2"></SELECT></SPAN>      
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=IBIMR_domain value=webdevel/webdevel.htm type=hidden name="IBIMR_domain">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=IBIMR_folder value=#douglasleee0 type=hidden name="IBIMR_folder">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibif_ex value=app/test_francis.htm type=hidden name="ibif_ex">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value="webdevel storeoperations baseapp" type=hidden ismre="1" name="ibiapp_app">
<xml id=focus_xmlelement>
<script type="text/xml">
	
<rootxmlnode top="20" left="993" width="150" height="130">
		
<variables></variables>
		
<input_controls>
			
<input_control bindcontrolid="compUid_3" elementtype="8" name="combobox1" id="combobox1" multiple="0" onetimepopulated="0" inbinding="1" unresolved="0" top="80" left="163" width="105" height="20">
				
<link linktype="default">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info datatype="1" sourcetype="typeMaster" ibiapp_app="webdevel storeoperations baseapp" datasource="mdbdates.mas" displayfield="MDBDATES.SEG01.YEAR_NUM" ibiformat="I4" dfformat="I4" datafield="MDBDATES.SEG01.YEAR_NUM" modifiedrequest="0">
							
<![CDATA[TABLE FILE mdbdates
SUM FST.MDBDATES.SEG01.YEAR_NUM
 BY MDBDATES.SEG01.YEAR_NUM
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
			
<input_control bindcontrolid="compUid_5" elementtype="8" name="combobox2" id="combobox2" multiple="0" onetimepopulated="0" inbinding="1" unresolved="0" top="87" left="333" width="140" height="20">
				
<link linktype="default" from="compUid_3">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="MDBDATES.SEG01.YEAR_NUM" resolveparameter="YEAR_NUM">
						
<data_info sourcetype="typeMaster" datatype="1" ibiapp_app="webdevel storeoperations baseapp" datasource="mdbdates.mas" displayfield="MDBDATES.SEG01.WEEK_NUM" ibiformat="I2" dfformat="I2" datafield="MDBDATES.SEG01.WEEK_NUM" modifiedrequest="0">
							
<![CDATA[TABLE FILE mdbdates
SUM FST.MDBDATES.SEG01.WEEK_NUM
 BY MDBDATES.SEG01.WEEK_NUM
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control></input_controls>
		
<other_bound_objects></other_bound_objects>
		
<requests></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>





   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
February 03, 2011, 12:28 PM
Francis Mariani
I don't have any parameters in this page because this page is called from a button on a main page. I use Javascript to populate a form element (parameter) on the main page based on the selected values on this popped-up page, hence to parameters here. Of course I will be told that this is not what HTML Composer is designed to do, Perhaps it should be called Parameter Filler-Outer...

Doug, I will give your suggestion a try, thanks.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 03, 2011, 01:29 PM
Ramkumar - Webfous
Values being populated through JavaScipt - Oh Oh...

That way this is really a headache...

Then you need to simulate Chaining as well thorugh JavaScript. I mean write couple of Functions on Onchange event and populate the Select box with needed values.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
February 03, 2011, 02:17 PM
Doug
Francis,

thanks for giving my idea a try... Keep in mind that my way is all HTML Composer.

May I ask: (if I cannot ask, then stop righ here LOL) Why are you using JS to populate these DDLs?
February 03, 2011, 03:08 PM
Francis Mariani
I have a complex main HTML form. On it are several filters that I've decided to populate from a secondary form - a different HTML window containing a double list. I could not fit six double lists on the main form, and probably wouldn't look right GUI wise. My double list HTML form behaves very well - I open it with an onclick, I populate the previously selected values from the main form. Upon Save, I save them to the main form - everything works. Now, I'd like to add a chained select list to the available selections side of the double list.

So, to test, I created a blank html page where I want to set up two select lists that are chained, but I've discovered they must be "bound?" to a parameter, which I don't have. I guess I have to create a dummy fex with a parameter on it and then bring that into my HTML page.

Needless to say I could do this a lot faster and with cleaner code than the GUI...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 04, 2011, 11:53 AM
Doug
That sounds complex enough Sweating... Have you considered doing something like this:

1) Fex to DEFAULT what's need in the Launch Page (LP).
2) -HTMLFORM ... (LP 1) which spawns fex 2.
3) Fex 2: takes the info from LP1 and does a -HTMLFORM (LP 2) with all the previous values
4) LP 2 executes (final fex) which has the parameters need for the binding in LP 2?

OR starting with "LP 2" and "final fex" with the parm:value pairs hidden and passed from LP 1?

I did this at Ford (see Ford Motor Company / Item 1 for a sample). We called it a dual launch page. LP 1 is the top (white section) / LP 2 is the lower (gray section).
February 05, 2011, 12:07 PM
Tony A
What about using a hidden <div> to hold the extra controls?

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
February 06, 2011, 09:31 PM
Francis Mariani
Tony, which controls do I put in a hidden div? And, if it's hidden it won't display in HTML Composer.

I would simply like to chain two select lists and have their values populated by a dynamic execution of a fex. Why on earth do report variables have to be involved?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 07, 2011, 05:56 AM
Ramkumar - Webfous

COntrols
Controls


This will be shown in the painter... But not in The Browser. They can be included in chaining as well.

I have worked out one complex screen this way.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
February 07, 2011, 09:50 AM
Francis Mariani
In my experience with HTML Composer v7.6.8 and v7.6.11, if something is hidden using CSS, it is hidden on the "Design" tab, it may very well be in the "HTML" tab, but that is not the objective of HTML Composer.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 07, 2011, 04:33 PM
Tony A
quote:
which controls do I put in a hidden div?
Which ever ones you wish to
quote:
And, if it's hidden it won't display in HTML Composer.
True, but I was just suggesting another method other than creating a new browser session (or tab etc.) so that all your code would be self cotained and therefore easier to deal with. Using methods mentioned in other posts, you could make these visible whilst manipulating within DS.
In fact I have just coded such a thing because the of the fact that I was already pushing the limits for sum of by fields and across fields in a report (each "cell" is a potential input control) but still had need for input of more data, so I used a div which I style.display = block or none as necessary. As you know, I prefer hand coding but (with rel 7.7.n) I have now taken to using the GUI for as much as I can and then adding the stuff that would be more "challenging" in the GUI. Works for me and that approach has helped me understand the interaction between the new embedded XML section and the ibirls3.js functions etc.

I have used modal dialogues before to give a similar functionality but wouldn't suggest them unless you are definitely only using IE as FireFox doesn't support them.

Good luck

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
February 08, 2011, 12:11 AM
Francis Mariani
Tony, thanks for your assistance - I hope I one day will have your (new-found?) patience with HTML Composer...


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 08, 2011, 04:21 AM
Tony A
quote:
(new-found?) patience
... through necessity Smiler

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
February 16, 2011, 01:07 PM
Dan Pinault
Francis,

I see you are running v7.6.8 so I don't know if this helps or not. In 7.6.9 you can chain controls without the use of any 'parameters'. By this I mean that you don't need to set up the ampervariable in your procedure nor do you need to use the Add Parameter function in the HTML Composer.

The key is setting the 'Resolves Parameter' value in the properties and settings screen for the chain itself. Look at the first example in the code below and notice how listboxes 1 and 2 chain together with no parameters used at all. In the second example notice how I am using ampervariables in the procedure code that populates listbox 5 but I did not need to create any within the HTML page. I did use a -DEFAULT in listbox 5 simply to give it a value for when the page initially loads.

You'll also notice that there is no report procedure associated with the page so I'm not leveraging any parameters used there either.

<!-- Generated by Report Layout Painter -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<META id=mycharsetmeta content="text/html; charset=ISO-8859-1" http-equiv=Content-Type>
<META id=Generation content="Gen 3.0">
<SCRIPT id=IBI_RelCallBack type=text/javascript>function AdjustChildrenPosition(){
}
</SCRIPT>

<SCRIPT id=IBI_OptionsScript type=text/javascript>
var cgipath = "cgipath";
var ibirls = "ibirls3";

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 type=text/javascript src="/ibi_html/javaassist/nls.js"></SCRIPT>

<SCRIPT id=IBI_nlsVars type=text/javascript src="/ibi_html/javaassist/nlsvars.js"></SCRIPT>

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

<SCRIPT id=IBI_ibigblloadCss type=text/javascript>
ibigblloadCss(null);
addIntlTranslatedJS("composertrans.js");
</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 type=text/javascript eventname="onload">window.onload = function() { window_onload(); }</SCRIPT>

<META name=GENERATOR content="MSHTML 8.00.7600.16722"></HEAD>
<BODY style="OVERFLOW: auto" edaconnectionrequired="true" elementtype="21" nextelementuniquenumber="6" persistentuniqueid="compUid_1">
<SELECT style="Z-INDEX: 1; POSITION: absolute; WIDTH: 260px; TOP: 10px; LEFT: 10px" id=listbox1 tabIndex=1 size=3 persistentuniqueid="compUid_2" name="listbox1"></SELECT> 
<SELECT style="Z-INDEX: 2; POSITION: absolute; WIDTH: 330px; HEIGHT: 300px; TOP: 10px; LEFT: 480px" id=listbox2 tabIndex=2 size=20 persistentuniqueid="compUid_3" name="listbox2"></SELECT> 
<SELECT style="Z-INDEX: 3; POSITION: absolute; WIDTH: 260px; TOP: 330px; LEFT: 10px" id=listbox3 tabIndex=3 size=3 persistentuniqueid="compUid_4" name="listbox3"></SELECT> 
<SELECT style="Z-INDEX: 4; POSITION: absolute; WIDTH: 190px; HEIGHT: 440px; TOP: 330px; LEFT: 280px" id=listbox4 tabIndex=4 size=26 persistentuniqueid="compUid_5" name="listbox4"></SELECT> 
<SELECT style="Z-INDEX: 5; POSITION: absolute; WIDTH: 330px; HEIGHT: 300px; TOP: 330px; LEFT: 480px" id=listbox5 tabIndex=5 size=3 persistentuniqueid="compUid_6" name="listbox5"></SELECT> 
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=layoutinfo type=hidden>
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=IBIMR_domain value=dantemps/dantemps.htm type=hidden name="IBIMR_domain">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=IBIMR_folder value=#testbieeulvo type=hidden name="IBIMR_folder">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibif_ex value=app/chainwithoutparm.htm type=hidden name="ibif_ex">
<INPUT style="POSITION: absolute; TOP: -100px; LEFT: -100px" id=ibiapp_app value="oelink enginlink cvlink partslink baseapp dantemp" type=hidden ismre="1" name="ibiapp_app">
<xml id=focus_xmlelement>
<script type="text/xml">
	
<rootxmlnode top="20" left="1157" width="150" height="130">
		
<variables>
		</variables>
		
<input_controls>
			
<input_control bindcontrolid="compUid_2" elementtype="9" name="listbox1" id="listbox1" multiple="0" inbinding="1" unresolved="0" onetimepopulated="0">
				
<link linktype="default">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info datatype="1" sourcetype="typeMaster" ibiapp_app="oelink enginlink cvlink partslink baseapp dantemp" datasource="PERSINFO.mas" displayfield="COUNTRY" ibiformat="A15" dfformat="A15" datafield="COUNTRY" modifiedrequest="0" selectedvalue="USA">
							
<![CDATA[TABLE FILE PERSINFO
SUM FST.COUNTRY
 BY COUNTRY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
			
<input_control bindcontrolid="compUid_3" elementtype="9" name="listbox2" id="listbox2" multiple="0" inbinding="1" unresolved="0" onetimepopulated="0">
				
<link linktype="default" from="compUid_2">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="COUNTRY" resolveparameter="COUNTRY">
						
<data_info datatype="1" sourcetype="typeMaster" ibiapp_app="oelink enginlink cvlink partslink baseapp dantemp" datasource="PERSINFO.mas" displayfield="CITY" ibiformat="A20" dfformat="A20" datafield="CITY" modifiedrequest="0">
							
<![CDATA[TABLE FILE PERSINFO
SUM FST.CITY
 BY CITY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
			
<input_control bindcontrolid="compUid_4" elementtype="9" name="listbox3" id="listbox3" multiple="0" inbinding="1" unresolved="0" onetimepopulated="0">
				
<link linktype="default">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0">
						
<data_info datatype="1" sourcetype="typeMaster" ibiapp_app="oelink enginlink cvlink partslink baseapp dantemp" datasource="PERSINFO.mas" displayfield="COUNTRY" ibiformat="A15" dfformat="A15" datafield="COUNTRY" modifiedrequest="0" selectedvalue="USA">
							
<![CDATA[TABLE FILE PERSINFO
SUM FST.COUNTRY
 BY COUNTRY
-*insert_filters_here
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control>
			
<input_control bindcontrolid="compUid_5" elementtype="9" name="listbox4" id="listbox4" multiple="0" inbinding="1" unresolved="0" top="409" left="373" width="60" height="20" onetimepopulated="0">
				
<link linktype="default" from="compUid_4">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="COUNTRY" resolveparameter="COUNTRY">
						
<data_info modifiedrequest="1" sourcetype="typeMaster" datatype="0" selectedvalue="" ibiformat="A1" accept="0" addalloption="0" operation="NONE">
							
<static_values>
<static value="A" display="A" selected="1"></static>
<static value="B" display="B" selected="0"></static>
<static value="C" display="C" selected="0"></static>
<static value="D" display="D" selected="0"></static>
<static value="E" display="E" selected="0"></static>
<static value="F" display="F" selected="0"></static>
<static value="G" display="G" selected="0"></static>
<static value="H" display="H" selected="0"></static>
<static value="I" display="I" selected="0"></static>
<static value="J" display="J" selected="0"></static>
<static value="K" display="K" selected="0"></static>
<static value="L" display="L" selected="0"></static>
<static value="M" display="M" selected="0"></static>
<static value="N" display="N" selected="0"></static>
<static value="O" display="O" selected="0"></static>
<static value="P" display="P" selected="0"></static>
<static value="Q" display="Q" selected="0"></static>
<static value="R" display="R" selected="0"></static>
<static value="S" display="S" selected="0"></static>
<static value="T" display="T" selected="0"></static>
<static value="U" display="U" selected="0"></static>
<static value="V" display="V" selected="0"></static>
<static value="W" display="W" selected="0"></static>
<static value="X" display="X" selected="0"></static>
<static value="Y" display="Y" selected="0"></static>
<static value="Z" display="Z" selected="0"></static></static_values></data_info></condition></link></input_control>
			
<input_control bindcontrolid="compUid_6" elementtype="9" name="listbox5" id="listbox5" multiple="0" inbinding="1" unresolved="1" onetimepopulated="0">
				
<link linktype="default" from="compUid_5">
					
<condition default="1" name="Default" whattodowithcontrol="0" valuescompareoperator="0" parameterscompareoperator="0" conditionmultiselectoperator="0" resolveparameterfq="STARTSWITH" resolveparameter="STARTSWITH">
						
<data_info datatype="1" sourcetype="typeMaster" ibiapp_app="oelink enginlink cvlink partslink baseapp dantemp" datasource="PERSINFO.mas" displayfield="CITY" ibiformat="A20" dfformat="A20" datafield="CITY" modifiedrequest="1">
							
<![CDATA[-DEFAULT &COUNTRY = 'USA';
-SET &CITYVAL = '''&STARTSWITH.EVAL'||'%''';
TABLE FILE PERSINFO
SUM FST.CITY
 BY CITY
WHERE COUNTRY EQ &COUNTRY.QUOTEDSTRING;
WHERE CITY LIKE &CITYVAL;
ON TABLE PCHOLD FORMAT XML
END
]]></data_info></condition></link></input_control></input_controls>
		
<other_bound_objects></other_bound_objects>
		
<requests></requests></rootxmlnode></script>
</xml></BODY>
<SCRIPT id=IBI_loader type=text/javascript>
doBeforeLoad();
</SCRIPT>
</HTML>


Cheers,

Dan


7.7.05M/7.7.03 HF6 on Windows Server 2003 SP2 output to whatever is required.
February 16, 2011, 07:10 PM
Doug
quote:
UNHAPPILY CLOSED
LOL
March 31, 2011, 12:22 PM
Francis Mariani
Dan,

I just saw your response, thanks very much for letting me know - I'll just have to wait until we upgrade.

Regards,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
April 01, 2011, 01:41 PM
ABT
Francis,
Please PM me your email address to send you a document I've written to do some dynamic chaining. I'd like to post it here or as a technique, but would like a second set of eyeballs on it to make sure it is ready for public consumption. I'm not sure if it is this exact issue, but I recall you having some frustration on the general topic recently.

-ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro