> 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/user-defined-parameters.md). # 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.

fields to add in the REPORT COLUMNS section

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](/home/paradigm-knowledge-base/generating-reports/workflows/build-a-report/step-4-add-filter-clauses.md) instructions for more details.

filter clause added in the FILTER CLAUSES section

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.
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**](/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/bulk-list-creation-in-report-builder.md) for more details. Refer to [Step 6 - Save Report](/home/paradigm-knowledge-base/generating-reports/workflows/build-a-report/step-5-save-report.md) instructions if you want to save your report. --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## 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, and the optional `goal` query parameter: ``` GET https://docs.silverband.com.au/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/user-defined-parameters.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. 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.