To insert a menu into the "WIN_Menu" window:
1. Display the "WIN_Menu" window in the editor (double-click its name in the "Explorer" pane for example).
2. On the "Window" pane, in the "Bars and menus" group, expand "Main menu" and select "Add main menu".
3. A menu is inserted into the window, below the title bar. This menu contains an option named "Menu".
4. Select the "Menu" option:
  - Open the popup menu (right click).
  - Select "Add after".
5. In the input area, type "Reports".
6. Select the "Reports" option:
  - Open the popup menu (right click).
  - Select "Transform to expand a submenu".
7. In the input area that is displayed, type "List of customers". Press Enter to validate.

To type the WLanguage code of the option "List of customers":
1. Select the "List of customers" option in the editor.
2. Open the popup menu (right click).
3. Select "Code". The code editor appears.
4. Write the following code in the event "Selecting the menu":
  // The report is printed in the report viewer
  iDestination(iViewer)
  
  // Prints the report
  iPrintReport(RPT_List_of_customers)
  Let's study this code:
  - iDestination allows you to configure the print destination. You can print:
    - in a text file,
    - in HTML format,
    - in PCL format,
    - in PDF, RTF, XLS or XML format,
    - on a fax.
    In our case, the report will be printed in the report viewer window.
  - iPrintReport is used to print a report.

Test the window and its menu options by clicking among the quick access buttons.

We are now going to modify this menu by adding an option used to exit from the application.
1. In the editor, select the "Menu" option.
2. In the popup menu (right click), select "Transform to expand a submenu".
3. In the input area that is displayed, type "Exit".
4. We are going to associate this menu option with the "Alt + F4" shortcut:
  - Select the "Exit" option.
  - In the popup menu (right mouse click), select "Option description".
  - In the "General" tab, in the "Keyboard shortcut" area, select "F4" and check "Alt".
  - Validate.
5. Display the WLanguage code of the option and write the following WLanguage code in the event "Selecting the menu":
  // Asks the user whether he wants to exit from the application
  IF YesNo(No, "Exit from the application?") = Yes THEN
  // End of application
  EndProgram()
  END
  Let's take a look at this WLanguage code:
  - YesNo is used to establish a dialog with the user by asking him a question. The user can give an answer to the question via 2 buttons: yes or no.
  - EndProgram (called if the user clicks "Yes") is used to end the application.

Run the window test by clicking among the quick access buttons.

DICAS 3008 - WINDEV TUTORIAL 31 - Adicionar e Modificar Janelas ANCORAS - PARTE D
DICAS 3009 - WINDEV TUTORIAL 32-Adicionar e Modificar Janelas - Exibicao registro - PARTE E

DICAS 3010 - WINDEV TUTORIAL 33-Adicionar e Modificar Janelas - Modifica Imagen - PARTE F

DICAS 3011 - WINDEV TUTORIAL 34 - Adicionar e Modificar Janelas - Validacao - PARTE G

DICAS 3012 - WINDEV TUTORIAL 35 - Adicionar e Modificar Janelas - CRIACAO - PARTE H

DICAS 3013 - WINDEV TUTORIAL 36 - Adicionar e Modificar Janelas - Teste - PARTE I

DICAS 3014 - WINDEV TUTORIAL 37 - Pesquisa Simples - Apresentacao - PARTE A

DICAS 3015 - WINDEV TUTORIAL 38 - Pesquisa Simples - Usando Controle Tab- PARTE B

DICAS_3016_WINDEV_TUTORIAL_39_Pesquisa_Simples_Configurando_Pesquisa_PARTE_C

DICAS 3017 - WINDEV TUTORIAL 40 - Pesquisa Simples - Pesquisa Identica- PARTE D

DICAS 3018 - WINDEV TUTORIAL 41 - Pesquisa Simples - Pesquisa Generica - PARTE E

DICAS 3019 - WINDEV TUTORIAL 42 - Pesquisa Simples - Navegacao pelos Arquivos - PARTE F

DICAS 3020 - WINDEV TUTORIAL 43 - Pesquisa Multicriterio - Apresentacao - Parte A

DICAS 3021 - WINDEV TUTORIAL 44 - Pesquisa Multicriterio - Criacao Consulta - Parte B

DICAS 3022 - WINDEV TUTORIAL 45 - Pesquisa Multicriterio - Uso Parametro - Parte C

DICAS 3023 - WINDEV TUTORIAL 46 - Pesquisa Multicriterio - Criando Interface - Parte D

DICAS 3024 - WINDEV TUTORIAL 47 - Pesquisa Multicriterio - Primeiro Parametro - Parte E

DICAS 3025 - WINDEV TUTORIAL 48 - Pesquisa Multicriterio - Segundo Parametro - Parte F

DICAS 3026 - WINDEV TUTORIAL 49 - Pesquisa Multicriterio - Parametro Data - Parte G

DICAS 3027 - WINDEV TUTORIAL 50 - IMPRIMIR_TABELA

DICAS 3028 - WINDEV TUTORIAL 51 - IMPRIMIR PEDIDO-CRIACAO RELATORIO - PARTE A

DICAS 3029 - WINDEV TUTORIAL 52 - IMPRIMIR PEDIDO - CRIAR O RELATORIO BASE QUERY - PARTE B

DICAS 3030 - WINDEV TUTORIAL 53 - IMPRIMIR PEDIDO - ALTERACOES RELATORIO - PARTE C

DICAS 3031 - WINDEV TUTORIAL 54 - IMPRIMIR PEDIDO - MENU RELATORIO - PARTE D

DICAS 3032 - WINDEV TUTORIAL 55 - RELATORIO LISTA CLIENTE - PARTE A

DICAS 3033 - WINDEV TUTORIAL 56 - RELATORIO CLIENTE - Imprimir - PARTE B

DICAS 3034 - WINDEV TUTORIAL 57 - ESTATISTICAS GRAFICO PIVOT - QUERY ANO - PARTE A

domingo, 16 de agosto de 2020

DICAS 3032 - WINDEV TUTORIAL 55 - RELATORIO LISTA CLIENTE - PARTE A

PK13K593g4M

Bom Dia/Boa Tarde/Boa Noite

Esse Ao Vivo vai estrear as 18:00 do dia 27/08/2020

DICAS 3032 - WINDEV TUTORIAL 55 - RELATORIO LISTA CLIENTE - PARTE A

Tutoriel WINDEV : Leçon 4.7.a. Imprimer une liste de clients - Requête

https://windevdesenvolvimento.blogspot.com/2020/08/dicas-3032-windev-tutorial-55-relatorio.html

ASSUNTOS

VAMOS FAZER UM RELATORIO DE CLIENTES POR PAIS E ESTADO

GERANDO RELATORIO A PARTIR ARQUIVO CLIENTE

ADICIONANDO OS BREAK DE PAIS E ESTADO

MOSTRAR O RELATORIO

https://doc.windev.com/en-US/?1410087537&name=lesson_47_printing_list_customers

Video original da Franca

https://youtu.be/oOtiDiMJYqw

Playlist Windev TUTORIAL

https://www.youtube.com/playlist?list=PLwJwZaqiZW-lxU1XF0M0htb5S5f8pavuE

ErpMatos - TgsSistemas

skype:amarildo.matos.informatica

email: amarildo.matos@gmail.com

whats: 51984197742

Youtube: Amarildo Matos

http://www.amarildomatos.com.br

https://groups.google.com/forum/#!forum/amarildowindev

www.windev.com

https://www.pcsoft.fr/webinaires.htm?p=forumpcs

https://forum.pcsoft.fr/fr-FR/pcsoft.br.windev/page/1.awp

https://www.windev.com/windev/WD-Express.htm

https://www.windev.com/windevmobile/WM-Express.htm

http://windevdesenvolvimento.blogspot.com.br/2017/07/menu-blog.html

Lesson 4.7. Printing a list of customers

This lesson will teach you the following concepts

Creating a report with breaks.
Starting the report print.


	Estimated time: 20 mn

Previous Lesson

Table of contents

Next Lesson

Overview

This lesson is used to print a list of customers, grouped by country and by state or province.

To do so, we are going to use a table report in order to clearly represent a list of data.


	Answer	If you did not create the windows in the previous lessons, you can follow this lesson by opening a corrected project: in WINDEV's home page (Ctrl + <), click "Tutorial" and select "Full application (With windows)". A full corrected application project is also available: in WINDEV's home page (Ctrl + <), click "Tutorial" and select "Full application (Answer)".

Creating the report

To create a report:

Click among the quick access buttons.
The element creation window appears: click "Report" then "Report". The report creation wizard starts. The report creation wizard proposes several types of reports:
Select "Table". Go to the next step.
Select the data source of report. The report will be based on the Customer data file. Select "From a data file or from an existing query".
Go to the next step.
In the list of data files and queries, select the "Customer" data file. Go to the next step.
Define the data file search key. In our case, the Customer data file will be browsed using the customer's full name. Select the "FullName" search key.
Go to the next step.
We are now going to define the sort option of data in the report. By default, the wizard proposes the item used as search key in the data file. Since we want to create a report to list customers by country and by state, we will add a sort on these two items.
To add a sort on the country:
- Click on "+" to add a sort item.
- In the window that is displayed, select the Customer.Country item.
- Validate.
To add a sort on the state:
- Click on "+" to add a sort item.
- In the window that is displayed, select the Customer.StateProvinceRegion item.
- Validate.
Modify the order of sort items. The customers must be sorted by country, by state, then in alphabetical order.
- The "Customer.Country" item appears in second sort item. Select this item and move it in first sort item via the arrow buttons.
- The "Customer.StateProvinceRegion" item appears in third sort item. Select this item and move it in second sort item via the arrow buttons.
  Go to the next step.

The wizard asks you to specify whether a break is required.


	Remark	What is a break? A Break is an operation used to group the records (or rows) according to one or more criteria. Caution, the records (or rows) will be printed. A break is NECESSARILY linked to a sort. You will notice the presence of a break header and footer. The information common to the different rows is found in the break header. The totals, counters, ... are found in the break footer. This break is used to group a set of records according to the same criterion. In our example, the break is set on the country and it is used to group all the customers living in the same country.

Answer "Yes". Go to the next step.
Specify the sort item on which the break must be set. In our case, we will be using several breaks:
- the first break is set on the country.
- the second break is set on the state.
Uncheck the "Customer.FullName" item.
Go to the next step.
You are going to specify the order in which the items will be printed and how they will be distributed in the different blocks. In our example:
- only the country will be in the "Start of break 1" block. The "Country" item is automatically associated with the "Start of break 1".
- only the state will be in the "Start of break 2" block. The "StateProvinceRegion" item is automatically associated with the "Start of break 2".
- only the FullName, Address, ZipCode, City, StateProvinceRegion and Country items will be displayed in the report.
Uncheck the CustomerID, Complement, Phone, Cell and Email items.
Go to the next step.

This step is used to define the report layout.

We will keep the default values with the "Portrait" orientation.


	Remark	Print margins When choosing the print margins, don't forget to take into account the physical margins of printers. The physical margins of printers are margins where no print is allowed. Furthermore, the physical margins differ according to the type of printer.

Go to the next step.
This step allows you to select the skin template used for the report. We recommend that you use the same skin template as the one used for the windows. In our case, select the "Phoenix" skin template for example and go to the next step.
All we have to do now is give a name and caption to the report and save it.
- Type the title: "List of customers".
- Keep the name proposed by default: "RPT_List_of_customers".
Validate.
Validate in order to switch to landscape mode.
Accept to reduce the report by validating.
The report is displayed in the report editor. Save the report.