• in a window or page of application. This window or page must be displayed when printing the report.
• in an internal window or 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 Looper control. However, you have the ability to customize the reports on Looper control created in the standard report editor (color, fonts, size, ...).

• all rows displayed in the Looper control.
• the rows selected by the user (for multi-selection Looper controls where the rows are selected with the Ctrl key). This option is not available in WEBDEV.

• Each row found in the Looper control corresponds to a record.
• Each attribute of Looper control corresponds to a Static control (even the attributes that do not correspond to a value).

• from the window editor. The created report corresponds to a table report.
• from the report editor. The report creation wizards starts. allowing you to choose the type of report to create (table, form, etc.).

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

• create (if necessary) a button in the window or in the page of Looper control. This button is used to print the report on Looper control (iPrintReport).
  Case of internal windows: If the Looper control is found in an internal window, the button should be created in the internal window (and not in the host window).
• run the test of the window containing the Looper control then run the report test (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 Looper control from the report editor

1. Click in 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, ...). For more details, see The different types of reports.
3. Select (if necessary) the report template to use. A report template is used to comply with a specific page layout. For more details on report templates, see Report templates.
4. Select the data source of the report ("From a Table or Looper control").
5. Select the Looper control on which the report will be based. Only the Table and Looper controls in the windows or pages of the current project will appear.
6. To print:
   • all rows displayed in the Looper control: select "All control rows".
   • the rows selected by the user: select "The rows selected in the control".
     Remark: This option can be modified programmatically with the SelectionOnly property.
7. For each attribute of the Looper 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 where the control associated with the attribute of Looper control will be printed. The positions of different controls can be modified in the report editor. For more details on the different blocks and their position in a report, see Report blocks.
8. Modify (if necessary) the display order of controls in the report with the arrow buttons found on the right of table.
9. If the Looper 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.
10. 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

11. 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, simply specify the desired number of columns in the "Format" tab of the report description window.
12. Select the skin template of the report if necessary.
13. Type the name and title of the report (name of ".WDE" file corresponding to the report). This name will be used to identify the report in your programs.
    You can also specify whether the report can be modified by the end user in "Reports & Queries".
14. Validate the report creation.
15. 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.
16. Specify (if necessary) the mode for reducing the report size:
    • Print the report on several pages. In this case, the end user will have to group the pages. For more details, see Multi-page print.
    • Use the landscape mode.
    • Reduce the report size. Caution: according to the reduction percentage, the printed report may become unreadable.
17. The report currently created is displayed in the report editor.

Printing a report on Looper control

1. Create a button in the window (or page) containing the Looper control.
2. Configure the report print destination:
   • In WINDEV, with iDestination (report viewer, print in an HTML file, etc.).
   • In WEBDEV, with iDestination (print in an HTML file, ...).
   For more details, see Print modes of a report.
3. Specify the name of the report to print with iPrintReport.

• If additional parameters must be passed to the report, these parameters must be specified in iPrintReport, after the name of the report to print. For more details, see Report with parameters.
• If the window that contains the source Looper control is opened multiple times (non-modal opening by OpenChild), the full name of the control to print must be passed as parameter to the report. For example:
  
  // The FullName property will contain the name of the window
  // that must be opened with an alias
  // to distinguish between each window
  iPrintReport(RPT_LOOP_Customer, LOOP_Customer.FullName)
  
  
  
  // Opening code of the report:
  PROCEDURE RPT_LOOP_Customer(sNameSourceLOOP)
  MyReport.SourceName = NameSourceLOOP
  
• The SelectionOnly property is used to get and change the records that will be printed in the report: print all records or the selected records only.

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