Interject Documentation > ReportLookup()
Estimated reading time: 1 minuteFunction Summary
Allows the report creator to insert a specific data value into a cell based on certain criteria. Most INTERJECT report functions import a list of data, but this function allows users to choose a specific data column and row and place that data point in a cell.
Used in conjunction with the jDataPortal() helper function, ReportLookup() can access DataPortal data still in the memory from report functions that have already returned data, so there are no additional connections to the data source.
Function Arguments
| Parameter Name | Description | Default | Optional |
|---|---|---|---|
| DataPortal | The name of the INTERJECT Data Portal set up to connect to data. | NO | |
| TargetDataRange | Select a single cell to place the data value. If the DataPortal returns a list of data, this function will return the value from the first row. The helper function [ jDataPortal() ](/wIndex/61702544.html) can be used to further define which row to use from the DataPortal. | NO | |
| ColDefRange | The Column Definition Range defines which column from the database will be used. | NO | |
| Parameters | Select cells which will be used as Parameters for the Data Portal. The cells must use INTERJECT's [ Param ](/wIndex/81756199.html) () function. | YES |
Function Composition
| Formula | Example | Explanation |
|---|---|---|
| =ReportLookup( DataPortal ,TargetDataRange ,ColDefRange ,Parameters ) | =ReportLookup( ** "NorthwindFixed" ** , **B9** , **C1** , ) |
#####