Focal Point
Cascading prompts

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

May 29, 2007, 10:33 AM
kummy
Cascading prompts
Hi all,

I need to implement cascading prompt in one my report. the scenario is i have
two list boxes in a procedure.

listbox named lb1 has values fetched from the table A applying a filter
condition.

listbox named lb2 has values fetched from the same table A applying a diiferent
filter condition.

my requirement is to make the lb2 display the values dynamically based on the values user select in lb1.

please provide me a solution to implement this.

Thanks,
kummy
May 29, 2007, 10:53 AM
FrankDutch
This issue is all explaned during one of the labs on Summit 2007.
"Building complex parameterized Reports in HTML Layout Painter"
An interesting and very good course by "Cia Kessler"
I thing it must be possible to get both the hand-outs and the fex examples.
It's a bit to mutch to type here all teh coding.

The main thing is that you can link the two listboxes in the painter.

Select the first listbox, hold down the shift key, click the next listbox and then click on the "Add to Chain" button somewhere on top of the screen.




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7