0

KeyName with Multiple Keys

Jet Reports Historic Posts

January 20, 2015 22:59

None

Follow

We've created a report where we want to store viewer data (comments) that relies on two keys. The first key is the order number and the second key is the Line number, but when we refresh the report it is not saving the user data. Attached is a screen shot of the columns (excluding the data column) where we've setup the keyname and the two keys. What are we doing wrong?

• keyname.PNG

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts January 23, 2015 12:03

  Hi
  
  You can only have one intersection of Key and Data in a grid
  
  Regards

• 0
  
  Jet Reports Historic Posts January 23, 2015 13:51

  Put them together with a separator and use that as a key?

• 0
  
  Jet Reports Historic Posts February 11, 2015 15:32

  TeresaRoberts,
  
  Can you explain what you mean by putting them together with a separator?
  
  Thank you,
  
  Amanda

• 0
  
  Jet Reports Historic Posts February 11, 2015 15:37

  You're trying to use two keys, order no. and line no. Example order number ORD002 line no. 10000.
  
  You could do something like NF(NLRef,"Document No.")&"-"&"NF(NF(NLRef,"Line No.")
  
  This would give you ORD002-10000 to use as your key, which would be unique for each line of each order, but only uses one key.