Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Creating Report Options Lookups with Multiple Columns

Overview

When creating Reports Options with database lookups, it can be very helpful to the person running the report to have the lookup list contain multiple columns of data.

Example

If we create the lookup function:

=NL("Lookup","G/L Account","No.")

then we get the following in our report options:

lookup1.png

However, if we change our formula to

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

our lookup changes to:

lookup3.png

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.

Published:

Creating Report Options Lookups with Multiple Columns

Overview

When creating Reports Options with database lookups, it can be very helpful to the person running the report to have the lookup list contain multiple columns of data.

Example

If we create the lookup function:

=NL("Lookup","G/L Account","No.")

then we get the following in our report options:

lookup1.png

However, if we change our formula to

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

our lookup changes to:

lookup3.png

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.

For an optimal Community experience, Please view on Desktop