Applicable Versions: All Versions

Sometimes you might want to show of hide a field on your report based on the value of an parameter.

This can be achieved by adding the parameter to the report's Page Header then adding some script to the OnFormat event of the report Detail section 

This script will hide the CustomerName field if the Country parameter is ""France"".

Sub OnFormat

  IF Rpt.Sections.item("PageHeader").Controls("Country").text = "France" then

     Rpt.Sections.item("Detail").Controls.Item("CustomerName ").visible = False


     Rpt.Sections.item("Detail").Controls.Item("CustomerName ").visible = True

  End if

End Sub