0

don't show zero subtotals

Jet Reports Historic Posts

July 25, 2008 14:06

None

Follow

I'm a new user. I created a fixed asset addtion report subtotaling by Posting Group (Posting Category is subtotaled above the group).
Some of the posting groups have no additions.
Is there a way to prevent those subtotal lines (and their related blank detail lines) from appearing?

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts July 25, 2008 14:20

  Hi there Gary.
  
  Jet does support the conditional hiding of rows and columns. Have a look at the last comment in this post from jan.
  
  http://community.jetreports.com/viewtopic.php?f=7&t=259
  
  From what I can see, if you put an if statement around your subtotal to display the total if not zero, otherwise return the word hide. Try these for example:
  
  if(nl(…)=0,"Hide",nl(…))
  or this might work
  
  B5 = nl(…)B2 = if(B5=0,"Hide","")
  Or from a different approach, you could modify your Jet formulas to filter on records where there are are totals, using the nl("Filter") command, so they are not even displayed.
  
  You may need a combination of these two depending on your report structure.

• 0
  
  Jet Reports Historic Posts July 28, 2008 15:04

  Like i said in the topic Mark quoted (thanks for that), the conditional hide will be the easier statement, while the filter will be the more correct…

• 0
  
  Jet Reports Historic Posts July 28, 2008 15:32

  Thanks,
  The hide row function seems to work well. :)