Hiding Rows or Columns

  • Last update:March 12, 2025
  • Overview

    Version

    Report Server VersionFunctional Change
    11.0 /

    Function Description

    Certain cells are only used for intermediate calculations and do not need to be displayed. In this case, you may want to hide the values of these cells, a whole row, or a whole column.

    Hiding Rows or Columns by Direct Setting

    Right-click the label of the row or column you want to hide, select Row Height or Column Width from the pop-up menu, and set Row Height or Column Width to 0. Additionally, you can right-click the row or column label and select Hide directly.

    Hiding Rows or Columns by Setting Row Height or Column Width to Zero Through the Condition Attribute

    In some cases, you may need to display rows or columns when certain conditions are met. Otherwise, you can hide these rows or columns by setting the row height or column width in Condition Attribute.

    Right-click the cell, select Condition Attribute, click + to add a condition, and click + in Attribute to select the attribute to be changed. Select Column Width (which is set to 0 by default) from the drop-down list.

    If the column width of the cell is set to 0 when the current value of the cell is 0 or the cell is left empty, add the formula condition len($$$)=0 or $$$=0. The following figure shows the setting of the condition attribute.

    2.png

    For details, see Cell Hiding by the Condition Attribute.

    Unhiding

    To display the hidden row or column, you must select both the previous and the next rows or columns at the same time, right-click the rows or columns, and select Unhide. Additionally, you can hover the cursor between the two rows or columns next to the hidden row or column. When the cursor has two vertical lines, you can drag the hidden row or column out directly, as shown in the following figure.

    3.png

    Attachment List


    Theme: Designer and Upgrade
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    10s後關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy