PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

  • Overview
  • Creating a report
  • The different wizard steps
  • The different types of reports
  • The available data sources
  • Breaks and sorts
  • Performing calculations in a report
  • Skin template
  • Print format of the report
  • Saving 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 report
Overview
The report editor allows you to easily create all types of reports via a wizard.
The reports created with the report editor can be printed:
  • from the WINDEV applications (Windows or Linux).
  • from the WEBDEV sites (Windows or Linux).
  • from the Windows Mobile applications.
  • Versions 18 and later
    from the iOS applications.
    New in version 18
    from the iOS applications.
    from the iOS applications.
  • Versions 21 and later
    from the applications in Universal Windows App mode.
    New in version 21
    from the applications in Universal Windows App mode.
    from the applications in Universal Windows App mode.
Creating a report
To create a report:
  1. Select "File .. New .. Report".Click New 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.
  2. Specify:
    • the type of report to create (form, table, ...). See Types of reports for more details.
    • the data source of the report (data file, query, ...). See Data source of report for more details.
    • the report elements (controls, sort conditions, breaks, ...).
  3. Validate the report creation. The report is generated and saved according to the selected options.
These different steps are performed in the wizard for report creation. A report corresponding to the selected options is automatically created at the end of the wizard. The created report appears in edit in the report editor. The different blocks and controls of your report have been created. They can be modified according to your own requirements. Most of the options chosen when creating the report can be modified thereafter.
Then, the report can be run:
  • from the report editor,
  • from a WINDEV application,
  • from a WINDEV Mobile application (for Windows Mobile or iOS),
  • from a WEBDEV site.
The different wizard steps

The different types of reports

Several types of reports can be created in the report editor. All these types of reports are available in the user version of the report editor and in the standard report editor.
The following types of reports are available:
  • Blank report.
  • Form report.
  • Table report.
  • Crosstab report.
  • Versions 19 and later
    TreeView Table report.
    New in version 19
    TreeView Table report.
    TreeView Table report.
  • Versions 19 and later
    Gantt Chart report (not available in WINDEV Mobile).
    New in version 19
    Gantt Chart report (not available in WINDEV Mobile).
    Gantt Chart report (not available in WINDEV Mobile).
  • Versions 17 and later
    Organizer report (not available in WINDEV Mobile).
    New in version 17
    Organizer report (not available in WINDEV Mobile).
    Organizer report (not available in WINDEV Mobile).
  • Versions 17 and later
    Scheduler report (not available in WINDEV Mobile).
    New in version 17
    Scheduler report (not available in WINDEV Mobile).
    Scheduler report (not available in WINDEV Mobile).
  • Custom Mailing report (not available in WINDEV Mobile).
  • Label report.
  • Report on Form.
  • Versions 15 and later
    Multicolumn report.
    New in version 15
    Multicolumn report.
    Multicolumn report.
  • Versions 16 and later
    Composite report.
    New in version 16
    Composite report.
    Composite report.
  • Chart report (not available in WINDEV Mobile).
  • Table + Chart report (not available in WINDEV Mobile).
See Types of reports for more details.

The available data sources

The data source of the report defines the origin of the data printed in the report. Several data sources are available. These data sources can be selected in the wizard for report creation or in the description window of the report.
The available data sources are as follows:
  • Data file: The data to print comes from a data file described in the project analysis. This data file can have any format (HFSQL Classic, Oracle, ...).

Important

The data files and the file items that can be used in the reports created with Reports & Queries are defined by the developer in the data model editor. See Distributing Reports & Queries for more details.
  • Query: The data to print comes from a query. This query corresponds to:
    • a query created and saved in the query editor.
    • a query created when creating the report.
  • Table, TreeView Table, Organizer or Scheduler control found in a window or in a page: The data to print comes from a specific control found in one of the application windows or in one of the site pages. The records are selected by the control and they are printed by the report.

Important

Reports & Queries cannot be used to create reports on a Table control, a TreeView Table control, an Organizer control or a Scheduler control. However, you have the ability to customize the reports on a Table, TreeView Table, Organizer or Scheduler control created with the standard report editor (color, fonts, size, linked column, ...).
  • Existing variable : The data to print comes from a WLanguage variable found in the project or in the report. This variable can be a simple array, a class member, a structure member or an advanced variable member.

Important

Reports & Queries cannot be used to create or modify reports on variable.
  • SQL query via a connection (ODBC, Native Accesses, ...) (not available in WINDEV Mobile): The data to print comes from a database accessible via a specific ODBC driver, via a Native Access, ... The SQL query is defined when creating the report.
    Note: This type of source is not available in the wizard for report creation.
  • No data source: The report will be linked to no data source.
Other available data sources
  • Text file: The data to print is read in a text file.
  • Memory zone (not available in WINDEV Mobile): The data to print corresponds to the records stored in a memory zone.

Important

Reports & Queries cannot be used to create reports on a memory zone. However, you have the ability to customize the reports on a memory zone created with the standard report editor (color, fonts, size, ...).
  • View on a HFSQL Classic data file: The data to print comes from a HFSQL view.

