Subreport Properties (Visibility Tab, Report Designer)

Use the Visibility tab of the Subreport Properties dialog box to define visibility options for the subreport.

Options

  • Initial visibility
    Select an option to indicate how the subreport is initially displayed on the report.
  • Visible
    Choose this option to show the subreport.
  • Hidden
    Choose this option to hide the subreport.
  • Expression
    Choose this option to vary the initial visibility using an expression.

    Type an expression that evaluates to a Boolean value of True to hide the item and False to show the item. Click the expression (fx) button to edit the expression.

  • Visibility can be toggled by another report item
    Choose this option to indicate that another report item can change the visibility of the subreport.
  • Report item
    Type or select the name of the report item that the user can click to change the visibility of the current subreport. The report item must be a text box in the same grouping or containing grouping as the current subreport.

See Also

Reference

Report Designer F1 Help
Subreport Properties (Data Output Tab, Report Designer)
Subreport Properties (General Tab, Report Designer)
Subreport Properties (Navigation Tab, Report Designer)
Subreport Properties (Parameters Tab, Report Designer)

Other Resources

Adding a Subreport

Help and Information

Getting SQL Server 2005 Assistance