Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Conditionally Hiding Rows, Columns or Sheets


Beginner

Overview

Automatically hiding entire rows or columns can be accomplished by including the HIDE keyword in the first cell of the column or row you want to hide:

hiding0.jpg

Always hiding a worksheet (once a report has been run) can be accomplished by using the keywords AUTO+HIDE+HIDESHEET in cell A1 of that worksheet.

Occasionally, you may want to hide entire rows, columns, or even worksheets - all based on some criteria that may or may not be present. This is referred to as Conditional Hiding.

Hiding a Row

  1. Place HIDE+? in cell B1

    hiding1.jpg
  2. Use a formula to return Hide in column B of any row you want hidden.

    In this example, let's hide any row where the Balance (in column E) is equal to zero.

    hiding2.jpg
  3. When we run the report...

    hiding3.jpg

    we see that there are no zero balances and we can see that rows 4-10, 12-14, and 19 have been hidden.

Hiding a Column

  1. Place HIDE+? in cell A2

    hiding4.jpg
  2. Use a formula to return Hide in row 2 of any column we want to hide.

    In this example, let's hide the column if the Balance (in row 6) is equal to zero.

    hiding5.jpg
  3. When we run the report...

    hiding6.jpg

    we see that there are no zero balances and we can see that columns C-J and L-N have been hidden.

Hiding a Sheet

Similar to hiding a column, you can also hide an entire sheet

  1. Place HIDE+? in cell A2

    hiding7.jpg
  2. Use a formula to return HideSheet in cell B2 if our condition is met.

    In this example, let's hide the worksheet if the Grand Total (in cell F6) is less than a particular amount.

    hiding8.jpg
  3. When we run the report...

    hiding9.jpg

    we see that the entire Report sheet has been hidden.


Was this article helpful?
3 out of 3 found this helpful
Have more questions? Submit a request

Comments