How to hide and show the tables based on two buttons.

[#1]

Hi All,

Could you anyone tell me the way to hide the charts based on two buttons...

Thanks in advance...

[kaushiknsolanki]

Hi,

   Create a variable called  vVisibility.

   Assign value 1.   (Say 1 for show and 0 for hide)

   Go to properties of the chart. -> Caption -> Click on conditional

   Type

   vVisibility = 1

   Create a Button.

   Add action as External -> Set variable -> type Variable name i.e vVisibility

   in value tyep

   if(vVisibility =1,0,1)

   click ok.

Regards,

Kaushik Solanki

[#3]

Sorry I use QV 8.5 version so i dnt have this

  Add action as External -> Set variable -> type Variable name i.e vVisibility.

What can  be done for this......

[#4]

Can any one help me on this issues...

[#5]

Can any one help me on this issues...

[#6 · Accepted solution]

In this case you have to write Macro (Ctrl + M)

Something like this:

Sub ToggleVariable

  Set var_vVisibility= ActiveDocument.Variables("vVisibility")
  If var_vVisibility.GetContent.String = "1" Then
    ActiveDocument.Variables("vVisibility").SetContent "0", false
  Else
    ActiveDocument.Variables("vVisibility").SetContent "1", false
  End If
End Sub

Then your chart should be shown... Let us know if it doesn't work.

Regards,Miha