I used a vlookup to reference a hidden sheet looking for the g/l entry no which iterates by one. I then gave it a start value from the report filter and added by one for each entry no. The only problem was when I added this function, the report time jumped from about 5 minutes to about 13 minutes. I was just seeing if anyone else had a solution to this problem.
Date
Votes
2 comments
-
Jet Reports Historic Posts I am using NL("Sheets…..) to expand a list of invoices each on its own tab and I wanted to know if there was a way to auto iterate through each sheet, 1 by 1, so that I could display the new invoice number? It is being pulled from the G/L because there is no posted invoices for these transactions. I need to be able to tell the report a start number and iterate up until the end of all of the invoices.
-
Jet Reports Historic Posts Hi,
No you can't iterate through sheets. Excel and Jet are really a Functional programming language paradigm. Iteration is something you do in an Imperative language paradigm, so I think you're thinking about the problem in slightly the wrong way. On the initial sheet that you have your NL(Sheets) function, you should create functions which reference the value from the NL(Sheets) function and display the correct invoice number (or no invoice number) based on the value replicated by NL(Sheets). Sometimes to accomplish this you may need to use Excel IF functions, VLOOKUP functions etc., but it should be possible. Does this help at all?
Regards,
Hughes
Please sign in to leave a comment.