domingo, 16 de agosto de 2020

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



https://youtu.be/KwqNLAME1b8


Bom Dia/Boa Tarde/Boa Noite


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

DICAS 3028 - WINDEV TUTORIAL 51 - IMPRIMIR PEDIDO - CRIACAO RELATORIO - PARTE A
Tutoriel WINDEV : Leçon 4.6.a. Imprimer une commande - Création de la requête

ASSUNTOS

EXPLICANDO COMO SERA FEITO OS RELATORIOS
CRIANDO UMA QUERY SQL NOVA
ESCOLHENDO CAMPOS CLIENTES
ESCOLHENDO CAMPOS PEDIDO
ESCOLHENDO CAMPOS ITENS PEDIDO
ESCOLHENDO CAMPOS PRODUTOS
VOLTANDO PEDIDO E ESCOLHENDO TOTAIS
GERANDO A QUERY
  

Video original da Franca

https://youtu.be/HubsShgavqg


Playlist Windev TUTORIAL











Lesson 4.6. Printing an order
This lesson will teach you the following concepts
  • Creating a report based on a query.
  • Printing a report based on a query with parameters.
Lesson duration

Estimated time: 30 mn
Previous LessonTable of contentsNext Lesson
Overview
We will now give the user the possibility to print the details of the requested order. The report can be directly printed via the popup menu of Table control.

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)". In this case, to follow the rest of the lesson, select the "Windows 32-bit executable" configuration in the "Project explorer" pane.
Creating the "Order form" report
First of all, we are going to list the information that will be displayed in the report:
  • The order characteristics: date and order number.
  • The personal customer details: name, address, zip code, city and country.
  • The characteristics of order lines:
    • Ordered quantity,
    • Product reference,
    • Product caption,
    • Total BT,
    • Total IOT.
To easily create this report, the data to print will be grouped in a query. This query can be used by the report or by any other element of WINDEV project (Table control, Looper control, ...).

Remark

WINDEV proposes to create reports from several data sources: data files, queries, controls, text files, ...
In most cases, we advise you to group the data to print via a query and to create a report based on this query. To add an information into the report, all you have to do is add the corresponding item into the query.
The reports based on data files must be simple reports, which means reports used to display data coming from a single data file.

Creating the query

  • The query editor will be used to create the base query of report.
    1. Click Creating an element among the quick access buttons. The element creation window appears: click "Query­". The query creation wizard starts.
    2. Select the "Select" option.
      Indeed, this query will be used to select the records that will be printed in the report. Go to the next step.
    3. The query description window is displayed. To build the query, we are going to select the elements that will be displayed in the result.
    4. Double-click the items in the analysis, to the left of the description window. The items taken into account are displayed in the middle of the screen.
      We want to print in the report:
      • information regarding the customer. In the "Customer" data file, double-click the FullName, Address, ZipCode, City, and Country items.
      • information regarding the order. In the "Orders" data file, double-click the OrderID and Date items.
      • information regarding the product. In the "Product" data file, double-click the Reference, Caption, and PriceBT items.
      • information regarding the order line. In the "OrderLine" data file, double-click the Quantity and TotalBT items.
      • information regarding the grand total of order. In the "Orders" data file, double-click the TotalBT and TotalIOT items.

        Remark

        The order in which the items are inserted into the query is important. Indeed, this order corresponds to the order used to display the data in the report. The creation of the corresponding report will be simplified if this order is properly defined.
The description window of query is as follows:
Query description
At this time, this query is used to select all orders and the corresponding order lines.
We want to select the data corresponding to a single order whose identifier is known. Therefore, we are going to define the order number in parameter.
  • To manage the "Order identifier" parameter:
    1. Select the Orders.OrdersID item (in the middle of the screen).
    2. Expand "Selection condition" and select "New condition".
    3. In the window that is displayed, we are going to specify that the selection condition corresponds to a parameter:
      Describing a condition
      Perform the following operations:
      • Select "Is equal to".
      • Check "the parameter".
      • The name of the parameter is automatically proposed: "ParamOrdersID".
    4. Validate the condition description window. The number "1" is displayed on the right of Orders.OrdersID item, indicating that a selection condition was defined.
    5. Give a name to the query: type "QRY_OrderForm" instead of "QRY_NoName1" in the "Query name" area:
      Query name
    6. Validate the query description window ("OK" button).
    7. The save window is displayed. Validate the proposed information.
    8. The graphic query representation is displayed:
      Graphic representation


