# FlexPivotPage

This topic covers information regarding FlexPivotPage control.

## Content

**FlexPivotPage** provides a complete interface for building FlexPivot applications. It combines **C1FlexPivotPanel** with tabbed views for displaying summarized data as a grid, chart, or raw data, together with a tool strip that provides common analysis and reporting commands.
![C1WinForms Pivot Architecture](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/images/pivot_architecture.png)
The FlexPivotPage object model exposes the integrated controls, enabling interface customization and extension.
![C1WinForms FlexPivotPage Controls](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/images/architecture_of_flexpivotpage.png)

## Grid Menu

The **Grid** menu provides options for configuring the appearance and behavior of the pivot grid.
![C1WinForms Grid Menu Options](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.72ed13.png)

| **Total Rows** | Allows selection of **Grand Totals**, **Subtotals**, or **None**. |
| ---------- | ----------------------------------------------------- |
| **Total Columns** | Allows selection of **Grand Totals**, **Subtotals**, or **None**. |
| **Show Zeros** | Enable to display cells that contain zero values. |
| **Totals Before Data** | Add a total row or column before the data. |

Disable these options to hide totals or cells containing zero values.

## Chart Menu

The **Chart** menu provides options for selecting chart types and configuring chart appearance, including color palettes, titles, stacking, gridlines, and totals.
![C1WinForms Chart Menu Options](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.85f907.png)

| **Chart Type** | Click **Chart Type** to select one of five chart types. |
| ---------- | --------------------------------------------------- |
| **Palette** | Select **Palette** to choose from 16 predefined color palettes for the chart and legend items. |
| **Show Title** | When enabled, a title appears above the chart. |
| **Stacked** | When enabled, the chart displays stacked data. |
| **Show Gridlines** | When enabled, gridlines appear in the chart. |
| **Totals Only** | When enabled, the chart displays totals instead of separate series for each column in the data source. |

### Chart Types

FlexPivot supports multiple chart types for visualizing summarized data.
![C1WInForms Chart Option 1](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.14e9e4.png)
![C1WInForms Chart Option 2](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.dc036a.png)
![C1WInForms Chart Option 3](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.de46d6.png)
![C1WInForms Chart Option 4](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.d232c7.png)

## Report Menu

The **Report** menu provides commands for previewing, printing, and configuring reports generated from FlexPivot data.
![C1WInForms Report Menu](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.501f29.png)
The following table describes the available **Report** commands.

| **Print Preview** | Click Print Preview to preview the report before printing or to export it as a PDF file. |
| ------------- | ---------------------------------------------------------------------------------------- |
| **Print** | Click **Print** to print the **C1FlexPivotGrid**, **FlexPivotChart**, or both. |
| **Options** | Click **Options** to open the **Document Options** dialog box. |

The **Print** command opens the **Print** dialog box and allows printing using available printers, including **Microsoft Print to PDF**.
![C1WInForms Print Menu](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.841154.png)

## Document Options

### Page Tab

The **Page** tab configures page layout settings, including page orientation, paper size, and margins.
![C1WInForms Document Options Page](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.f6b246.png)

### Header/Footer Tab

The **Header/Footer** tab adds headers and footers to printed reports. Toolbar buttons insert dynamic fields such as page numbers, dates, document names, and user information.
![C1WInForms Document Options Header/Footer](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.1aded2.png)
Click a toolbar button to insert a field into the header or footer.

| **Button** | **Field** |
| ------ | ----- |
| Presets | Select one of three predefined options that insert grouped fields into the header or footer. |
| Page Number | &[Page] |
| Current Date | &[Date] |
| Current Time | &[Time] |
| Document Name | $[DocName] |
| View Description | &[ViewTitle] |
| Author Name | &[UserName] |

Enable **Separator** to display a separator line below the header or above the footer. Select **Font** to modify the font, style, size, or effects.

### Report Content Tab

The **Report Content** tab specifies whether the report includes the pivot grid, chart, raw data, or a combination of these elements.
![C1WInForms Document Options Report Content](https://cdn.mescius.io/document-site-files/images/78f24d1c-0e57-452f-87a1-d318e186587a/Untitled-20260629.4e884e.png)