...desription...
To create a Pivot Report with the Report Designer, navigate to the Reports → Create a Report, and follow the steps below:
Click Next or the tabs of the Report Designer to navigate. This navigation is only available after filling in the mandatory fields.
- On the Data tab, fill in the mandatory fields:
- Report name - enter the desired name;
- Table - select the table you need.
- On the Type tab, select Pivot report option and click Next.
- On the Configure tab, customize the Pivot report.
- Click Update to generate your report.
- Click Next to customize the report style.
- On the Style tab, configure the Pivot report style.
- Click Update to apply the style changes.
- Click Save.
Configure a Report
Fill in these fields to configure your report in a way you want.
Field | Description |
---|---|
Row | Set a desired table column as a row for pivot report. |
Column | Set a desired table column as a column for pivot report. |
Aggregation type | Select a type of the numeric data aggregation from one of these options:
|
Aggregation column | Select a table column with numeric values for data aggregation. |
Groups limit | Set the limit of the data groups shown in your report with a particular number in this field. |
Show rest as other | Set this checkbox on to show the data groups not included in Groups limit as one. |
Customize a Style
General Style | |
---|---|
Report width | |
Drilldown list layout |