DICAS 2978 - WINDEV TUTORIAL 1 - 1.1B - WINDEV TEMA ESCURO E IDIOMA DO AMBIENTE
DICAS 2979 - WINDEV TUTORIAL 2 - 1.2- CRIAR JANELA E INSERIR TEXTO E EXIBIR
DICAS 2980 - WINDEV TUTORIAL 3 - 2.1- VARIAVEIS PARTE 1
DICAS 2981 - WINDEV TUTORIAL 4 - 2.2- VARIAVEIS ESCOPO - PARTE 2
DICAS 2982 - WINDEV TUTORIAL 5 - 2.1- VARIAVEIS OPERADORES PARTE 3
DICAS 2983 - WINDEV TUTORIAL 6 - 2.1.D - VARIAVEIS STRINGS PARTE 4
DICAS 2984 - WINDEV TUTORIAL 7 - 2.1.E - VARIAVEIS ARRAYS PARTE 5
DICAS 2985 - WINDEV TUTORIAL 8 - 2.2.A - CONDICOES IF-SWITCH PARTE 1
DICAS 2986 - WINDEV TUTORIAL 9 - 2.2.B - CONDICOES PARTE 2
DICAS 2987 - WINDEV TUTORIAL 10 - 2.3.A - LOOP PARTE 1
DICAS 2988 - WINDEV TUTORIAL 11 - 2.3.B - LOOP EXEMPLOS PARTE 2
DICAS 2989 - WINDEV TUTORIAL 12 - Lesson 2.4. The procedures - PARTE 1
DICAS 2990 - WINDEV TUTORIAL 13 - Leçon 2.4.b. Procedures Parametros - PARTE 2
DICAS 2991 - WINDEV TUTORIAL 14 - PROCEDURES REFERENCIA - PARTE 3
DICAS 2992 - WINDEV TUTORIAL 15 - PROCEDURES OPCIONAIS OU OBRIGATORIAS - PARTE 4
DICAS 2993 - WINDEV TUTORIAL 16 - PROCEDURES EXEMPLOS - PARTE 5
DICAS 2994 - WINDEV TUTORIAL 17 - PERGUNTAS E RESPOSTA - PARTE 1
DICAS 2995 - WINDEV TUTORIAL 18 - PERGUNTAS E RESPOSTA - PARTE 2
DICAS 2996 - WINDEV TUTORIAL 19 - WINDEV E OS BANCOS DE DADOS
DICAS 2997 - WINDEV TUTORIAL 20 - PROJETO E ANALISE - CRIACAO
DICAS 2998 - WINDEV TUTORIAL 21 - PROJETO E ANALISE - ARQUIVOS DADOS CLIENTE - PARTE 2
DICAS 2999 - WINDEV TUTORIAL 22 - PROJETO E ANALISE - ARQUIVOS DADOS CRIACAO ARQUIVO PEDIDO - PARTE 3
DICAS 3000 - WINDEV TUTORIAL 23 - PROJETO E ANALISE - IMPORTANDO CVS-ARQUIVO TEXTO - PARTE 4
DICAS 3001 - WINDEV TUTORIAL 24 - PROJETO E ANALISE - IMPORTANDO ARQUIVO PRODUTO - PARTE 5
DICAS 3002 - WINDEV TUTORIAL 25 - PROJETO E ANALISE - LINK - PARTE 6
DICAS 3003 - WINDEV TUTORIAL 26 - RAD COMPLETO
DICAS 3004 - WINDEV TUTORIAL 27 - VISAO GERAL
DICAS 3005 - WINDEV TUTORIAL 28 - Adicionar e Modificar Janelas PRODUTOS - PARTE A
DICAS 3006 - WINDEV TUTORIAL 29 - Adicionar e Modificar Janelas PRODUTOS Formulario - PARTE B
DICAS 3007 - WINDEV TUTORIAL 30 - Adicionar e Modificar Janelas PRODUTOS ALINHAR CAMPOS - PARTE C




Nenhum comentário:

Postar um comentário

Teste

Teste
teste