The Lookup checkbox option is used to indicate that the
line is intended to return data that might otherwise not be included on this
report or input screen. In other words, if you wish to force a row to show the
value for Total Revenue from a specific Department, no matter which Department
you are using on your report or input screen, you can set the appropriate
Department code on the line and check the Lookup box. When the report or
input screen is rendered, Prospero will display the requested data, even if the
prompt or security assignments would not normally allow it to be included.
For example, if a line specifies Department 001, there are two scenarios for what Prospero will do when the report is run or the input screen is opened:
1. If the Lookup box is CHECKED, the value for the account within Department 001 will be displayed, regardless of which Department was selected on the prompt screen.
2. If the Lookup box is UNCHECKED, the value for the account within Department 001 will be displayed if and only if Department 001 or a Summary Department which contains Department 001 was selected on the prompt screen. Otherwise, no data will be returned for this line.
It is important to keep in mind that a Lookup line will override the user’s Assignments, which means a user would be able to see data they might otherwise be unable to see.
Note: If the Options Fields checkbox is not checked on the context ribbon, this field will not appear in the Line Definition workspace.