# Create Reports

The first step in report creation is deciding what data you will report, then create the SQL query to pull the data from the database.

![P4 Warehouse Widget List](https://2764542787-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MdqvtgkbuySRnxUkZY_%2F-Mj9A1g7QRPIEtjIUKAO%2F-Mj9AHsIMUY5eCsqj4TX%2Fimage.png?alt=media\&token=83054e9c-0305-4fad-ac5f-8f1a45a5b39f)

In this screen you can edit an existing report, or you can create a new report.

{% hint style="info" %}
To create reports you will need to know TSQL, the best option is to download the database [backup ](https://docs.p4.software/p4warehouse-english/setup/reports-and-kpi/database-backups)to create your SQL statement.
{% endhint %}

By clicking the name of an existing Widget, you will be able to edit the reports SQL statement.

![P4 Warehouse SQL reports Query](https://2764542787-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MdqvtgkbuySRnxUkZY_%2F-Mj9AsaFdvGdtazpH09H%2F-Mj9BL9Zd_crZY7V7oSu%2Fimage.png?alt=media\&token=93808f99-3de0-4560-a396-a6ec3f47d011)

{% hint style="warning" %}
Reports are an in-depth subject; it is recommended you speak with your P4 Warehouse Partner to get more details.
{% endhint %}

Once you have your SQL Query working you will need to add a grid.