This is a Clilstore unit. You can .
This module presents the last type of object in LO Base; the reports (informes). The reports allow to set up (configurar) how to print in paper the information from a table or query
Creation of reports from tables and queries using the report wizard
LO Base can create new reports automatically only using a report wizard (un asistente de informes). But once created the report can be edited, and modified manually
Select the icon informes to see the reports in your database
The following image shows a report created using the report wizard
EXERCISE 1
Open the database biblioteca.odb
Select the icon informes in the left vertical panel
Select the option crear un informe utilizando el assistente
The first step is to select a data source, that is the table or query from which the data to print will be taken out.
Select the table Llibres and the fields shown in the image below
Next step is to tag (etiquetar) the fields. That is, for each field, write a headline (títular, cabecera, o texto explicativo de lo que es el campo) for each field in the report.
Now select the fields used to group the information. In this exercise we want to show for each author, all the books he has written. So we group by the field Autors, as shown below
Next step, we must select the fields used to order the report. By default, the report is ordered by the grouped fields.
Select the field titol as shown in the image below to order the report.
Next step is to select a predefined design for the report.
Try out (prueba) the different design options, (you can see the designs in the background window.
Finally select orientacion vertical
EXERCISE 2. Make a report for the table categories.
All the fields must be shown.
Change the tag in the field Idcategoria by 'code', and Nombrecategoria by 'Category name' and descripció by 'description.
Order the report by nombrecategoria.
Choose portrait orientation (orientación de página vertical)
Choose the design you like the most, but it must be different than the one used in the previous exercise
EXERCISE 3. Make a report for the table Productes
Fields IdProducte, nom de producte, nom llatí and preu per unitat.
Order the report by nom, and categoria
Choose portrait orientation (orientación de página vertical)
Choose the design you like the most, but it must be different than the one used in the previous exercise
EXERCISE 4. Make a report for the table clientes
Include all fields
Tag (etiqueta) the field Idcliente as “Client Number”
Order it by cognom, and nom regio.
Choose landscape orientation (orientación de página horizontal)
Choose the design you like the most, but it must be different than the one used in the previous exercise
EXERCISE 5
Now we are going to create a query to show the books written in a given language. Make this query following the instructions shown in the image below. Notice that the criteria in the row “criteri” in the column Llengua is a question mark ('?')
Name this query as Libres per llengua.
Open LO Base main window and click on the icon report in the left vertical panel
Create a new report using the wizard
Select as source the query Libres per llengua.
Select all the fields in the query
Don't change the default tags
Select the field Llengua as group field. .
Select the format of your choice.
Call this report exercise 5 and click in the button finalitzar.
Open the report. A windows open asking for a code of language. Insert 'cat'
Click on d'acord to see the final result.
Exercise 6 Make a report for the table empleados showing grouping o rders per employee (los pedidos agrupados, por empleado que los atiende), for employees working in Seattle or Vancouber. You must group the orders by the surnames of the employee.
EXERCISE 7 Make a report showing products grouped from suppliers belonging to the states WA, CA, NY, or MD The report must show the records products grouped by idproveedor. The subreport must show the fields product id, product name and supplier city and state
UPLOAD TO MOODLE THE FILES GARDENCO-LLIUREX AND BIBLIOTECA WITH ALL THE QUERIES AND REPORTS ASKED IN THIS MODULE
Short url: https://clilstore.eu/cs/4728