0

hide a row if the value is equal to zero?

Jet Reports Historic Posts

September 24, 2013 18:40

None

Follow

Is there a way to hide a row in jet reports if the value is equal to zero?

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts September 24, 2013 21:43 Official comment

  Yes, and I have to admit I was thrilled to find that there are ways to do a Conditional HIDE.
  This can be done with either rows or columns.
  
  To conditionally hide rows - in cell B1 enter HIDE+?
  Then in column B, type your formula to determine which rows to hide.
  
  FOR EXAMPLE: the value you are looking at is in column C, and data starts at C6
  In B6, the formula would be: =IF(C6=0,"Hide","Show")

• 0
  
  Jet Reports Historic Posts September 27, 2013 15:30

  Thank you Heather. Very much appreciated.