Interject Documentation > ReportFixed()
Estimated reading time: 1 minuteFunction Summary
Allows the report creator to insert data based on a coordinate match between a row marker and a column marker. For examples and discussion, view the tutorial.
Function Arguments:
| Parameter Name | Description | Default | Optional |
|---|---|---|---|
| DataPortal | The name of the Interject Data Portal which has been set up to connect to data. | NO | |
| RowDefRange | Select a single column range that has the values that compare to the RowDefName field of the data result. Each RowDefName defines a new target range where the records that match the value found in the RowDefName will be inserted. It is not required for a returned dataset to have a column called RowDefName. RowDefRange can look for a different column name if specified in the ColDefRange cell (explained below), which is directly above the RowDefRange column. Explain the **[leftover]** rowdefrange special tag that marks the target range will all records not matching will be presented. | NO | |
| ColDefRange | The Column Definition Range defining which columns from the database will be used by this function. Unlike the [ ReportRange ](/wIndex/61702199.html) function, ColDefRange in ReportFixed can only span a single row. | 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 |
|---|---|---|
| =ReportFixed( DataPortal ,RowDefRange ,ColDefRange ,Parameters ) | =ReportFixed( ** "NorthwindFixed" ** , **B9** : **B21** , **1** : **1** , ) |
Function Example
| From File | Worksheet |
|---|---|
| InterjectBasic | ReportFixed |