0

NL("Sum") of other Company

Jet Reports Historic Posts

May 07, 2012 11:20

None

Follow

hi everybody,

I have some companies on the same database. When I open an excel file in the JetReports Menu I see the dafault connection with "COMPANY B"

in E3 cell I write the Database Name and in E4 the Company Name= "COMPANY A"
In C10 cell: NL("Rows";"Vendor";;"Connection=";$E$3;"Company=";$E$4)–> this is running ok.
in D10 cell: NF("$C10";"Vendor posting group") –> this is running ok
In E 10 cell: NL("Sum";"Item ledger Entry";"Quantity";"Source No.";NL("Filter";"Vendor";"No.";"Vendor Posting group";$D10);"Connection=";$E$3;"Company=";$E$4)

the e10 function is taking the COMPANY B (default company) and not the company A that is on the E4 cell.

If I put as default company the COMPANY A, it runs ok.

What could it be happening?
Thanks again for your time and help!
NACHO

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts May 07, 2012 14:19

  Hi Nacho,
  
  Your nested NL(Filter) formula needs to have the Company= and Connection= filters in it as well. Change your formula to something like this:
  
  =NL("Sum";"Item ledger Entry";"Quantity";"Source No.";NL("Filter";"Vendor";"No.";"Vendor Posting group";$D10;"Connection=";$E$3;"Company=";$E$4);"Connection=";$E$3;"Company=";$E$4)
  Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts May 07, 2012 15:16

  Yes. Thank you very much!!! :-)
  Rgds,
  NACHO