Function 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 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 () function. |
|
YES |
Function Composition
Formula
|
Example
|
Explanation
|
---|---|---|
=ReportFixed( DataPortal ,RowDefRange ,ColDefRange ,Parameters ) |
=ReportFixed( "NorthwindFixed" , B9 : B21 , 1 : 1 , ) |
|
Function Example
From File | Worksheet |
---|---|
From File | Worksheet |
InterjectBasic | ReportFixed |