0

More companies in one report

Jet Reports Historic Posts

June 30, 2011 19:05

None

Follow

Hi

I am making a report to sum orders for a given period for different companies AAA, BBB etc.:

This formula gives me an error if I specify "Company=";"AAA"

=NL("sum";"sales line";"=nf(;""qty. to invoice"")*nf(;""unit price"")/nl(;""sales header"";""currency factor"";""no."";nf(;""document no.""))";"Requested Delivery Date";Options!$C$8;;;;;;;;;;;;;;;;;"company=";"AAA")

Is it possible to do it - or do I have to specify company in the sum field ?

Br.
mdp12

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts June 30, 2011 20:19 Official comment

  Very nice use of CalcFields. :)
  
  Since the NL function in the CalcField is a separate function, it will pull from the default data source. Unless "AAA" is the default, you would have to specify it in the nested NL as well:
  
  =NL("sum";"sales line";"=nf(;""qty. to invoice"")*nf(;""unit price"")/nl(;""sales header"";""currency factor"";""no."";nf(;""document no."");""company="";""AAA"")";"Requested Delivery Date";Options!$C$8;"company=";"AAA")
  
  Hope this helps!
  
  Best Regards,

• 0
  
  Jet Reports Historic Posts July 01, 2011 09:38

  It is Perfect - thanks a lot :)
  
  Br. mdp12.