Hi,
I am trying to design an Employees report and would like a column to be created per employee experience line (in the Employee Qualification table).
I used that formula : =NL("Columns=3";"Employee Qualification";;"Employee No.";$E5)
… but Jet Report only returns the first line, instead of creating multiple columns.
Any help would be much appreciated !
Thanks,
Date
Votes
1 comment
-
Jet Reports Historic Posts Greetings,
I am assuming that your cell E5 contains multiple Employee numbers separated by a "|" symbol so that multiple employee records will be returned. Is this the case on your report? What is contained within cell E5?
Without specifying a set of fields to return from your "NL(Columns)" function, Jet Reports will return just the field key for each record returned. You can then use NF() functions to retrieve specific fields from the field key within the additional two columns returned for each record (determined by using "Columns=3"), referencing the field key within each NF().
I hope this helps, please let me know if you need further explanation.
Please sign in to leave a comment.