Hiding a column in WAD

[Former Member]

I have a dropdown box for calendar year

Intitally when I run my webtemplate it should show me the values for all the years in the below format

Industry -

---

Value2006 -

---

Value2005

When I select from the dropdown value of the calendar year = 2006 then it should me only the values of 2006 & hide value of 2005 & when I select calendar year = 2005 then it should me only the values of 2005

Pls provide me the code for this in WAD 3.5

Thanks

SVR

[Former Member]

SVR,

Your web item Drop Down box is linked to the data provider that is display the results?

If it is, surely when you make a selection from the Drop Down box the dataproviders associated with it (there can be more than one) will change automatically. You shouldn't need any additional code bar standard functionality?

Maybe I'm missing something in the query you are asking.

Regards

Gill

[Former Member]

hi....use two variable (FROM and TO) for calender year. Set default value as 2005 and 2006. Then selelct only 2006 for both FROM and TO variable. Insert these variables as dropdown in WAD.

[Former Member]

Hi Lokesh,

Thanks for ur reply but totall I have 2 values 2004,2005,2006

how can I insert these variables in dropdown

[Former Member]

hi.....since you will have two variables (defined as range.....they are not single values, define variables as range)....you can select any number of values for calender year.

in WAD, you have dropdown item. In that dropdown item, you have variable option. It will accept only variables available in the infoproviders/query used in WAD.

[Former Member]

Hi,

But Whatever I have told are restricted keyfigures

I have one keyfigure called value

now I have created 3 RKFS Ex:- value for 2004 is restricted with Calyear>2004 & Keyfigure>value

Based on the values which i select in the dropdown the table should display that value

[Former Member]

hi.....you will be restricting the key figures with charecteristic value called calender year. In the filter area, define two variables (as range) to this calender year. Your problem will be solved.

[Former Member]

If I give as 2004 as input to variable this will give the same data in all the coulmns

[Former Member]

just have only one key figure. And assign the variables to the filter. When you assign, dont select single value. Below that you have multiple values or ranges. Select that option. In that option define two different variables for FROM and TO.