> For the complete documentation index, see [llms.txt](https://www.sqlkiss.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.sqlkiss.com/therdl-framework/guides/how-to-install-setup.md).

# How to install/setup

{% hint style="info" %}
Please remember to check system requirements in the Architecture section before setup
{% endhint %}

{% content-ref url="/pages/B1HHPnsELxYoOb1Vm5re" %}
[Architecture](/therdl-framework/guides/design-overview/architecture.md)
{% endcontent-ref %}

### Short instruction

Clone/Download [TheRDL GIT repository](https://github.com/SQLKiss/therdl).\
Deploy SQL schema files onto your SQL Server. Optionally add your settings in the DB tables.\
Find RDL file, deploy it onto your Reporting Server, update data source to point into Server/DB where SQL schema was deployed.\
Run the report(s).

### Detailed instruction

Go to [TheRDL repository](https://github.com/SQLKiss/therdl)\
Find Release section on the right hand side:\
![](https://2705747567-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQSQb5eGHUcASS5ekA0m9%2Fuploads%2FKuwLo31LfClNDoPNMsBx%2Fimage.png?alt=media\&token=406013aa-82ac-4f10-8516-a43fc9dc486c)

Go inside the latest release, scroll down to the assets and download the sql installation files, TheRDL file (and optionally examples):\
![](https://2705747567-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQSQb5eGHUcASS5ekA0m9%2Fuploads%2FI3LaIn1JMV5TLnEbnLA2%2Fimage.png?alt=media\&token=b7cdc32c-91e5-4157-ad19-98901e99db58)

Run the installation\_file.sql against your selected database. Please note it is safe to run installation file multiple times on the same DB\
![](https://2705747567-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQSQb5eGHUcASS5ekA0m9%2Fuploads%2FrU4CCnHkL5UG0x6Aqso8%2Fimage.png?alt=media\&token=dd566110-bc44-45fc-95b3-5ba9d85572a0)

Optionally run in similar way ExamplesInstall.sql

Deploy SQLKiss - TheRDL.rdl onto your SSRS Server\
![](https://2705747567-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQSQb5eGHUcASS5ekA0m9%2Fuploads%2FAeISdnmtiN1SfFkslg0l%2Fimage.png?alt=media\&token=3994908d-6b98-4833-81ac-af1bcd9a022e)

{% hint style="success" %}
At this stage everything is fully installed and ready to be used
{% endhint %}

Optionally add configuration settings into dbo.TherdlSetting table.\
For example:

{% hint style="info" %}
The below example code has been already applied if you installed ExamplesInstall.sql
{% endhint %}

```
INSERT INTO dbo.TherdlSetting(Code, Description, OrderID, DBName, SchemaName, ObjectName, ShowOnlyColumnsArrayListJSON)
VALUES('CustomerInfo', 'Expose customer information', 10, DB_NAME(), 'dbo', 'Customer', '["ID", "Active", "Name"]')
;
```

Run SQLKiss - TheRDL:

![](https://2705747567-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQSQb5eGHUcASS5ekA0m9%2Fuploads%2F9VZx86w5yG2a7ZEKZ2M7%2Fimage.png?alt=media\&token=f07770f2-f104-4c67-8698-0b6d9138c812)