Creating a table in a report

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Help

Editors

Controls (window/page/report)

Controls

Array control

Creating a table in a report

Overview

Creating a Table report

Creating a Crosstab report

Creating a TreeView Table report

Inserting a table into a report

See also

The tables in a report

Creating a table in a report

Overview

The tables can be created in a report:

when creating a report:
- Table report.
- Crosstab report.
- Versions 19 and later
  TreeView Table report.
  New in version 19
  TreeView Table report.
  TreeView Table report.
by inserting a table into an existing report.

when creating a Table + Chart report.

Creating a Table report

To create a Table report, select "File .. New .. Report". The wizard for report creation starts. Select the type of report to create: Table. To create a Table report:

Click among the quick access buttons.
Click "Report" in the wheel that is displayed. The window for creating a new element is displayed: click "Report" then "Report".
The wizard for report creation starts.
In the wizard, select the type of report to create: Table.

The main steps

The main steps for creating a Table report are as follows:

selecting the source of the report. See Data source of report for more details.
selecting the sort items (if necessary). See Sort in a report for more details.
selecting the break items. See Break in a report for more details.
selecting the data to display in the report. This data will be displayed in the data row of the table.
choosing the calculations performed in the report. These calculations will be displayed in the total row of the table.
selecting the page format (A4, A3, landscape, ...).
selecting the skin template. See Skin template of a report for more details.

Creating a Crosstab report

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

To create a Crosstab report, select "File .. New .. Report". The wizard for report creation starts. Select the type of report to create: Crosstab.To create a Crosstab report:

Click among the quick access buttons.
Click "Report" in the wheel that is displayed. The window for creating a new element is displayed: click "Report" then "Report".
The wizard for report creation starts.
In the wizard, select the type of report to create: Crosstab.

The main steps

The main steps for creating a Crosstab report are:

The item corresponding to the captions of columns.
Note: If this item is a "Date" item, the wizard proposes to:
- keep only the day or the year for these dates.
- define the period to take into account (start date and end date).
The item corresponding to the captions of the rows.
Note: If this item is a "Date" item, the wizard proposes to:
- keep only the day or the year 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:
- the number of records corresponding to the intersection between 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. In the European championships 2002, the Italian referee gave a score of 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 applications or in your sites.

See Crosstab report for more details.

Creating a TreeView Table report

The report editor allows you to create "TreeView Table" reports. The report allows you to see a hierarchy in the table.

To create a TreeView Table report:

Click among the quick access buttons.
Click "Report" in the wheel that is displayed. In the window that is displayed, click "Report" then "Report".
The wizard for report creation starts.
In the wizard, select the type of report to create: TreeView table.

The main steps

The main steps for creating a Treeview Table report are as follows:

selecting the source of the report. See Data source of report for more details.
selecting the data to display in the report. This data will be displayed in the data row of the table.
selecting the page format (A4, A3, landscape, ...).
selecting the skin template. See Skin template of a report for more details.

See TreeView Table report for more details.

Inserting a table into a report

A table can be inserted into any report that does not already contain a table (except for the Label reports).

Note: Only a simple table can be inserted. A crosstab cannot be inserted into an existing report.

This report must contain at least two blocks: the Body block and a header block (Page header, Break header or Start of document).This report must contain at least two blocks: the Body block and a header block (Page header, Break header or Start of document).

To insert a table into a report, select "Insert .. New table": the wizard for table creation starts.To insert a table into a report:

On the "Creation" pane, in the "Structure" group, click "Table".
The wizard for table creation starts.

Depending on the data source of the current report, you can:

select the items that will be displayed in the table (report based on data file, query, ...). The selected controls are automatically included in the table.
specify the headers of the table (report without data source, report based on text file).

In all cases, the header row of the table is created in the header block and the data row is inserted into the Body block of the report.