• in a window or page of application. This window or page must be displayed when printing the report.
• in a window or in an internal page. The window (or the page) that displays the internal window (or the internal page) must be displayed.

	Important	Reports & Queries cannot be used to create reports on Table control. However, you have the ability to customize the reports on Table control created in the standard report editor (color, fonts, size, ...).

• all rows displayed in the Table control (ability to filter the data found in the Table control with the magnifier).
• the rows selected by the user (for the multiselection Table controls where the rows are selected with the Ctrl key). This option is not available in WEBDEV.

• Each row found in the Table control corresponds to a record.
• Each column of Table control corresponds to a Static control (even the invisible columns).
  

Caution: The data printed in the report is sorted according to the sort column defined for the Table control.

A report on a Table control can be created:

• from the window editor. The created report corresponds to a table report.
• from the report editor. The wizard for report creation starts and it allows you to choose the type of report to create (table, form, ...).

• modify the data source of report ("Data" tab of report description).
• add or delete Static controls linked to the Table control associated with the report.

• create (if necessary) a button in the window or in the page of Table control. This button is used to print the report on the Table control (iPrintReport).
  Case of internal windows: If the Table control is found in an internal window, the button should be created in the internal window (and not in the host window).
• test directly the window or page containing the Table control, then test the report (via the button).
  Case of internal windows: the test must be run from the window that is hosting the internal window.

Creating a report on Table control from the report editor

1. Click among the quick access buttons.
   • The element creation window appears: click "Report" then "Report".
   • The report creation wizard starts.
2. Choose the layout of your report (table, form, label, ...). See The different types of reports for more details.
3. Select (if necessary) the report template to use. A report template is used to comply with a specific page layout. See The report templates for more details.
4. Select the data source of report ("From a Table or Looper control").
5. Select the Table control on which the report will be based. Only the Table and Looper controls found in the windows or in the pages of current project are proposed
6. For each column of Table control displayed in the report:
   • specify whether the column must be printed or not via the checkmark.
   • type the corresponding caption. This caption will be displayed:
     • before the control. For example:
       
       
     • in the column header (for the Table reports). For example:
       
       
       
       This caption can be modified in the report editor.
   • select the block in which the control associated with the column of Table control will be printed. The positions of different controls can be modified in the report editor. See Report blocks for more details.
7. Modify (if necessary) the display order of controls in the report with the arrow buttons found on the right of table.
8. If the Table control associated with the report contains at least one numeric item, calculations can be performed on these items. Specify the calculation performed for each item (sum, average, ...). Two types of calculations are available:
   • general calculation: a Calculated control will be created in the End of document block.
   • calculation on break: a Calculated control will be created in the Break footer block. In the calculations on break, the calculation result is re-initialized after each break. To perform a calculation on break, a break must be found in the report currently created.
9. Depending on the type of report currently created, indicate the specific options.
   

   Type of report	Specific options
   Report on form	Form image, printing the form image, ... Options presented in Report on form
   Label report	Format of labels, number of identical copies, ... Options presented in Label report

10. Specify the format of sheet on which the report will be printed. The report is printed in A4 format by default.
    Remark: By default, the report controls are displayed in a single column. To create a multi-column report, the requested number of columns must be specified in the "Format" tab of the description window of report.
11. Select the skin template of report if necessary.
12. Type the name and title of report (name of ".WDE" file corresponding to the report). This name will be used to identify the report in your programs.
    
13. Validate the report creation.
14. The report editor automatically proposes to change the report format if the following conditions are fulfilled:
    • the report currently created includes a table.
    • the report format does not allow to display all table columns.
15. Specify (if necessary) the mode for reducing the report size:
    • Versions 19 and later
      Print the report on several pages. In this case, the end user will have to group the pages. See Multi-page print for more details.
      New in version 19
      Print the report on several pages. In this case, the end user will have to group the pages. See Multi-page print for more details.
      Print the report on several pages. In this case, the end user will have to group the pages. See Multi-page print for more details.
    • Use the landscape mode.
    • Reduce the report size. Caution: according to the reduction percentage, the printed report may become unreadable.
16. The report currently created is displayed in the report editor.

Printing a report on Table control

A report on Table control must be printed from the window displaying the Table control to print. If the button was not created automatically, you must:

1. Create a button in the window (or page) containing the Table control.
2. Configure the report print destination:
   • 
     See Print modes of report for more details.
3. Specify the name of report to print with iPrintReport.

Remarks:

• If additional parameters must be passed to the report, these parameters must be specified in iPrintReport, after the name of the report to print. See Report with parameters for more details.

	Important	In Reports & Queries, a report can be printed: by starting a printout ( ). by testing the report ( ). Therefore, no programming is required to print the report.