0

How do I return only the first record of a tied table

Jet Reports Historic Posts

April 24, 2012 21:10

None

Follow

Table 1 has 1 record. It is linking to Table 2 which has numberous records matching the filter link.
How do I return only the FIRST linked record?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts April 25, 2012 10:43

  Using a Limit= 1 on the linked table seems to work even you cannot select Limit= from the Filter options, example:
  
  
  NL("CountUnique";"Sales Line";"Line No.";"Link=";"Sales Header";"Document Type";"=Document Type";"Salesperson Code";"DICK";"Limit=";1)
  
  NL("CountUnique";"Sales Line";"Line No.";"Link=";"Sales Header";"Document Type";"=Document Type";"Salesperson Code";"DICK")