Principle

• If a report was created on this Pivot Table control by the developer, this report is printed.
• If no report is linked to this Pivot Table control, the user can print the content of the Pivot Table control.

• The "Print" option found in the popup menu of Pivot Table controls requires the print libraries of the WINDEV framework.
• By programming:
  • the AAFExecute function used with the constant aafPrintPvt starts the printing of the specified Pivot Table control.
  • the AAFDisable function used with the constant aafPrintPvt removes the "Print" option for the specified Pivot Table control.
  • AAFChangeCaption associated with the aafPrintPvt constant is used to modify the caption of the "Print" option for the specified Pivot Table control.

Printing the report created by the developer

Direct print of the content of the pivot table

A window allows the user to print in portrait or landscape mode.

The content of the pivot table is directly displayed in the report viewer.

• The title of the print corresponds to the title of the Pivot Table control. If no title has been specified for the Pivot Table control, the title of the window is used.
• The column titles are printed on each page.
• The print keeps the background colors used for the different Pivot Table control cells.
• Today's date is printed in the top right corner.
• The number of the current page and the total number of pages are printed in the bottom right corner.

Customizing the setting window for printing the Pivot Table control

• the appearance of this window (modification of skin template for example),
• the languages supported by this window. This feature is very useful when translating this window into the different languages proposed by the application.

1. On the "Project" pane, in the "Project" group, expand "Import" and select "WINDEV elements and their dependencies".
2. Select the subdirectory that contains the elements to import. The window for print configuration is found in the "Programs\Data\Preset windows\AAF" sub-directory of the setup directory of WINDEV.
3. WINDEV lists the elements of the directory. This directory contains the different elements corresponding to the customizable AAFs. The window to import is named "WinDevAaf_ConfigPVTPrint.wdw".
4. Validate. The window is included in the project and it can be modified. This custom window will be automatically taken into account when running the application.

• The window must not be renamed.
• If this window is included in your application, you may not benefit from the improvements made to this window during the different updates. Don't forget to check whether this window has evolved.
• Caution: To modify this window, the corresponding file must not be read-only. Modify the characteristics of the file in Windows if necessary.