ReportFixed()

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
InterjectBasic ReportFixed