0

creating a report list with no primary key

Thorn Sothearith

July 31, 2017 01:58

None

Follow

hi,

I trying to create a report list with a table with no primary key, but I get error,

can suggest me some ideas?

thank you.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Matthew Wilson August 04, 2017 17:08

  Hello Thorn,

   

  When building a report against a table that does not have a Primary Key you must use a field cache if you are using NF() functions.

  A field cache is added to the 'Field' section of your NL(Rows) function and must contain all of the fields being returned by your NF() functions as well as any additional fields that would make the cache unique and is wrapped in curly brackets.

  e.g.

  C4: =NL("Rows","TableName",{"Field1","Field2","Field3","Field4"},"FilterField1","FilterValue1")

  D4: =NF($C4,"Field1")

  E4: =NF($C4,"Field2")

  F4: =NF($C4,"Field3")

  G4: =NF($C4,"Field4")

   

  Best regards,

  Matthew Wilson

  Edited by Matthew Wilson August 04, 2017 17:09