When building a data set, you have the option to change the output from the default One Row per Request setting. This controls how data will display in reports that are run using this data set.
Depending upon the type of reports you intend to run with the data set, changing the output can allow you to see the level of detail with the data as expected. For example, if you are running an evaluation report, you would likely want to see data for each evaluation for each request. Changing the output to One Row per Evaluation would allow you to do so. Whenever you change the output, be sure to leave the Include Related Form Data box checked.
The different options for the output settings are described below.
- One Row per Request - This is the default setting. When this option is selected, a report will display one row of data for each request.
-
One Row per Form - When this option is selected, a report will display one row of data for each form.
- If a request includes three different forms such as the LOI, application, and decision form, there will be three rows of data for that request, one for each form.
- This option must be selected to use the submission status pre-filter. More details are available in Submission Status Pre-Filter for Data Sets.
-
One Row per Evaluation - When this option is selected, a report will display one row of data for each evaluation.
- If a request was assigned to four separate evaluators, there will be four rows of data for that request, one for each evaluation.
-
One Row per Installment - When this option is selected, a report will display one row of data for each installment.
- If a request has two installments, there will be two rows of data for that request, one for each installment.
-
One Row per Payment - When this option is selected, a report will display one row of data for each payment.
- If a request has three payments recorded, there will be three rows of data for that request, one for each payment.
- To use Payment Date filtering in reporting, change the data set to One Row Per Payment.
- One Row per CharityCheck - When this option is selected, a report will display one row of data for each charity check.