- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
-
SpreadJS Designer Component
- Getting Started
- Quick Start
- Theme
- Designer Interface
- JavaScript Frameworks
- Customizations
-
Work in Designer Component
- AutoSum Functions
- Set Range Template Cell
- Name Box
- Select Cells Using Go To
- Find and Replace
- Edit Font Size
- Edit Font Family
- Manage Conditional Formatting Rules
- Shape Selection Pane
- Automatic Outline
- Format Painter
- Table Slicer
- TableSheet
- GanttSheet Designer
- ReportSheet Designer
- Data Chart Designer
- Text to Columns
- Remove Duplicates
- Pivot Table
- Dockable Side Panel
- Command Palette
- Transform Cells with LAMBDA Formula
- Toolbar Ribbon
- API Documentation
- SpreadJS Collaboration Server
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
Wizard
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:
Click INSERT > ReportSheet to open the REPORT SHEET DESIGN tab.
Click on the Wizard ribbon button.
wizard1
In the Create Report Wizard dialog, select the desired report type from the available options.
wizard2
Customize the report template settings as needed.
You can select a table and then customize the columns and theme colors for the report.
wizard3
Change the aggregate function as needed by clicking theaggregate-iconicon 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
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
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