Crosstab report

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Overview
Creating a Crosstab report based on a query
Remark

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Crosstab report

Overview

The report editor allows you to create "Crosstab" reports. In this case, the report contains a double-entry table only.

Versions 18 and later

This type of report is now available for the iPhone/iPad applications.

New in version 18

This type of report is now available for the iPhone/iPad applications.

Versions 21 and later

This type of report is now available in Universal Windows 10 App mode.

New in version 21

This type of report is now available in Universal Windows 10 App mode.

Example:

Data source of the Crosstab report: The Crosstab report can be based:

on one or more data files. In this case, an embedded query is used. This query is created via the wizard for creating a "Crosstab" report. See Creating a Crosstab report based on a query for more details.

Remark: If the "Crosstab" report is based on a query, you have the ability to modify the embedded query in the query editor. To edit the embedded query in the query editor:

Select "Description" from the popup menu of report. The description window of the report is displayed.
Display the "Data" tab.
Click the "Edit" button.

Creating a Crosstab report based on a query

To create a "Crosstab" report, click

among the quick access buttons:

The window for creating a new element is displayed: click "Report" then "Report".
The report creation wizard starts. Select "Crosstab".

In this wizard, you must specify:

the item corresponding to the captions of the columns.
Remark: If this item is a "Date" item, the wizard proposes to:
- keep the day, the month or the year only for these dates.
- define the period to take into account (start date and end date).
the item corresponding to the captions of the rows.
Remark: If this item is a "Date" item, the wizard proposes to:
- keep the day, the month or the year only for these dates.
- define the period to take into account (start date and end date).
the information that will be displayed in the table cells. This information can correspond to:
- either the number of records corresponding to the intersection of rows and columns.
  For example: the number of products ordered per product and per year. The customer named "Smith" has placed 2 orders in 2000 and 3 orders in 2001.
- the sum, the average, the maximum or the minimum of an item.
  For example: the number of products ordered per product and per year. In 2000, 279 sofas were ordered.
- an item.
  For example: the score given by each judge to a skater in competition. At the 2000 European Championships, the Italian judge awarded 5.2 to skater "A".
the calculation of totals for the table rows and columns (if necessary).
the format of the page on which the report will be printed. The report is printed in A4 format by default.
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.

Remark

When printing a Crosstab report, if the report format does not allow to display all the table columns, the table is automatically resized according to the print format of the report (the font and columns are resized accordingly).

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, ...)