# Wizard

A tutorial showing how to the ReportSheet wizard in the SpreadJS Designer Component with UI to create ReportSheets

## Content

The wizard helps users to create reports with a simple setup in the Spread Designer Component.
To use this feature, follow the below-mentioned steps:

1. Click **INSERT** \> **ReportSheet** to open the **REPORT SHEET DESIGN** tab.
2. Click on the **Wizard** ribbon button.
<br>
    ![image](https://cdn.mescius.io/document-site-files/images/b2223940-43c2-44cf-8eda-f5ab9acd84f0/image.3b3522.png)
<br>
3. In the **Create Report Wizard** dialog, select the desired report type from the available options.
<br>
    ![wizard2](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/wizard2.9ce70b.png?width=900)
<br>
4. Customize the report template settings as needed.
    You can select a table and then customize the columns and theme colors for the report.
    ![wizard3](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/wizard3.f83809.png?width=900)
<br>
5. Change the aggregate function as needed by clicking the![aggregate-icon](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/aggregate-icon.14adf5.png?width=28&verticalAlign=bottom)icon of the field. The available aggregate functions include **Sum**, **Average**, **Max**, **Min**, and **Count**, allowing you to customize the data calculation based on your specific requirements.
    ![wizard4](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/wizard4.19ab5d.png?width=900)
<br>
6. Click **OK** to create the report.

Note that if the selected table has a relationship with any other tables, the **Create Report Wizard** dialog will also display these tables to easily integrate relevant data into the report.
To configure the relationship, navigate to the **Data Source**, then select the table and column item. In the **Relationship** section of the selected column item, configure the relationship by providing the source and target items.
![wizard5](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/wizard5.9da633.png?width=900)
You can select the table from the **Table** dropdown list in the **Create Report Wizard** dialog. Note that an arrow will appear next to the column nodes where you have specified the relation. Click the arrow to expand the relationship column nodes and see the child nodes. When you select a column, the corresponding column will be added to the report.
![wizard6](https://cdn.mescius.io/document-site-files/images/7719ad0a-f083-46d7-aff6-f63e2e187c15/wizard6.f84613.png?width=900)