0

NL function "LAST" in Universal DB not working

Jet Reports Historic Posts

March 29, 2017 13:54

None

Follow

Hi, hopefully someone has a suggestion on how I can accomplish this.

I'm using the following NL function that pulls from a Universal SQL data source (Oracle)
NL("last","MBR_PLAN","EXP_DATE","DataSource=","Oracle","MEM ID",H10366,"MEM SFX",I10366)
I'm trying to get the last record in the data source for "EXP Date" but it's returning the first record. Why is this not working correctly and giving me the last record?

I've attached a spreadsheet that reflects the order the datasource is storing the data.

• MBR.xlsx

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts March 29, 2017 17:32

  Hello dmc,
  
  First, your NL(Last) functions require sorting to ensure that you are retrieving the correct data.
  The field that you sort on will determine how the table is sorted before Jet queries the last record.
  If you have not reviewed this KB article, please see NL("Last") Function Requires Sorting: https://jetsupport.jetreports.com/hc/en-us/articles/218953408
  
  Cheers,