> For the complete documentation index, see [llms.txt](https://kuadron.gitbook.io/reportql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kuadron.gitbook.io/reportql/report/create-dashboard/report-parameters.md).

# Report Parameters

Reportql simplifies data visualization for users by allowing the use of various parameters. Below is a guide explaining the usage of different parameter types and their integration with dashboard elements.

These parameters are configured to affect dashboard elements. For example, selecting a date range can limit data visualization to a specific time period.

With this guide, you can optimize your data visualization processes and create user-friendly dashboards using Reportql.

### General Info

*After defining the parameter, you can use it in your queries using the programmatic name. (@startDate and @endDate are programmatic names of defined parameters)*

```
select * from orders where startdate between @startDate and @endDate 
```

*If you have an optional parameter, you can use it as follows:*

```
select * from customers where (@customerName is null or name = @customerName)
```

### Parameter Types

#### **Text**

Allows users to input free text. Ideal for fields like username, description, or comments.

#### **Integer**

Allows users to input integer values. Used for numerical data like age, quantity, or ranking values.

#### **Date**

Allows users to select dates. Facilitates data entry in date format.

#### **Checkbox**

Allows users to confirm an option. Used for binary choices like true/false or yes/no.

#### **Dropdown**

Allows users to select from predefined options. The list is fixed and cannot be changed.

<figure><img src="/files/FIY57oXlL0uJmr02kciZ" alt=""><figcaption></figcaption></figure>

#### **Query Dropdown**

Allows users to select from options dynamically pulled from a data source.

* **Name field**: the name of the column to be displayed in the dropdown&#x20;
* **Value field**: ID column
* **Example Usage**: Product list, customer list.

```
SELECT ID, product_name FROM products
```

<figure><img src="/files/ZgSKPSiliLVWraRgkzoh" alt=""><figcaption></figcaption></figure>

#### **Autocomplete**

Provides auto-completion suggestions from predefined options as users enter text.

* **Name field**: the name of the column to be displayed in the dropdown&#x20;
* **Value field**: ID column
* **Filter field**: Field to filter in search
* **Example Usage**: Product list, customer list.

```
SELECT ID, product_name FROM products
```

<figure><img src="/files/fT2XoM5BipIioKUFrtkR" alt=""><figcaption></figcaption></figure>