hide/show the sheets

[sonysree88]

I have sheets names in 1st page :   1st page is called main sheet:

like Main :

--sheet1

--sheet2

--sheet3

If i can open the report main sheet should open

if i can click on sheet1 on main page it will go to sheet1 vise versa..

Regards,

Sonysree

[#2]

Hi Sonysree,

Please see below and qvw attached. Is this what you need?

[sonysree88]

Can you please send me the detailed steps ..

I dont have the licensed edition am using personal edition i am unable to open the qvw which you shared it to me..

[vinieme12]

To See  only one sheet at a time, lets take for exampe you have 4 Sheets then

create 4 variables

example

vsheet1

vsheet2

vsheet3

vsheet4

Right Click  on Sheet1 >> Properties >> Select Conditional Show  <<enter variable>> = vsheet1

Repeat the above for each Sheet and add variable for respective sheet

Create a Button / Textbox to show Sheet2  >> Right Click >> Properties >> Actions >>

You need to set 4 Actions for each variable

Set External >> Set a Variable  >>

enter variable name >> vsheet1 

value = 0    //to hide sheet1

enter variable name >> vsheet2

value = 1    //to show sheet2

enter variable name >> vsheet3

value = 0   //to hide sheet3

enter variable name >> vsheet4

value = 0   //to hide sheet4

similarly

Create a Button / Textbox to show Sheet3  >> Right Click >> Properties >> Actions >>

You need to set 4 Actions for each variable

Set External >> Set a Variable  >>

enter variable name >> vsheet1 

value = 0    //to hide sheet1

enter variable name >> vsheet2

value = 0    //to hide sheet2

enter variable name >> vsheet3

value = 1   //to show sheet3

enter variable name >> vsheet4

value = 0   //to hide sheet4

and so on

[sonysree88]

I have created like this but its nt working to me even its not going to other sheets from 1 sheet to another

i want to see 1 sheet at a time

in main page i have to create 3 textboxes like

sheet1

sheet2

sheet3

when i open the dashboard 1st main page only i want to see and after that based on selection sheets should display..

Can you please find the below

[#6]

add action to ur textbox

rightlcick>properties>action>add>layout>activatesheet>shettid(its going be id of each sheet)

[#7]

Hi, apologies for the delay. Here you go

Step 1 - locate sheet ID for sheet1 via sheet properties, screenshot below

Step 2 - go to Main sheet. Add Action to your text object via text object properties, see below

Step 3 - enter sheet ID for sheet1 as below. Repeat these steps for sheet2 & 3.

I hope this make sense. Let me know how you get on.

Warm regards,

Nish

[vinieme12]

have you enabled Show Conditional in Sheet Properties?

the below step??

Right Click  on Sheet1 >> Properties >> Select Conditional Show  <<enter variable>> = vsheet1

Repeat the above for each Sheet and add variable for respective sheet

[sonysree88]

Hi all,

am not expecting to go from one sheet to another sheet

when i click on main page here 3 sheets text boxes will be there

if i can click on sheet1 it should display to sheet1 vice versa

i am following your steps vineeth which you shared

Can you please find the attached QVW and provide me the solution in detailed steps..

[Anonymous · Accepted solution]

Every thing is ok. Just uncheck the Show All Sheets and Objects in Document properties - Security tab.