Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Creating Report Options Lookups with Multiple Columns


Did you know that you can create Reports Options with database lookups and have the lookups contain multiple columns of data?

For example, if we create a formula as =NL("Lookup","G/L Account","No."), then we get the following in our report options.


However, if we change our formula to

=NL("Lookup","G/L Account", {"No.","Name","Account Type"} )

our lookup changes to


When you select a row in the lookup, only the value from the first column is returned to the report, so you want to make sure that you set your first column to the field that you want to use in your filters.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments