I have several NL functions that are nested in each other for this report.
In cell D3 I have NL("Rows","WorkOrders"…)
From that I get the work order number.
Then in cell N4 I have: NL("Rows","WorkOrderItems",{}…,"WorkOrderNumber",E3)
In order to get all of the ItemKeys for this WorkOrder
Then in cell Q5 I have: NL("Rows","WorkOrderSquawks",{}…,"ItemKey",O4)
In order to get all squawkkeys for all items for the original work order number
Then in cell W6 I have NL("Rows","WorkOrderSteps",{}…,"SquawkKey",R5)
In order to get all stepkeys of all steps for the given squawkkey.
Finally in cell AD7 I have NL("Rows","WorkOrderStepsBilling",{}…,"StepKey",X6)
In order to get all billing information about each given step.
My issue, is that the last NL function isn't being nested within the previous NL functions. All the rest of them are, but this one is appearing only once at the very bottom after all other NL functions. It's not even that it is returning blank data, I have changed the cell background to see where it was replicated and this last NL function is not being replicated at all.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hmmm, I doubt that grouping is actually working for any of those replicators. In order to group replicators, you need to use NL("Rows=xx") where xx is the number of rows to copy. so since you want to copy rows 3 - 7 in your outer replicator, you would have to change it to:
=NL("Rows=5","WorkOrders"…)Similarly, you'd change the next formula to:=NL("Rows=4","WorkOrderItems",{}…,"WorkOrderNumber",E3)And so on for the rest. You may also have to copy down the values you need to filter by in subsequent groups so that each NL(Rows) formula if filtering by values in the same row as itself. Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Yes it does help. I actually had the correct Rows =# for the first three sets that I made yesterday, added the second sets today and forgot that I had to do that. Thank you.
Please sign in to leave a comment.