ReportSave()

Estimated reading time: 6 minutes

Function Summary

The ReportSave function will use a designated DataPortal to save data in a worksheet to a data source. Typically this is done by setting up a DataPortal to run a procedure to take the designated data in the worksheet and save it to a data source. This function makes it convenient to upload local changes to the data source without having to edit it directly.

For an example of this function, see Lab Dev: Customer Aging Detail.

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
If Blank Will save all columns

Type Range
Constraints
If Blank No return data is displayed

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](/wTroubleshoot/Reports.html#validation-report-for-pullsave-events) )
If Blank Data is not filtered

Type Boolean
Constraints
If Blank False

Type Boolean
Constraints
If Blank False

Excel Formula Bar Example

=ReportSave("NorthwindInvoiceSave",B42:B58,12:12,14:14)

Function Composition

Argument Name Example Mapping Explanation
Function Name =ReportSave() The name of this function.
DataPortal "NorthwindInvoiceSave" This function will use the "NorthwindInvoiceSave" DataPortal for the data source.
RowDefRange B42:B58 The unique row IDs are designated to be in column B and the rows 42:58 will be saved.
Col Def Range 12:12 Row 12 is designated to contain the column names that will be saved via the data source.
ResultRange 14:14 Row 14 is designated to contain the column names that will be displayed when returning from the save.
Parameters N/A Data will not be filtered for this save.

Embeddable Helper Functions