Important

Reports & Queries cannot be used to create reports on a HFSQL view. However, you have the ability to customize the reports on HFSQL view created in the standard report editor (color, fonts, size, ...).
  • Programmed reading of the data source: To manually program and select the records that will be displayed in the report, choose a report based on a programmed data source. See Report on a programmed data source for more details.

Important

Reports & Queries cannot be used to create reports on a programmed data source.
These data sources are presented in Data sources.
Note: If one of the above-mentioned data sources is selected, the records that will be displayed in the report are automatically selected by the report editor.
To manually program and select the records that will be displayed in the report, choose a report with programmed reading of the data source.

Breaks and sorts

The breaks and the sorts are used to define the sort order of the data printed in the report as well as the options for grouping the data.
  • If the report is based on a data file, the search items of the data file are automatically proposed as sort items.
  • If the report is based on a query, the sorts performed in the query are automatically proposed for the breaks.
  • If the report is based on a variable, only the breaks can be defined: the sorts must be performed by programming.
The sort
To make the result of a query easier to read, the records can be sorted according to one or more items. Sorting the records means classifying them in an ascending order or in descending order.
For example, the customers can be sorted by name, from A to Z.
If your report is based on a query, the sort order is defined when creating the query. However, you can:
  • add or delete a sort item to/from an existing report.
  • modify the sort order performed on an item in an existing report.
To improve the sort, you also have the ability to use:
  • the WLanguage functions (Left, Right, ...).
  • a WLanguage procedure (server procedure in WEBDEV). This procedure will be automatically called to sort the records displayed in the report. This procedure must be a global procedure of the project or a local procedure of the report. See Sort procedure for more details.
The breaks
The break is used to group the records corresponding to the same sort argument.
For example:
  • to list the stock price by day, all you have to do is sort the stocks by date and perform a break on the date.
  • to list the customers and the companies by city, sort the customers by city then by company name, and perform a break on the city.
    Report with breaks
Adding a break automatically generates the Break Header and Break Footer blocks. These blocks are used to:
  • display the content of the break item (in the Break Header block).
  • perform calculations on the records found in the break (in the Break Footer block).
See Report blocks for more details.
The report editor proposes two types of breaks:
  • automatic break (the most common one). The break is performed on an item belonging to the data source of the report.
  • programmed break. The break is entirely defined by programming in the "Break?" process of the Break Header block. See Breaks in a report for more details.
See Breaks in a report for more details.

Performing calculations in a report

Several calculations can be performed on the numeric data found in a report. For example, in a report used to list the orders per customer, you can calculate and display the average value of the customer orders.
Note: The different calculations performed in a report are defined when the report is created. However, new calculations can be added to the created report via the calculated controls.

Skin template

If the project is associated with a skin template (or with a template), this skin template (or this template) can be selected for your reports. Your printed reports and your application will have the same style. This skin template (or template) can be modified once the report is created.
Caution: Depending on the type of printer, the reports containing images may take quite a long time to print.

Print format of the report

The format of a report is used to configure:
  • the report orientation.
  • the paper format.
  • the print margins.
  • the number of columns in the report. By default, a report contains one column. If the report contains more than one column, the report is said to be "multi-column".
For a "Label" report, you also have the ability to configure:
  • the format of the label sheet.
  • the spacing between the labels.
This information can be modified after the report creation. See Describing and handling a report for more details.

Saving a report

To save a report, select "File .. Save".To save a report:
  • on the "Home" pane, in the "General" group, click "Save".
  • click Save among the quick access buttons.
The extension of the created report file is ".WDE".
The report is automatically included in the list of project elements.
If you are using the report editor, the reports will be included in the library:
  • WINDEVWINDEV Mobile when creating the executable.
  • WEBDEV - Server code when deploying the site.
Related Examples:
WD Reports 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, ...)
WM CRM Cross-platform examples (WINDEV Mobile): WM CRM
[ + ] WM CRM is a multi-platform project for Android and iOS.
It explains how to develop a CRM application intended to the Android and iPad tablets.
WM Expense Account Cross-platform examples (WINDEV Mobile): WM Expense Account
[ + ] This example allows you to manage your fees.

Let's see the main features of this application:
- The input of invoices
- Management of foreign currencies
- Inclusion of photo document for the invoices
- Ability to email the expense account
- Ability to track the expense accounts
- ...
WM Managing Contacts Cross-platform examples (WINDEV Mobile): WM Managing Contacts
[ + ] This example presents the management of contacts for Android et iOS.
It is used o:
- list the contacts found on the phone
- call the contacts
- send SMSs to the contacts
- ...
WM Managing Orders Cross-platform examples (WINDEV Mobile): WM Managing Orders
[ + ] The WM Managing Orders example is a simplified management of orders and invoices.
This example is used to:
- create/modify/delete a product,
- create/modify/delete a customer,
- contact a customer by email,
- see the history of the actions performed for a customer
- place an order, print an order form,
- invoice an order, print an invoice.
See also
Minimum required version
  • Version 10
This page is also available for…
Comments
Click [Add] to post a comment