Grouping and Sorting Properties (Visibility Tab, Report Designer)

Use the Visibility tab of the Grouping and Sorting Properties dialog box to define visibility options for the group.

Options

  • Initial visibility
    Select an option to indicate how the group is initially displayed on the report.
  • Visible
    Choose this option to show the group.
  • Hidden
    Choose this option to hide the group.
  • 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 group.
  • Report item
    Type or select the name of the report item that the user can click to change the visibility of the current group. The report item must be a text box in the same grouping or containing grouping as the group.

See Also

Reference

Report Designer F1 Help
Grouping and Sorting Properties (Data Output Tab, Report Designer)
Grouping and Sorting Properties (Filters Tab, Report Designer)
Grouping and Sorting Properties (General Tab, Report Designer)
Grouping and Sorting Properties (Sorting Tab, Report Designer)

Other Resources

Grouping Data in a Report
Sorting Data in a Report

Help and Information

Getting SQL Server 2005 Assistance