0

Hide Data

Jet Reports Historic Posts

January 14, 2009 21:48

None

Follow

How do I ONLY display data that is false in the logical test? I do not want to see the true data.

Thanks.

• Facebook
• Twitter
• LinkedIn

8 comments

• 0
  
  Jet Reports Historic Posts January 15, 2009 07:48

  I'm not quite sure what you mean? Can you give us an example?

• 0
  
  Jet Reports Historic Posts January 15, 2009 07:49

  P.s Can this topic be moved to the "How do I" part of the forum please?

• 0
  
  Jet Reports Historic Posts January 15, 2009 15:26

  On the attached document, how do I either not generate or hide the data that says "Yes" in column F. I only am interested in viewing the data that says "No" in column F. Do I need to sort and group?
  
  Thanks.
  
  
  Yes, this topic may be moved to the "How do I" part of the forum please.

  • dept.project.comb2.xls
• 0
  
  Jet Reports Historic Posts January 15, 2009 18:47

  Hi Alf6k,
  
  Have you tried this in Cell B23:
  
  =NL("rows";"g/l entry";"entry no.";"g/l account no.";$D$15;"posting date";$D$16;"Global Dimension 1 Code";$D$13;"Global Dimension 2 Code";$D14)
  And may I recommend the person who developed this report to attend a Jet Reports training course? Using NL functions in each and every cell definitely is not the best and most efficient way to create and run reports.

• 0
  
  Jet Reports Historic Posts January 15, 2009 20:06

  That formula works in displaying everything with a "Yes," but not everything with a "No." I am trying to identify entries within a project whose departments don't match the department code in D13. The entries with the incorrect departments are the ones that I want to view. I believe I put a formula similar to this in A23.
  
  =IF($F23="YES","hide")
  
  This formula doesn't work though. Guidance on the correct formula would be great!
  
  Thanks.

• 0
  
  Jet Reports Historic Posts January 15, 2009 20:29

  Hmmm… the filter should be "unequal to". How about…
  
  =NL("rows";"g/l entry";"entry no.";"g/l account no.";$D$15;"posting date";$D$16;"Global Dimension 1 Code";"<>"&$D$13;"Global Dimension 2 Code";$D14)
  There is a section in the Help and Documentation on filtering.

• 0
  
  Jet Reports Historic Posts January 15, 2009 20:51

  Yeah! It worked. Thanks!!!!

• 0
  
  Jet Reports Historic Posts January 16, 2009 07:38

  Great! Glad to hear you get the result you were looking.
  
  As said in the other posting: please contact the Jet Reports Team for their training offerings. You will learn so much more about Jet Reports!