|
|
|
|
|
|
|
|
|
|
- Overview
- Creating a Crosstab report based on a Pivot Table control
- Creating the report
- Characteristics of a Pivot Table report and a Pivot Table control
- Characteristics of the Pivot Table (Report editor)
Pivot Table control in a report
  Available only with these kinds of connection
The report editor allows you to create "Crosstab" reports. In this case, there are two possibilities for a WINDEV application: - the data source corresponds to several data files: a query-based crosstab report will be created.
- the data source corresponds to a Pivot Table control present in a window (as shown on this page): the report created contains a Pivot Table control..
When creating a report based on a Pivot Table control from a window, the report contains only a Pivot Table control. This type of control is created only when this type of report is created: it cannot be created independently of this report.. In the editor, this control includes two blocks: - The "Header" block that displays the titles of the columns in the Pivot Table.
- The "Pivot Table" block that displays the titles of the rows and the associated data.
For more details on the different sources of a "Crosstab" report, see Crosstab report. Creating a Crosstab report based on a Pivot Table control Creating the report To create a "Pivot Table" report: - Click
 in the quick access buttons. - The window for creating a new element is displayed: click "Report" then "Report".
- The report creation wizard starts.
- In this wizard, specify:
- the type of report to be created: "Crosstab".
- the Pivot Table control used as data source.
- the skin template of the report (if necessary).
- the name and title of the report. This name (".WDE". file corresponding to the report) will be used to identify the report in your programs.
Characteristics of a Pivot Table report and a Pivot Table control Characteristics of the Pivot Table (Report editor) You can change the following characteristics of a Pivot Table report: - The data source of the report can be modified in the "Data" tab of the description window of report ("Report description" in the context menu of the report).
- The "General" tab of the Pivot Table control description window is used to specify:
- the cell width calculation mode: the following options are available:
- Use the width defined in editing: cells will be displayed with the same width as that defined in the report editor..
Note: You can use the sizing handles to resize the data area in the Pivot Table control in the report.. - Fill the page as wide as possible: if there's space left on the page, the cells will be enlarged to fill the empty space.
- Avoid truncated cells: if there's space left on the page, cells may be enlarged to display all the data they contain.
- dimensional sequence: the following options are available:
- Like the field: the level of detail displayed in the report will be the same as that of the Pivot Table control used as the data source.
- All unrolled: all data in the dynamic array will be displayed.
- All rolled up: only the first level of detail in the Crosstab will be displayed.
- The "Style" tab in the TCD control description window is used to define the style of the control: the "Define style independently of printed TCD control" option is used to define a specific style for the control in the report.. If this option is checked, you have the ability to specify the style for the row headers and for the data.
Related Examples:
|
Training (WINDEV): WD Reports
[ + ] This example presents the different methods for creating a report: - prints based on different data sources (queries, variables, ...) - prints based on controls (Table, Spreadsheet, PVT, ...) - printing composite reports - specific prints (portrait/landscape, report with watermark, report with bar code, ...)
|
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|