Difference between revisions of "LibreOffice-Suite-Base/C2/Create-reports/English-timed"
From Script | Spoken-Tutorial
PoojaMoolya (Talk | contribs) |
PoojaMoolya (Talk | contribs) |
||
| Line 283: | Line 283: | ||
|- | |- | ||
| − | ||07 | + | ||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. | ||Notice that it has the field labels at the top, in '''bold''' font and the actual data is listed in a tabular fashion. | ||
| Line 303: | Line 303: | ||
|- | |- | ||
| − | ||07 | + | ||07:54 |
||Create a report of all the books in the library grouped by their '''Publishers'''. | ||Create a report of all the books in the library grouped by their '''Publishers'''. | ||
|- | |- | ||
| − | ||08 | + | ||08:01 |
||Both '''Publishers''' and '''Book titles''' need to be in ascending order. | ||Both '''Publishers''' and '''Book titles''' need to be in ascending order. | ||
| Line 327: | Line 327: | ||
|- | |- | ||
| − | ||08 | + | ||08:25 |
||Select report layout And * choose report type: static or dynamic. | ||Select report layout And * choose report type: static or dynamic. | ||
Latest revision as of 13:07, 23 March 2017
| Time | 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 drop-down box |
| 04:58 | and then click on Issue Date. |
| 05:03 | Then we will click on the second drop-down 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 Select, Label and Sort the report fields |
| 08:25 | Select report layout 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 coordinated 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. |
