0

Combine Tables (Display, not just filter)

Jet Reports Historic Posts

November 05, 2008 22:45

None

Follow

Need to report header information with line detail information on single line of report.

Sales Invoice Line:
=NL("Rows","Sales Invoice Line",,"Document No.","*","Posting Date",Options!$D$5)

Column "Customer":
=NF($D5,"Bill-to Customer No.")

I need to bring in the Bill-to Customer Name from the Sales Invoice Header (or, from the Customer table, either one) and display it on the same line as the Bill-To Customer No., in the next column.

Can someone guide me through this? Specific code would be helpful, but I'll take generic…I'm stuck and I've only just begun!!!

Thanks
Kevin

Navision 5.0 (aka 4.00SP1)
JetReports 7.1.2 Build 1820
Excel 2003
Novice/Beginner

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts November 06, 2008 14:37

  Kevin,
  
  Let us assume that you have in cell H5 the following;
  =NF($D5,"Document No.")then to get the "Bill-to Customer Name" is easy, just use
  =NL("First","Sales Invoice Header","Bill-to Customer Name","No.",H5)
  or if you want to get it from the customer table and your
  =NF($D5,"Bill-to Customer No.") is in cell G5, then use
  =NL("First","Customer","Name","No.",G5)

• 0
  
  Jet Reports Historic Posts November 06, 2008 15:05

  Nice. And clean!
  I appreciate that.
  Kevin