# User-Defined Parameters

## Overview

The User Defined Parameters section of Report Builder can be used for entering user-specified parameters. This section is currently used for adding a DISTINCT statement for the Report Output to return only distinct values. 

## Scenario 1

An example would be using the Report Builder to create a list of Students that you want to include in bulk list operations, e.g. sending bulk communications to Students who are still in an "Applied" status

The workflow below shows an example of generating a list of students to include in a bulk list.

### Workflow 1

1. You can use the "**Student Course Enrolment Details**" as the Base Report.
2. In the REPORT COLUMNS section, you can add here the **Student Number**, **First** and **Last Name**. Do not include fields here that might make a student record appear twice in the result, e.g. Course Id or any fields related to Course Enrolments.

<figure><img src="https://1246578764-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FC21t2SaV2eKaLxvtR27D%2Fuploads%2FsWsgGw2VpYq0OavHkWI9%2Fimage.png?alt=media&#x26;token=310713a1-fc4e-4744-9424-96b80b1cc00b" alt=""><figcaption><p>fields to add in the <strong>REPORT COLUMNS</strong> section</p></figcaption></figure>

3. Add your conditions in the FILTER CLAUSES section. As for this example, the intention is to make a bulk list of Students who are still in the "**Applied**" status, the filter in the screenshot below is added:

Refer to[ Step 4 - Add Filter Clauses](https://docs.silverband.com.au/home/paradigm-knowledge-base/generating-reports/workflows/build-a-report/step-4-add-filter-clauses) instructions for more details.

<figure><img src="https://1246578764-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FC21t2SaV2eKaLxvtR27D%2Fuploads%2FoDW4uv7jfsmuexzP6itZ%2Fimage.png?alt=media&#x26;token=d125d284-0362-42a9-b3f3-d5a9eab45b61" alt=""><figcaption><p>filter clause added in the <strong>FILTER CLAUSES</strong> section</p></figcaption></figure>

4. After adding your conditions, go to the **User Defined Parameters** tab, click the **PLUS** sign to add a parameter and enter "**DISTINCT**" on all three columns.

<figure><img src="https://1246578764-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FC21t2SaV2eKaLxvtR27D%2Fuploads%2F9VoxwzahUl61wsgYWcay%2Fimage.png?alt=media&#x26;token=a0e968bf-c2d3-47df-8077-e37be22a70de" alt=""><figcaption></figcaption></figure>

5. You can now proceed to the FORMAT REPORT section to produce your report. Select the **Bulk Student Select** option if you are about to use the list for any bulk operation available in Paradigm, *see* [**Bulk Student Select**](https://docs.silverband.com.au/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/bulk-list-creation-in-report-builder) for more details. Refer to [Step 6 - Save Report](https://docs.silverband.com.au/home/paradigm-knowledge-base/generating-reports/workflows/build-a-report/step-5-save-report) instructions if you want to save your report.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.silverband.com.au/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/user-defined-parameters.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.