ReportFixed()

Estimated reading time: 6 minutes

Function Summary

The ReportFixed function pulls data from a data source and inserts it into a spreadsheet. It is similar to the ReportRange function but with the addition of receiving row names as input in addition to column names. Only data that is mapped to both these row and column names from the data source will be inserted. Consequently, the range where data is inserted is defined by the boundaries of the RowDefRange and the ColDefRange. Data returned by this function can be filtered, formatted, and customized for a specific desired report.

For an example of this function, see Create Inventory Fixed Lab.

Function Arguments

Type String/jDataPortal()
Constraints Max 255 char
If Blank Function Error

Type Range
Constraints Must be a single column
If Blank Function Error

Type Range
Constraints Max 500 columns. Must be a single row.
If Blank Will Error

Type Param()
Constraints The values must match the order of the parameters in the data source (The order can be verified using the Validation Report)
If Blank Data is not filtered

Excel Formula Bar Example

=ReportFixed("NorthwindFixed",B14:B27,2:2)

Function Composition

Argument Name Example Mapping Explanation
Function Name =ReportFixed() The name of this function.
DataPortal "NorthwindFixed" This function will use the "NorthwindCustomers" Data Portal for the data source.
RowDefRange B14:B27 The names found in B14:B27 will be used to map to the column names found in row 2 (ColDefRange). Only data that intersects these names will be inserted on these rows.
ColDefRange 2:2 The names found in row 2 will be used to map to the row names found in row B14:B27 (RowDefRange). Only data that intersects these names will be inserted on these columns.
Parameters N/A The data returned from the data source will not be filtered.

Embeddable Helper Functions