Difference between revisions of "LibreOffice-Suite-Base/C2/Create-reports/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
Line 283: Line 283:
  
 
|-
 
|-
||07;12
+
||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;54
+
||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;01
+
||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;25
+
||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.

Contributors and Content Editors

Gaurav, Minal, PoojaMoolya, Sandhya.np14