Hi Michael,
Basically, all you have to do is add a line on the options worksheet which looks like this:
Column A | Column B | Column C | Column D | Column E
Option | | Material Code | * | =NL("Lookup","Invoice Ledger Entry","Material Code")
Basically the "Option" tag in column A is telling Jet that this row should be presented in the Report Options window. Then if you look at Row 1, you should see tags for "Title", "Value", and "Lookup". So the intersection of "Option" and "Title" is the cell which contains the title of the option. The intersection of "Option" and "Value" is the actual value which you should be filtering on on your report worksheet. The intersection of "Option" and "Lookup" is the lookup formula which tells Jet where to get the data to present the user with if they do a lookup on the Report Options. Does this help?
Regards,
Hughes
Date
Votes
1 comment
-
Jet Reports Historic Posts I am trying to replicate a Jet report that was written for us - but with a couple of alterations
on the 'options' tab there are a few options which create lines in the initial box, so that we can specify things like a date range and specific customer.
On the options sheet, they are NLs set as Lookups, and look something like below:
column A | column B | column C | column D | column E
option | | customer no. | abc1 | NL("Lookup",,"Invoice Ledger Entry","Customer No.","{"ONE", "TWO"})
I may have got the punctuation or layout a bit wrong, but you can see the kind of thing it's meant to do
I want to set mine up so that it prompts for a single type of material from the 'material code' field of the 'Invoice Ledger Entry' table, and then uses that as a filter for the report.
I'm happy setting up the filters in the NF on the main report, but can't get my head around how to make it present an option field in the initial box which it can then refer to.
Any assistance gratefully received.
Thanks
Michael
Please sign in to leave a comment.