0

Hide or Show Lines

Jet Reports Historic Posts

August 06, 2015 19:47

None

Follow

I have created a report that pulls quantities from various tables. Based on results of those qtys I perform a calculation. I then want to show or hide the prior lines based on the results.

Everything works fine except when I have multiple rows of information. How can I get all prior rows to correctly hide or show.

thanks for your help.

Amy Becker

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts August 07, 2015 14:35

  Hi Amy
  
  The best way to learn this is in the Jet KB.
  
  Conditionally Hiding Rows, Columns or Sheets http://kb.jetreports.com/article/AA-00522
  
  Hope that helps.

• 0
  
  Jet Reports Historic Posts August 12, 2015 15:57

  this part I understand. It is more about I want Row 10 to Hide or show based on the results of row 12.
  
  I can get the condition to look at down 2 rows, but how do I handle when sometimes I want it to look down 2 rows and other times down 3 rows?
  
  My problem is I am looking at table A. Based on Table A look at table B. Based on table A also look at Table C. Now, combine info from Table A, B and C. Based on the results of the combination of table A, B & C Show or hide the info.
  
  So I need to show or hide my original request to table A based on the results of table A, B & C. This is my dilemma. I may have to just hide everything and then based on the results "start over" and show only what I need.
  
  If anyone has any suggestions on how I can do this that would be great.
  
  Thanks,
  
  A Becker

• 0
  
  Jet Reports Historic Posts August 12, 2015 19:27

  You need some excel tricks to make that happen.
  Say, you have 1 line from table A (row 6), 1 line from table B (row 7) and 3 lines from table C (rows 8,9 and 10)
  
  On the rows from table C you make a calculation to know if the row should be shown or not in column E
  E8 = IF(<condition to show>,1,0)
  E9 = IF(<condition to show>,1,0)
  E10 = IF(<condition to show>,1,0)
  
  To make sure the row from table B is only shown when there is at least one row of table C visible you put a SUM in E7:
  E7 = SUM(E8:E11)
  An extra row is needed to make the sum expand when Jet inserts rows.
  
  Same trick for table A
  E6 = SUM(E7:E11)
  
  Now you can use the conditional hide calculation in column B to hide the rows when necessary
  B6 = IF(E6,"Show","Hide")
  B7 = IF(E7,"Show","Hide")
  etc
  B10 = IF(E10,"Show","Hide")
  
  Hope this helps
  
  rmw