Hai all..

I am trying to chain 2 comboboxes where 1st one is static with 3 values.

For 2nd combobox, I wrote a fex which takes value from 1st comboxbox and executes separate report to populate 2nd combobox.
but this is not happening.

My fex looks like this..

-DEFAULT &COMBO1 = ' ';


-IF &COMBO1 EQ 'OPT1' GOTO OP1 ELSE
-IF &COMBO1 EQ 'OPT2' GOTO OP2 ELSE GOTO OP3;

-OP1

TABLE FILE CAR
SUM
COUNTRY
BY COUNTRY
ON TABLE PCHOLD FORMAT XML
END
-GOTO OP3

-OP2

TABLE FILE EMP
SUM
EMPNO
BY EMPNO
ON TABLE PCHOLD FORMAT XML
END
-GOTO OP3

-OP3
-EXIT


Let me know of an issues.
thanks..

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

Are you sure that &COMBO1 is successfully passed to the fex? If it isn't, it's defaulted to blank and you exit the fex.

Yes it is. I used the same technique in running a report based on static value from combobox and it worked with same GOTO technique. But this fails when updating 2nd combobox using chaining..?!

Perhaps it's because no XML is returned if the third value of select list 1 is selected.

I removed the third option. Just have 2 options. Even then it says error..I dont understand why..

With 769, you should do this with conditional chaining. On the Pamameters Canvas, draw a link between combobox1 and combobox2. Combobox one has the static values list. For combobox2, you should click the link between the 2 comboboxes, and in the Properties and Settings dialog that displays, create the default condition for populating combobox2. Then create a new condition for how you want the next static value to affect the population of combobox2. Make sure the Action is "Populate w/a Data" since you will already have the Default condition with its data.

Hope this helps.

Hai David,

Firstly thanks for your input.

But I dont see any option Populate w/a Data. If possible can you be more clear.

Thanks

Does anyone know how to direct the message output that is generated when populating the second control in the chain, to a place where the developer can see it?

I am speakinbg of the focexec code that is submitted to the server in order to generate the HOLD xml. For a submission that returns a report, the messages are imbedded (as comments) in the returned HTML. But the refresh code has no target frame (because its purpose is not to produce a formatted report).

It would be nifty to be able to direct that output to a (tiny) frame, from which one could transfer it to a plain text file (CTL-A, CTL-C; CTL-P) to see what happened. But I have not seen any way to accomplish that.

Enigma006,

When you click the link between the 2 controls, you should get an elongated window named "Properties and Settings". At the top of that window, there is an area called "Action". It defaults to "Populate,Show". The dropdown allows selection of several other actions, one of which is "Populate w/a,show".