0

hide zeros in replicator columns

Jet Reports Historic Posts

January 29, 2015 14:16

None

Follow

Thank you for the help

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts January 29, 2015 14:35

  Hi,
  
  you have to do it in column "B" and with "Hide+?"
  
  check this http://kb.jetreports.com/article/AA-00522/0/
  
  regards
  jetsetter ;)

• 0
  
  Jet Reports Historic Posts January 29, 2015 22:46

  Thank you very much, it works perfectly fine.
  
  please help me one more last thing for this file , if i need to pull the account name also besides account number, what formula i need to use ? tried NF referencing account number to get name , did not work. if try with NL again next to account number column , it still did not work.
  
  Your help is highly appreciated
  
  Warm regards
  
  
  Ravi

  • gl-account-balance.xlsx
• 0
  
  Jet Reports Historic Posts January 29, 2015 23:09

  I would use NL("First","G/L Account","Name","No.", [CELL REFERENCE TO ACCOUNT NUMBER])
  
  That says, go to the G/L Account table and bring me the Name associated with a specific Account Number.
  
  Make sure it is in the same line as the account number.

• 0
  
  Jet Reports Historic Posts January 30, 2015 08:11

  :D