Worksheet

This set of Data Management functions are when dynamic ranges are used i.e., when the number of data rows/columns cannot be predicted. Dynamic ranges are commonly found in discrete reports, reports over a batch, or on-demand reports where the user specifies the report parameters.

The handling of dynamic ranges can be achieved by using an Insert Placement of a data connection, but these functions provide more custom functionality.