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

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(3 intermediate revisions by 2 users not shown)
Line 4: Line 4:
 
|-
 
|-
 
||00:00
 
||00:00
−
||Welcome to the Spoken tutorial on LibreOffice Base.
+
||Welcome to the '''Spoken tutorial''' on '''LibreOffice Base'''.
  
 
|-
 
|-
 
||00:03
 
||00:03
−
||In this tutorial, we will learn how to
+
||In this tutorial, we will learn how to:
  
 
|-
 
|-
 
||00:07
 
||00:07
−
||Create a report.Select, Label and Sort the report fields.
+
||Create a '''report'''. Select, Label and Sort the report fields.
  
 
|-
 
|-
 
||00:12
 
||00:12
−
||Select report layout and Choose report type: static or dynamic.  
+
||Select report layout and choose report type: static or dynamic.  
  
 
|-
 
|-
 
||00:19
 
||00:19
−
||For this, let us consider our familiar Library database example.  
+
||For this, let us consider our familiar '''Library''' database example.  
  
 
|-
 
|-
 
||00:27
 
||00:27
−
||Here, we have stored information about books and members in this Library database,
+
||Here, we have stored information about books and members in this Library database.
  
 
|-
 
|-
 
||00:36
 
||00:36
−
||We also have a table to track the books issued to the members.  
+
||We also have a '''table''' to track the books issued to the members.  
  
 
|-
 
|-
 
||00:42
 
||00:42
−
||We learnt how to create forms and queries in the previous tutorials.
+
||We learnt how to create '''form'''s and queries in the previous tutorials.
  
 
|-
 
|-
 
||00:48
 
||00:48
−
||Before learning how to create a report, let us first learn what a report is?
+
||Before learning how to create a '''report''', let us first learn what a report is?
  
 
|-
 
|-
 
||00:56
 
||00:56
−
||A report is another way to retrieve information from a database, similar to a query.  
+
||A report is another way to retrieve information from a database, similar to a '''query'''.  
  
 
|-
 
|-
 
||01:05
 
||01:05
−
||We can customize its layout, look and feel, so that it is easy to read or print on paper.
+
||We can customize its layout, look and feel so that it is easy to read or print on paper.
  
 
|-
 
|-
 
||01:14
 
||01:14
−
||Reports can be generated from the database’s tables or queries.  
+
||'''Report'''s can be generated from the database’s '''table'''s or queries.  
  
 
|-
 
|-
 
||01:21
 
||01:21
−
||They can also contain all the fields in the table or in the query, or only a selected group of fields.
+
||They can also contain all the fields in the table or in the query or only a selected group of fields.
  
 
|-
 
|-
 
||01:32
 
||01:32
−
||There are two categories of reports - static and dynamic.
+
||There are two categories of reports - '''static''' and '''dynamic'''.
  
 
|-
 
|-
 
||01:38
 
||01:38
−
||Whenever a Static report is opened for viewing,
+
||Whenever a '''Static report''' is opened for viewing,
  
 
|-
 
|-
Line 72: Line 72:
 
|-
 
|-
 
||01:52
 
||01:52
−
||But a Dynamic report will show current data from the database, whenever it is opened for viewing.
+
||But a '''Dynamic report''' will show current data from the database, whenever it is opened for viewing.
  
 
|-
 
|-
Line 80: Line 80:
 
|-
 
|-
 
||02:05
 
||02:05
−
||In the Library database,  
+
||In the 'Library' database,  
  
 
|-
 
|-
 
||02:08
 
||02:08
−
||let us click on the Reports icon on the left panel.  
+
||let us click on the '''Reports''' icon on the left panel.  
  
 
|-
 
|-
Line 96: Line 96:
 
|-
 
|-
 
||02:24
 
||02:24
−
||We now see a new window which is also called the Report Builder window,
+
||We now see a new window which is also called the '''Report Builder''' window  
  
 
|-
 
|-
Line 104: Line 104:
 
|-
 
|-
 
||02:39
 
||02:39
−
||We will go through the wizard to create a report based on a query we created in the last tutorial.
+
||We will go through the wizard to create a report based on a query we created in the last tutorial-
  
 
|-
 
|-
 
||02:47
 
