Hi Everyone
I'm new to Jet Reports and to the forum. I've tried searching but haven't found exactly what I was looking for.
I'd like to create a report using 1 table that has multiple versions and each version has multiple lines. I'm trying to extract only the last version with all the corresponding lines with it. Everytime I've tried I can either get either all the versions with all the lines or just the last line of the entire table.
Here's what I've done to get every line:
In Cell F5: =NL("Rows","Production BOM Line",,"+Production BOM No.",$C$2)
In Cell G5: =NF($F5,"Production BOM No.")
In Cell H5: =NF($F5,"No.")
I understand I have to combine the last functions with the rows function, but I'm not sure how to do it without getting a circular reference.
Thanks in advance for any help you can provide.
James
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi James,
I'm not too familiar with this table, but I'll take a shot at answering the question. I'm going to assume that you are trying to get the last Version Code and then replicate all the lines with that version code. So maybe it would work something like this:F5: =NL("Last","Production BOM Line","Version Code","+Production BOM No.",$C$2) G5: =NL("Rows","Production BOM Line",,"Version Code",F5,"+Production BOM No.",$C$2)
Does something like that work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes
Thanks for the quick reply and formula.
The formula works well if I'm looking up 1 Production BOM No. But I forgot to mention that I'd like to look up a range of Production BOM No.'s where the "Last" Version Code could vary from blank to any number and I'd like to see all the corresponding rows with each Production BOM No. Also I would probably run the report using "*" for every Production BOM No. Sorry I should have clarified this in my original post.
Thanks
James
Please sign in to leave a comment.