top of page
Jet Reports

Conditional hiding of Columns

Welcome to this tutorial, where we will guide you through using conditional hiding of columns in Jet Reports. This feature is extremely useful and can save you time and effort when managing large amounts of data. With conditional hiding, you can hide entire columns based on certain criteria, making your reports more concise and easier to read.


Let's get started! We have created a simple report with three rows:


  1. Customer No

  2. Customer Name

  3. Balance

Join On Point Academy to view all content


Before we apply conditional hiding, here is what our report looks like:




Our goal is to hide columns where the balance equals zero.


Step 1: Create a Label in Cell A2


The first step is to create a label in cell A2. This label should read "Hide+?" and will be used to identify the columns that you want to hide.



Step 2: Use a Formula to Hide Columns Based on Criteria


Next, use a formula to return "Hide" in a column you want to hide. For example, if you want to hide any rows where the balance in cell D8 is equal to zero, you can use the formula "=IF(D8=0,"Hide","")".



  • Step 3: Run the Report



    After applying the formula and hiding the appropriate rows, run the report to see the changes. Your report should now display only the rows meeting the specified criteria.



In conclusion, conditional hiding of columns is a valuable feature that can make your reports more concise and easier to read. By following the steps outlined in this tutorial, you can easily use conditional hiding to hide columns professionally based on certain criteria.

Get trained
the On Point way

​

From self paced online courses to private training sessions.
Become industry ready.
bottom of page