||02:47
−
||History of books issued to the Library members’
+
||''''History of books issued to the Library members’'''.
  
 
|-
 
|-
 
||02:51
 
||02:51
−
||We are in Step 1 - Field Selection.  
+
||We are in '''Step 1 - Field Selection'''.  
  
 
|-
 
|-
Line 120: Line 120:
 
|-
 
|-
 
||03:05
 
||03:05
−
||Let us choose our query: ‘History of Books Issued to Members’ from the drop down list at the top.
+
||Let us choose our '''query: ‘History of Books Issued to Members’''' from the drop-down list at the top.
  
 
|-
 
|-
Line 128: Line 128:
 
|-
 
|-
 
||03:21
 
||03:21
−
||We want all the fields in our report, so we'll simply click on the double arrow button towards the right.
+
||We want all the fields in our report; so we'll simply click on the double-arrow button towards the right.
  
 
|-
 
|-
 
||03:30
 
||03:30
−
||Now let us click on the Next button to go to the next step.
+
||Now let us click on the '''Next''' button to go to the next step.
  
 
|-
 
|-
 
||03:35
 
||03:35
−
||Step 2. Labelling Fields.
+
||'''Step 2. Labelling Fields'''.
  
 
|-
 
|-
 
||03:39
 
||03:39
−
||Let us type the following descriptive labels in the label text boxes as shown in the image.  
+
||Let us type the following descriptive labels in the label text-boxes as shown in the image.  
  
 
|-
 
|-
 
||03:50
 
||03:50
−
||Okay, let us click on the next button now.
+
||Okay, let us click on the '''Next''' button now.
  
 
|-
 
|-
 
||03:55
 
||03:55
−
||We are in Step 3 - Grouping.  
+
||We are in '''Step 3 - Grouping'''.  
  
 
|-
 
|-
Line 156: Line 156:
 
|-
 
|-
 
||04:05
 
||04:05
−
||For example, in our report, we can group the data by Book titles.  
+
||For example- in our report, we can group the data by '''Book title'''s.  
  
 
|-
 
|-
Line 172: Line 172:
 
|-
 
|-
 
||04:31
 
||04:31
−
||So we will simply click on the Next button.
+
||So, we will simply click on the '''Next''' button.
  
 
|-
 
|-
 
||04:36
 
||04:36
−
||Now we are in Step 4 - Sorting Options.  
+
||Now, we are in 'Step 4 - Sorting Options'.  
  
 
|-
 
|-
 
||04:41
 
||04:41
−
||Let us sort the data in chronological order,
+
||Let us sort the data in chronological order.
  
 
|-
 
|-
Line 188: Line 188:
 
|-
 
|-
 
||04:52
 
||04:52
−
||For this, we will click the Sort by dropdown box,
+
||For this, we will click the '''Sort by''' drop-down box  
  
 
|-
 
|-
 
||04:58
 
||04:58
−
||and then click on Issue Date.  
+
||and then click on '''Issue Date'''.  
  
 
|-
 
|-
 
||05:03
 
||05:03
−
||Then we will click on the second dropdown box  
+
||Then we will click on the second drop-down box  
  
 
|-
 
|-
 
||05:08
 
||05:08
−
||and then click on the Book Title.
+
||and then click on the '''Book Title'''.
  
 
|-
 
|-
 
||05:12
 
||05:12
−
||Now let us click on the Next button.
+
||Now, let us click on the '''Next''' button.
  
 
|-
 
|-
 
||05:16
 
||05:16
−
||Okay. Step 5. Choose Layout.  
+
||Okay. '''Step 5.- Choose Layout'''.  
  
 
|-
 
|-
Line 216: Line 216:
 
|-
 
|-
 
||05:25
 
||05:25
−
||Let us click on the ‘Columnar, single-column’ layout list.  
+
||Let us click on the '''‘Columnar, single-column’''' layout list.  
  
 
|-
 
|-
 
||05:31
 
||05:31
−
||Notice that the background Report Builder has refreshed.  
+
||Notice that the background '''Report Builder''' has refreshed.  
  
 
|-
 
|-
Line 228: Line 228:
 
|-
 
|-
 
||05:43
 
