Getting Started #
When you select multiple values for a parameter, the SPLIT() function allows you to generate one worksheet per parameter value, instead of downloading a filtered, consolidated output.
Below are the requirements for this function to work.
- The parameter must be a multi-select parameter. This is created using the IN button.
- Only one parameter per download can utilize the SPLIT() function.
Using Split #
The example below uses the rptAPAging report.
Click the Download button to bring up the parameters form.
Press F4 or double-click in the (Companies) parameter to bring up the TAD Lookup form.
Select multiple values in the list.
Click the Split button.
The selected values will be returned to the parameter field and wrapped by the SPLIT() function.
Click the Download button.
You will see one worksheet per parameter value.
The original worksheet does remain so you can use that to download consolidated totals if needed.
