LibreOffice-Suite-Base/C2/Create-reports/English-timed
From Script | Spoken-Tutorial
Visual Cues | Narration |
---|---|
00:00 | Welcome to the Spoken tutorial on LibreOffice Base. |
00:03 | In this tutorial, we will learn how to |
00:07 | Create a report.Select, Label and Sort the report fields. |
00:12 | Select report layout and Choose report type: static or dynamic. |
00:19 | For this, let us consider our familiar Library database example. |
00:27 | Here, we have stored information about books and members in this Library database, |
00:36 | We also have a table to track the books issued to the members. |
00:42 | We learnt how to create forms and queries in the previous tutorials. |
00:48 | Before learning how to create a report, let us first learn what a report is? |
00:56 | A report is another way to retrieve information from a database, similar to a query. |
01:05 | We can customize its layout, look and feel, so that it is easy to read or print on paper. |
01:14 | Reports can be generated from the database’s tables or queries. |
01:21 | They can also contain all the fields in the table or in the query, or only a selected group of fields. |
01:32 | There are two categories of reports - static and dynamic. |
01:38 | Whenever a Static report is opened for viewing, |
01:42 | it will always display the same data which was there at the time the report was created. |
01:48 | This is also known as a snapshot. |
01:52 | But a Dynamic report will show current data from the database, whenever it is opened for viewing. |
02:00 | Okay, now, let us create a sample report. |
02:05 | In the Library database, |
02:08 | let us click on the Reports icon on the left panel. |
02:12 | On the right panel, let us click on ‘Use Wizard to create report’. |
02:18 | This is an easy and fast option to build reports. |
02:24 | We now see a new window which is also called the Report Builder window, |
02:31 | and we also see a wizard with 6 steps listed on the left hand side. |
02:39 | We will go through the wizard to create a report based on a query we created in the last tutorial. |
02:47 | History of books issued to the Library members’ |
02:51 | We are in Step 1 - Field Selection. |
02:56 | We will specify the source of the report data here: either a table or a query. |
03:05 | Let us choose our query: ‘History of Books Issued to Members’ from the drop down list at the top. |
03:14 | Now we see a list of available fields from the query on the left hand side. |
03:21 | We want all the fields in our report, so we'll simply click on the double arrow button towards the right. |
03:30 | Now let us click on the Next button to go to the next step. |
03:35 | Step 2. Labelling Fields. |
03:39 | Let us type the following descriptive labels in the label text boxes as shown in the image. |
03:50 | Okay, let us click on the next button now. |
03:55 | We are in Step 3 - Grouping. |
03:59 | This is used whenever we need to group the data by a set of selected fields. |
04:05 | For example, in our report, we can group the data by Book titles. |
04:12 | If we do that, then in the report we will see a book title and then all the members that it was issued to. |
04:22 | Then we will see the next book title, and so on. |
04:27 | For now, let us keep our report simple. |
04:31 | So we will simply click on the Next button. |
04:36 | Now we are in Step 4 - Sorting Options. |
04:41 | Let us sort the data in chronological order, |
04:46 | And then sort it by the Book title in ascending order. |
04:52 | For this, we will click the Sort by dropdown box, |
04:58 | and then click on Issue Date. |
05:03 | Then we will click on the second dropdown box |
05:08 | and then click on the Book Title. |
05:12 | Now let us click on the Next button. |
05:16 | Okay. Step 5. Choose Layout. |
05:20 | We can customize the look and feel of the report here. |
05:25 | Let us click on the ‘Columnar, single-column’ layout list. |
05:31 | Notice that the background Report Builder has refreshed. |
05:36 | It shows all the labels on the left and corresponding fields on the right. |
05:43 | Let us now click on the ‘Columnar, two columns’. |
05:48 | Again the window below has refreshed to show a two column layout. |
05:54 | In this way, we can choose any of the layouts that Base Wizard provides. |
06:02 | We can also modify it later as per our requirement. |
06:07 | For now, we will click on the first item, ‘Tabular’. |
06:12 | and click on the Next button. |
06:16 | Okay, last step - Create Report. |
06:20 | Let us give a descriptive title to our report here: ‘Books Issued to Members: Report History’. |
06:30 | Now let us design our report so that the report will always return the latest data from the database. |
06:38 | For this, let us click on the ‘Dynamic Report’ option, |
06:45 | as we would always like to see the latest data, whenever we open the report for viewing. |
06:52 | Okay, we are done with our Report. Let us click on the ‘Create Report now’ option |
06:59 | and finally click on the Finish button. |
07:05 | Now we see a new window and this is the Report that we built just now. |
07;12 | Notice that it has the field labels at the top, in bold font, and the actual data is listed in a tabular fashion. |
07:24 | Also notice that it has been sorted by the Issue Date field in ascending order that is, chronologically and then by Book Title in ascending order. |
07:38 | Thus we have created our chronological report of books issued to the Library members. |
07:46 | In the next tutorial, we will learn how to modify our report. |
07:52 | Here is an assignment: |
07;54 | Create a report of all the books in the library grouped by their Publishers. |
08;01 | Both Publishers and Book titles need to be in ascending order. |
08:07 | Use the Columnar, Single-column layout. |
08:11 | This brings us to the end of this tutorial on Reports in LibreOffice Base |
08:17 | To summarize, we learned how to: |
08:21 | Create a Report |
08;22 | Select, Label and Sort the report fields |
08;25 | Select report layout |
08:26 | And choose report type: static or dynamic |
08:31 | Spoken Tutorial Project is a part of the Talk to a Teacher project, supported by the National Mission on Education through ICT, MHRD, Government of India. |
08:42 | This project is co-ordinated by http://spoken-tutorial.org. |
08:48 | More information on the same is available at the following link. |
08:51 | This script has been contributed by Priya Suresh, DesiCrew Solutions And this is Soundharya, DesiCrew Solutions, signing off. Thanks for joining |