Hi All,
I am trying to get a JetReport to generate sheets per Person Responsible showing Project-invoices sent for their projects. Problem is that i can't get their names to show on the tabs, only their ID-numbers.
Here is what I made:
First I filter the Job table for all projects related to a specific department (Global Dimension 1 Code) in cell D3:||"NL","AllUnique","Job","No.","Global Dimension 1 Code","=""041""","Global Dimension 2 Code","*","","","","","","","","","","","","","","","",""
Next I filter table Job Ledger Entry for all Jobs with invoices this period in cell D4||"NL","AllUnique","Job Ledger Entry","Job No.","+Job No.","@@*","Global Dimension 1 Code","=""041""","Entry Type","Sale","Posting date","01/01/13..31/10/13","no.","<>1230","+Global Dimension 2 Code","*","","","","","","","",""
Next I want to make a NL=Sheets statement on the Resource table in cell D5, using the field Person Responsible of the Jobs that are the result of the intersection of D3 and D4. I am trying to do this in a single nested formula as given below.=NL("Rows";"Resource";"Name";"No.";NL("Sheets";"Job";"Person Responsible";"No.";NP("intersect";$D$3;$D$4)))This however gives me only 1 sheet, just for the first Resource/Person responsible found.
Problem is that I can only choose for Rows or Sheets keyword; my gut feeling tells me it should rather be "Filter", but that results in a #Value error as I cannot use an array in this statement.
Am I doing things very wrong here? How should I go about it to get the results I want?
Thanks for your tips.
Willem
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Willem,
Try changing that last formula to something like this:=NL("Sheets";"Resource";"Name";"No.";NL("AllUnique";"Job";"Person Responsible";"No.";NP("intersect";$D$3;$D$4)))
Does that help?
Regards,
Hughes -
Jet Reports Historic Posts Hughes,
That helped!
Funny though, When i choose "Filter" in the What-box, it shows "AllUnique" in the completed formula, giving an error when running the report.
Inserting "AllUnique" into the formula results in what I expected to see…..
Anyway, thanks a bundle!!
Willem
Please sign in to leave a comment.