Dynamic Dropdown [SOLVED]

Hello,
Is there anyway for the second dropdown box to filter the data further? In other words, using the dropdown for COUNTRY will filter the data so that only the country selected is in the active window. However, when you try to filter using the second dropdown, all it does is blink on that selection... not make all other data go away.

TABLE FILE CAR
PRINT CAR
BY COUNTRY
BY SEATS
ACROSS BODYTYPE
ON TABLE SET BYDISPLAY OFF
HEADING
" "
"Performance Matrix"
" "
" "
" For:FOOTING
" "
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
-*ON TABLE SET PAGE-NUM OFF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
SQUEEZE=ON,
$
TYPE=REPORT,
GRID=OFF,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=1,
TOC=1,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=2,
TOC=2,
$
ENDSTYLE
END

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

Windows version 768

Posts: 215 | Registered: March 16, 2006

GinnyJakes

Expert

posted

Hide Post

I'm confused. You don't have any filters (WHERE) with amper variables in your report. Put those in there and create your page with the HTML Layout Painter.

Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google

Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006

Ignored post by GinnyJakes posted

Show Post

Jim Morrow

Platinum Member

posted

Hide Post

Developers Studio has an option to chain drop down boxes. It uses browser side JavaScript for this functionality. All possible values are included in your HTML. This can result in monster sized HTML pages, that take minutes to load.

The method we use is on the server we have FOCUS data bases with the contents of the drop down list boxes. When one list changes we return to the server, and TABLE the data bases using filter derived from the other list boxes and recreate the page. With careful tuning this functions at "Web Speed"

Jim Morrow
Web Focus 7.6.10 under Windows 2003
MVS 7.3.3

Posts: 129 | Registered: June 01, 2005

Ignored post by Jim Morrow posted

Show Post

Tony A

Expert

posted

Hide Post

I think Mark has confused the issue here by mentioning dropdowns when in fact he is refering to the BYTOC facility in HTML which gives a TOC dialog that changes the report contents on selecting the first BY field but only blinks on the second BY field selection.

Mark,

The BYTOC facility is controlled by using a couple of IB JavaScript functions which is designed to give the blinking on the second and subsequent BY values. To change this behaviour you must be willing and able to either modify the IB provided JavaScript or create your own and include in via SET JSURL in you fex.

Why not think about ACCORDIAN reporting?

T