Hello, I have a field that I am using as a lookup field using "=NL("Lookup","Dimension Value","Code")". However, when I run the report, what I see in the report options window is just "Program: Lookup" instead of actually looking up the information. I'm sure this is something simple as I am new to jetreports in general. What do you think?
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi,
Can you attach the report (or even just copy your options sheet to a blank workbook and attach that)? Then it might be easier to diagnose what is going on.
Regards,
Hughes -
Jet Reports Historic Posts Sure! Here you go.
-
Jet Reports Historic Posts You need your NL(Lookup) formula in a column with "Lookup" in row 1 rather than "Value". You can put a default value in the Value column and then the Lookup column contains your actual formula. Make sure your formulas reference the value in the Value column since that is where Jet will put the value the user selects in the lookup. I'm attaching your report with the correction. Does this work better for you?
Regards,
Hughes -
Jet Reports Historic Posts Yes, thank you. I had figured it out by looking at the Help menu right before reading your reply.
Thanks again.
Please sign in to leave a comment.