Hi,

Is there any way to create a parameter screen in FEX with hierarchicaly linked combo boxes?

More clearly,

I need to create a parameter screen FEX which contains SiteName and BuildingNames as two parameters. Once user selects any particular site, only those buildings coming under the selected site should be populated, in BuildingName combo box.

I know this can be done in MAS file using Dimension builder and make an OLAP enabled report using that MAS file. I am looking for an option using FEX coding.

Any help would be appreciable.

Thanks and regards,
Johney.

This message has been edited. Last edited by: Kerry,

This technique is called chaining and is done in the HTML Layout Painter.

There are lots of posts on this topic on the Forum. Start your search with the word 'chain' and go from there.

I think this could be your solution, beneath you find a javascript solution:

This script is based on two fields:
1. a listbox with the first character of the existing suppliers
2. a listbox filled with all suppliers starting with the selected character.

function LETTER_onchange(fexName, objFocus, strParam) {
  var strServer = 'http://ensfocus';
  var strCall   = '/ibi_apps/WFServlet?IBIF_ex=';
  var strTotal  = '';


  // Create a call, including fex and parameter &LETTER, call will create HOLD: !IBI.FIL.SUPPLET
  strTotal  = strServer  + strCall + fexName;
  strTotal += '&LETTER=' + strParam ;


  //--- Pointer naar IFRAME + 'CGI/Servlet-string' als url
  idIframe1     = document.getElementById('iframe1');
  idIframe1.src = strTotal;

  //--- Set focus on listbox
  idstrFocus   = document.getElementById('lbSuppliers');
  idstrFocus.focus();
}

AND


        <select language=java_script id=LETTER onChange='LETTER_onchange["INK00001_SupplierOnName.fex" , "ListboxSuppliers" , this.value);' name=LETTER operation>
       !IBI.FIL.SUPPLET;

This message has been edited. Last edited by: Kerry,