drop down for selecting Query

[Former Member]

Hi,

I have a webtemplate where in 10 queries are displayed in one webtemplate now my user wants to have one drop down called Report and have all the 10 Queries to be used as the values

So that defaulty the when the user execute the webtemplate it should show all the 10 Queries .As soon as the user selects particular Query from the dropdown box Report it should only display that particular report and hide rest of the reports

How can this be done in WAD 3.5

Regards

Maya

[Former Member]

Maya,

You could consider using tabs - a Tab per report. The presentation look s great on them.

The code for Tabs in 3.5 is in the forum so if you search for it and try it you might achieve what you are looking for.

You could also use the Drop Down web item for views? Save your query as views and reference each of the 10 in the web item. The use gets their drop down option then.

Regards

Gill

[Former Member]

Hi,

For this functionality you have to define a custom Dropdown box with all 10 Query ID and on selecting a Query ID you can open a different template and pass the selected Query as a dataprovider. There is an example code in help to declare a custom Dropdown Box, follow the Navigation: BI Suite: Business Explorer>BEx Web>Web Application Design: BEx Web Application Designer-->Using Forms.

You can find several examples under URL Commands to open a new template and pass the DataProvider

Cheers.

Ranga.