ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Array control
  • Overview
  • Creating a Table report
  • The main steps
  • Creating a Crosstab report
  • Creating a Crosstab report
  • The main steps
  • Creating a TreeView Table report
  • Creating a TreeView Table report
  • The main steps
  • Inserting a table into a report
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Creating a table in a report
Overview
Tables can be created in a report:
  • when creating a report:
    • Table report.
    • Crosstab report.
    • TreeView Table report.
  • by inserting a table into an existing report.
Creating a Table report
To create a Table report:
  • Click in the quick access buttons.
  • The creation window appears: click "Report" then "Report".
  • The report creation wizard 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. For more details, see Report data source.
  • selecting the sort items (if necessary). For more details, see Sort in a report.
  • selecting the break items. For more details, see Break in a report.
  • 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. For more details, see Skin template of a report.
Creating a Crosstab report

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:
  • Click in the quick access buttons.
  • The creation window appears: click "Report" then "Report".
  • The report creation wizard 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.
    Remark: 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.
    Remark: 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.
For more details, see Crosstab report.
Creating a TreeView Table report

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 in the quick access buttons.
  • In the window that is displayed, click "Report" then "Report".
  • The report creation wizard 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. For more details, see Report data source.
  • 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. For more details, see Skin template of a report.
For more details, see TreeView Table report.
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).
Remark: 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).
To insert a table into a report:
  • On the "Creation" tab, in the "Structure" group, click "Table".
  • The table creation wizard 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.
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help