SSRS中整页可见性设置及整页移除方案咨询

Got it, let's tackle this SSRS issue you're facing—hiding entire student report pages without having to tweak every single object's visibility. Here are a couple of solid approaches, including using Custom Code as you asked:

Since you're generating a page per student, you're almost certainly using a grouping mechanism (either a Tablix group or a List control) to split each student's data onto its own page. Instead of hiding individual objects, you can hide the entire group (which corresponds to the student's page) directly:

• Locate the container that groups your student data (right-click the Tablix/List and go to Group Properties).
• Navigate to the Visibility tab.
• Select "Show or hide based on an expression".
• Enter an expression that checks if the student should be excluded. For example:
  • If you have a dataset field IsExcluded (boolean) marking students to remove:

    =Fields!IsExcluded.Value
    

  • If you need to check against a hardcoded list of student IDs:

    =Array.IndexOf(New Integer(){123,456,789}, Fields!StudentID.Value) > -1
    

This will suppress the entire group (and its associated page) from rendering—no need to touch individual objects at all.

If you need more complex exclusion logic (like pulling excluded IDs from a separate dataset or reusing the logic across multiple reports), Custom Code is a perfect fit:

Step 1: Add Custom Code to Your Report #

• Right-click the report background and select Report Properties.
• Switch to the Code tab.
• Paste in VB.NET code to handle the exclusion check. For example:

  Public Function ShouldHideStudent(ByVal studentID As Integer) As Boolean
      ' Example: Hardcode excluded IDs (you could also fetch this from a dataset)
      Dim excludedStudents As New System.Collections.Generic.List(Of Integer)()
      excludedStudents.Add(123)
      excludedStudents.Add(456)
      
      Return excludedStudents.Contains(studentID)
  End Function
  

Step 2: Link the Code to Group Visibility #

Go back to your student group's Visibility expression and call the custom function:

=Code.ShouldHideStudent(Fields!StudentID.Value)

This keeps your exclusion logic centralized and easy to update later, instead of scattering expressions across the report.

• Make sure your page breaks are tied to the student group (in Group Properties > Page Breaks > "Between each instance of a group"). If you're using standalone page breaks, they might leave empty pages—linking breaks to the group ensures hidden groups don't leave ghost pages behind.
• Test both in Report Preview and when exporting to PDF/Excel—sometimes preview behaves slightly differently, so confirm the final output matches what you need.

内容的提问来源于stack exchange，提问作者Rob