0

Heading Line

Jet Reports Historic Posts

January 13, 2014 17:38

None

Follow

Hi All, New to Jet so hopefully this is easy :)

How can I create a Customer Heading line (Cust No & Name) for service invoice lines as follows:

Service Invoice Lines are filtered by Type = Item and a posting date range; so, I can't use either the Customer table or Service Invoice Header since not all Customers & not all Service Invoice Headers (headers without lines = Type "Item") should be displayed on the report. Was looking at links, but I need to select the Service Invoice line first.
Thanks,
Bob

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts January 23, 2014 15:33

  Hi Bob,
  
  You posted this about 10 times, so I deleted the rest of the posts. I'm sure it was just an accident. I'm not sure I understand exactly what you want, but you could do something like this:
  
  =NL("Rows","Customer",,"Link=","Service Invoice Header","Customer No.","=No.","Type","Item")
  Then you could use NF functions to get the No. and Name fields for the customers. Does something like that work for you?
  
  Regards,
  Hughes