PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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.
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: Array. 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: Array.

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.
  • select the break items. See Break in a report for more details.
  • select the data that will be displayed in the report. This data will be displayed in the data row of the table.
  • choose the calculations to perform in the report. These calculations will be displayed in the total row of the table.
  • selecting the page format (A4, A3, landscape, ...).
  • select the skin template. See Skin template of a report for more details.
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, 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 as follows:
  • 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

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.
  • select the data that will be displayed in the report. This data will be displayed in the data row of the table.
  • selecting the page format (A4, A3, landscape, ...).
  • select 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 array 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.
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment