A control to show/hide an element - Webi 4.1 SP5

[Former Member]

Hi,

I want to hide or show a table and I need to do it with a button, or any other "on-off" control.

I dont want to create any new table at the DB with a boolean value field (or just an integer with "0" and "1" value) and then I can add at the filters pannel a new dimension refering to that table field.

I can use the filter panel, it will be Ok. But I cannot figure out how to do it, like If I was developing a dashboard and add a control as a switch to hide a table.

I appreciate any kind of help.

Thanx in advance.

[saurabh_sonawane · Accepted solution]

Hi

this document can help you

[Former Member · Accepted solution]

Thank you Saurab,

thats the way I've already done it. I've seen your reply late. After, post this message, the day after, with my mind fresher it worked.

I really wanted to add a control at the report but filter panel is nice solution. I hope the client liked the proposal.

THANKS anyway.

[tanveer1]

Hi ,

You can do it with the help of Input controls. Please follow below steps

1. Create a variable with formula as = ""

2. Add this to the table that you want to hide/show as a column

3. Create a new input control with entry field. It should be free text box.

4. Go to the table and right click and navigate to hide when .. and type the formula in the hide when box as formula [new variable] = 1 or "Show".

5. Now type your text either 1 or Show in the free text input control and hit enter to toggle the table.

Hope this helps.

Thanks,

Tanveer.