> 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/single-grid.md).

# Single Grid

Dashboards provide a consolidated view of your data and insights.&#x20;

**To create a Dashboard**:

Go to Dashboard and click ‘Add New’.

<figure><img src="https://1732466415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6RrvnlN4awUTsHV07p0p%2Fuploads%2FO3i5aK4vXGRFb2ibRr36%2Fimage.png?alt=media&amp;token=ee5a7067-dbcc-42bd-b5ce-dab9d108eff0" alt=""><figcaption></figcaption></figure>

**Select Dashboard Type**: Choose from Single Grid Report&#x20;

<figure><img src="https://1732466415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6RrvnlN4awUTsHV07p0p%2Fuploads%2FlD0YIISoef5s9MTbeg54%2Fimage.png?alt=media&amp;token=e3d2f07a-a7e6-4ac0-bc92-5461f3e9187b" alt=""><figcaption></figcaption></figure>

Enter Report Name\*, Label, Description, “Featured report?” and/or “Is it available to all users?” select and proceed

<figure><img src="https://1732466415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6RrvnlN4awUTsHV07p0p%2Fuploads%2F5c9nxzPMqO5CR1PoRAFr%2Fimage.png?alt=media&amp;token=402cc52b-530d-4294-bd36-dd2b9ac93c80" alt=""><figcaption></figcaption></figure>

Select the Data Source connection or click Create a new Connection([For this see](https://docs.google.com/document/d/1ap2fLlqdl3BtowQKC1O_SsVpxJVnisXjPz7othwNjQs/edit))

<figure><img src="https://1732466415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6RrvnlN4awUTsHV07p0p%2Fuploads%2FzaIWixBJxP574O4huiHX%2Fimage.png?alt=media&amp;token=1de6c994-06dc-47cc-8735-a992dfe6a2b0" alt=""><figcaption></figcaption></figure>

Select the component you want from Server Table, Client Table or Pivot options.

<figure><img src="https://1732466415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6RrvnlN4awUTsHV07p0p%2Fuploads%2FKahrtUi4ryHUb5ggNkX2%2Fimage.png?alt=media&amp;token=09ca1f79-d331-4cde-a948-b61e21cfc095" alt=""><figcaption></figcaption></figure>

Choose the options you want from Paging, Sorting, Filtering, Column Selecting, Report Designing and Excel Export.

<figure><img src="https://1732466415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6RrvnlN4awUTsHV07p0p%2Fuploads%2F8NnYzzMElKjwwKZ4BZ2y%2Fimage.png?alt=media&amp;token=290e44ca-8205-4b77-ad72-f287232c5a20" alt=""><figcaption></figcaption></figure>

Enter the required SQL query for your report and click Add.

<figure><img src="https://1732466415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6RrvnlN4awUTsHV07p0p%2Fuploads%2FfTXoCMEIX11k8b6mkPBi%2Fimage.png?alt=media&amp;token=70666da3-65be-4201-b5cc-bede4b2a69ef" alt=""><figcaption></figcaption></figure>

View your resulting report and click Options to edit it.

<figure><img src="https://1732466415-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6RrvnlN4awUTsHV07p0p%2Fuploads%2FjdvQgXtLRoHZymrRSPP4%2Fimage.png?alt=media&amp;token=e4baf1f9-e511-4531-ab33-1c4937792546" alt=""><figcaption></figcaption></figure>
