Hi All,
I am New to Jet Reports. I am using Jet Reports 2010. I am creating a report with Sales Invoice Header and Sales Invoice Line From Sales Invoice Header I got Customer Information. From the Sales Invoice Line I need Quantity for all Line Items and Unit Price etc.
I used the following condintion to Link these two Tables.
=NL("Rows","Sales Invoice Line","Document No.","Type","Item","Link=","Sales Invoice Header","No.","=Document No.")
In the Quantity Field I used NF Function =NF(E10,"Quantity").But I got "The Record Key has been correpted or is Invalid" error message
Can any one help me.
Thanks,
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi!
In order to use NF functions, you must have your NL(Rows) function return a record key or field cache. Presently you are returning the unique values of the Document No. field. In order to return a record key, you should leave the field parameter of the NL(Rows) function blank like this:
=NL("Rows","Sales Invoice Line",,"Type","Item","Link=","Sales Invoice Header","No.","=Document No.")
Then you can use NF functions to get the Document No. and Quantity.
Also, you should know that the Sales Invoice Header and Sales Invoice Line are actually linked by Document No. and Document Type. So your formula would be more correct like this:
=NL("Rows","Sales Invoice Line",,"Type","Item","Link=","Sales Invoice Header","No.","=Document No.","Document Type","=Document Type")
Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Yes Thank You
Please sign in to leave a comment.