Sign Up for Training |
insightsoftware Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

The Record Key Has Been Corrupted or is Invalid


Symptom

While designing or running a report, the following error is displayed:

recordkey.png

Complete text of error message is:

The record key has been corrupted or is invalid.

Cause:

This message typically occurs when an NF function references a cell or function that does not contain a record key.

Resolution

The error can be resolved simply by changing the cell reference in the problematic NF function to point to a record key. 

A record key is an NL function in which the field has been left blank...

For example:

=NL("Rows","Customer")

... so that you can then use NF() functions to retreive individuals field values from the returned record.

Was this article helpful?
0 out of 0 found this helpful

Comments