> For the complete documentation index, see [llms.txt](https://docs.p4.software/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.p4.software/p4warehouse-english/analytics-reporting/reports/create-reports.md).

# Create Reports

P4 Warehouse 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 ](/p4warehouse-english/setup/reports-and-kpi/database-backups.md)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.