> For the complete documentation index, see [llms.txt](https://docs.silverband.com.au/home/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.silverband.com.au/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/bulk-list-creation-in-report-builder.md).

# Bulk List Creation in Report Builder

This page contains the workflow on how to create a Bulk List of records in Report Builder

## Overview

Bulk processes in Paradigm which require a list of the same type of record, e.g. students, can be very time-consuming if done manually. Report Builder speeds up the process by letting you select a predefined list of records or create a new list and add filters or conditions to restrict the matching records in the bulk list. This article will guide you on how to create a bulk list of records using the Report Builder menu.

Bulk Lists can be used or applied to any other bulk activities you do in Paradigm. Examples are [communication events](/home/paradigm-knowledge-base/sending-communications/workflows/manage-sending-email-and-sms-communications/send-bulk-communications-with-attachment.md), [bulk enrolment to units](/home/paradigm-knowledge-base/student-enrolments/workflows/manage-unit-enrolments/enrol-via-bulk-course-edit-screen.md), [bulk edit course enrolments](/home/paradigm-knowledge-base/student-enrolments/workflows/manage-course-enrolments/edit-course-enrolments-in-bulk.md), and [bulk generate invoices](/home/paradigm-knowledge-base/invoicing-and-receipting/workflows/accounting-module/workflows/raising-enrolment-invoices-in-bulk.md).

## Workflow <a href="#workflow" id="workflow"></a>

The aim is to choose **all of the primary key fields** for the type of record that you are trying to update, along with other selected fields that help you to identify specific records, and include those fields in a list.&#x20;

Once you have that list, you then pass that list to a different screen that shows either a report parameters screen or a data entry screen, depending on the function that you are trying to perform for the type of records that are contained in your list. The screen will then process all records in the list as if you had processed each record one at a time.

**Please make sure that the REPORT COLUMNS section contains the key fields of the record that you wish to update**, e.g. the following fields must be included in your report columns section if you are creating a bulk list OF:&#x20;

* **Students:** `student_party_id` or `student_number`;
* **Course Enrolments:** `student_party_id`` `**`AND`**`course_enrolment_id`
* **Unit Enrolments:** `student_party_id`**`AND`**`course_enrolment_id`` `**`AND`** and `scheduled_unit_id` to [enrol in Scheduled Units](/home/paradigm-knowledge-base/student-enrolments/workflows/manage-unit-enrolments/enrol-via-bulk-course-edit-screen.md) or [edit Unit Enrolment records in bulk](/home/paradigm-knowledge-base/student-enrolments/workflows/manage-unit-enrolments/bulk-edit-unit-enrolment-records.md).

If Report Builder does not yet have a suitable report that produces the intended list of records, start by following the instructions on how to [Build a Report](/home/paradigm-knowledge-base/generating-reports/workflows/build-a-report.md). As a starting point, you can use the pre-defined Base Reports such as 'Student Details' to create a bulk list of students, 'Course Enrolment Details' to build a bulk list of course enrolments, or 'Unit Enrolment Details' to build a bulk list of unit enrolments.

Contact our [Support Team](https://silverband.atlassian.net/servicedesk/customer/user/login?destination=portals) if you have a specific list of students that you want us to build.

1. Choose **Reports** > **Report Builder** from the menu on the side.
2. If you have a Saved Report that suits your needs, select it from the list of **Global Reports** drop box or the **Private Reports** drop box, and click the **LOAD REPORT** button.

<figure><img src="https://1246578764-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FC21t2SaV2eKaLxvtR27D%2Fuploads%2F3V80mAf1OePMKoZynYLV%2Fimage.png?alt=media&amp;token=aa54c06f-b81d-4443-b672-44dd29fcea55" alt=""><figcaption><p>loading the base or saved report with the required fields for the bulk list</p></figcaption></figure>

3. If you do not have a Saved Report to suit your needs, you will need to follow these steps:

   1. Choose a Base Report from the list of Base Reports as mentioned earlier, and click the **LOAD REPORT** button.&#x20;
   2. In the REPORT COLUMNS section, choose all of the necessary primary key fields and the other identifying fields that you need for the type of bulk list that you are trying to generate, *see* [Step 2 - Add and Remove Fields](/home/paradigm-knowledge-base/generating-reports/workflows/build-a-report/step-2-add-and-remove-fields.md)

   The following fields must be included in your report columns section if you are creating a bulk list OF:&#x20;

   * **Students:** `Student Party Id`` `**`OR`**` ``Student Number` - the **Student Details** base report can be used for this
   * **Course Enrolments:** `Student Party Id`` `**`AND`**`Course Enrolment Id` - the **Student Course Enrolment Details** base report can be used for this
   * **Unit Enrolments:** `Student Party Id`**`AND`**`Course Enrolment Id`` `**`AND`** and `Scheduled Unit Id` to [enrol in Scheduled Units](/home/paradigm-knowledge-base/student-enrolments/workflows/manage-unit-enrolments/enrol-via-bulk-course-edit-screen.md) or [edit Unit Enrolment records in bulk](/home/paradigm-knowledge-base/student-enrolments/workflows/manage-unit-enrolments/bulk-edit-unit-enrolment-records.md) - the **Student Unit Enrolment Details** base report can be used for this
4. Check the FILTER CLAUSES section, in the case where you may want to add more conditions or modify the existing conditions to restrict the contents of the list. Refer to [Step 4 - Add Filter Clauses](/home/paradigm-knowledge-base/generating-reports/workflows/build-a-report/step-4-add-filter-clauses.md) for further instructions.
5. Ensure that the BASE REPORT PARAMETERS are correctly set to cover the required unit enrolment start and end dates and enrolment status values to produce a list that contains the required students, *see* [User-Defined Parameters](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/user-defined-parameters.md)
6. Scroll down to the FORMAT REPORT section
7. Click the **Bulk Student Select** radio button, and click **PRODUCE REPORT**.

<figure><img src="https://1246578764-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FC21t2SaV2eKaLxvtR27D%2Fuploads%2F341NWwlzHhibToTVkduT%2Fimage.png?alt=media&amp;token=ce31ec12-8a8f-41d9-ab4c-c775640a9904" alt=""><figcaption><p>producing the bulk list of students, course enrolments, or unit enrolments</p></figcaption></figure>

This may take some time to run, and will depend on the scope of the list being created. Please wait for the screen to refresh and reload with a list of the records returned by the report.

8. Once the bulk list of records appears, click on the **check box** for each record that you want to include in the bulk list. You may choose to select all and then deselect specific students from the list, or you may choose to select only specific records from the list, and click the **ADD SELECTED TO LIST** button.

<figure><img src="https://1246578764-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FC21t2SaV2eKaLxvtR27D%2Fuploads%2FVAKRMFlRXxOxCsoF9bSf%2Fimage.png?alt=media&amp;token=80a579ce-9394-487a-a646-57a7601c4682" alt=""><figcaption><p>adding the selected list to the bulk list</p></figcaption></figure>

It may take a few moments to load the list of records in memory. Please wait for the list to appear on the screen, *as shown in the screenshot below.*

<figure><img src="https://1246578764-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FC21t2SaV2eKaLxvtR27D%2Fuploads%2FFM1hgptWAWEYcBOq6qQ8%2Fimage.png?alt=media&amp;token=68b83cec-4e69-46aa-b612-90416da4f6bb" alt=""><figcaption><p>the added bulk list of records for bulk operations, ready for further bulk operations</p></figcaption></figure>

{% hint style="success" %}
**SUCCESS**:

Your bulk list is now ready to be used for any of the bulk operations that are defined in Paradigm.
{% endhint %}

## Related Workflows

{% content-ref url="/pages/QfyWX3vcAGNzkcFkuXFs" %}
[Send Bulk Communications without Attachment](/home/paradigm-knowledge-base/sending-communications/workflows/manage-sending-email-and-sms-communications/send-bulk-communications-without-attachment.md)
{% endcontent-ref %}

{% content-ref url="/pages/Ni5pjjdDa4pIJCihV3OU" %}
[Send Bulk Communications with Attachment](/home/paradigm-knowledge-base/sending-communications/workflows/manage-sending-email-and-sms-communications/send-bulk-communications-with-attachment.md)
{% endcontent-ref %}

{% content-ref url="/pages/F9DtOG1MHkYWprkugX3D" %}
[Raising Enrolment Invoices in Bulk](/home/paradigm-knowledge-base/invoicing-and-receipting/workflows/accounting-module/workflows/raising-enrolment-invoices-in-bulk.md)
{% endcontent-ref %}