Hide detailed report tab and display when i click button

[Anonymous]

hi friends,

i have summary data values in text object ,under object i have one link like "click here to view detailed report".

but detailed report contained tab should be hide until i click the url.

how to achieve this show tab when i click URL->action->activate sheet

any sample app would be appreciated

thanks in advance

[Anonymous]

Two variables - set during load

Check the button properties.

Also look at the macro code in Tools -> Edit module

[Anonymous]

Forgot to mention that you also need to set a conditional statement in the Detailed Sheet properties to conditionally show/hide the sheet based on the value of the vShowDetails variable.

[Anonymous]

hi Taylor,

thanks for your suggestion

can we do this with out Macro?

[Anonymous · Accepted solution]

Updated version without macros.

[Anonymous]

This version just uses 2 actions on the button properties to set the appropriate variables which are read for the button and the sheet visibility properties.

I like this solution better.

[Anonymous]

hi Taylor,

thanks for your suggestion

Its worked Perfectly