Lookup

The Lookup checkbox option is used to indicate that, when the full account mask is referenced in the Line Definition, the row will pull selected data where the prompt value that is selected on the report includes that value.

 

Therefore, if a full account mask indicates that Department 001 is included for the account, when the report is run, when Department 001 or any summary item (i.e. “ALL”) is used which includes that department, data wil be returned. Otherwise, no data will be returned.

 

The ability to access the data associated with using the Lookup field and the row’s full account mask is dependent on the user’s Assignments.

 

Note: If the Options Fields checkbox is not checked on the context ribbon, this field will not appear in the Line Definition workspace.