||05:43
−
||Let us now click on the ‘Columnar, two columns’.
+
||Let us now click on the '''‘Columnar, two columns’'''.
  
 
|-
 
|-
Line 236: Line 236:
 
|-
 
|-
 
||05:54
 
||05:54
−
||In this way, we can choose any of the layouts that Base Wizard provides.  
+
||In this way, we can choose any of the layouts that '''Base Wizard''' provides.  
  
 
|-
 
|-
Line 244: Line 244:
 
|-
 
|-
 
||06:07
 
||06:07
−
||For now, we will click on the first item, ‘Tabular’.
+
||For now, we will click on the first item- ‘Tabular’  
  
 
|-
 
|-
 
||06:12
 
||06:12
−
||and click on the Next button.
+
||and click on the '''Next''' button.
  
 
|-
 
|-
 
||06:16
 
||06:16
−
||Okay, last step  - Create Report.  
+
||Okay, last step  - 'Create Report'.  
  
 
|-
 
|-
 
||06:20
 
||06:20
−
||Let us give a descriptive title to our report here: ‘Books Issued to Members: Report History’.
+
||Let us give a descriptive title to our report here: "Books Issued to Members: Report History".
  
 
|-
 
|-
Line 264: Line 264:
 
|-
 
|-
 
||06:38
 
||06:38
−
||For this, let us click on the ‘Dynamic Report’ option,
+
||For this, let us click on the '''Dynamic Report''' option  
  
 
|-
 
|-
Line 272: Line 272:
 
|-
 
|-
 
||06:52
 
||06:52
−
||Okay, we are done with our Report. Let us click on the ‘Create Report now’ option  
+
||Okay, we are done with our '''Report'''. Let us click on the '''Create Report now''' option  
  
 
|-
 
|-
 
||06:59
 
||06:59
−
||and finally click on the Finish button.
+
||and finally click on the '''Finish''' button.
  
 
|-
 
|-
 
||07:05
 
||07:05
−
||Now we see a new window and this is the Report that we built just now.  
+
||Now we see a new window and this is the '''Report''' that we built just now.  
  
 
|-
 
|-
−
||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.  
  
 
|-
 
|-
 
||07:24
 
||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.  
+
||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
 
||07:38
−
||Thus we have created our chronological report of books issued to the Library members.
+
||Thus we have created our chronological report of books issued to the '''Library''' members.
  
 
|-
 
|-
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.
  
 
|-
 
|-
 
||08:07
 
||08:07
−
||Use the Columnar, Single-column layout.
+
||Use the '''Columnar, Single-column''' layout.
  
 
|-
 
|-
 
||08:11
 
||08:11
−
||This brings us to the end of this tutorial on Reports in LibreOffice Base  
+
||This brings us to the end of this tutorial on '''Reports''' in '''LibreOffice Base'''.
  
 
|-
 
|-
Line 324: Line 324:
 
|-
 
|-
 
||08:21
 
||08:21
−
||Create a Report
+
|| Create a Report Select, Label and Sort the report fields
  
 
|-
 
|-
−
||08;22
+
||08:25
−
||Select, Label and Sort the report fields
+
||Select report layout And * choose report type: static or dynamic.
−
 
+
−
|-
+
−
||08;25
+
−
||Select report layout
+
−
 
+
−
|-
+
−
||08:26
+
−
||And choose report type: static or dynamic
+
  
 
|-
 
|-
 
||08:31
 
||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.  
+
||'''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
 
||08:42
−
||This project is co-ordinated by http://spoken-tutorial.org.  
+
||This project is coordinated by http://spoken-tutorial.org.  
  
 
|-
 
|-
Line 352: Line 344:
 
|-
 
|-
 
||08:51
 
||08:51
−
||This script has been contributed by Priya Suresh, DesiCrew Solutions And this is Soundharya, DesiCrew Solutions, signing off. Thanks for joining
+
||This script has been contributed by Priya Suresh, DesiCrew Solutions. And this is Soundharya, DesiCrew Solutions, signing off. Thanks for joining.

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

Retrieved from "https://script.spoken-tutorial.org/index.php?title=LibreOffice-Suite-Base/C2/Create-reports/English-timed&oldid=33640"