LibreOffice-Suite-Base/C2/Create-reports/English-timed - Revision history

PoojaMoolya at 07:37, 23 March 2017

2017-03-23T07:37:29Z

PoojaMoolya at 05:04, 10 March 2017

2017-03-10T05:04:11Z

Sandhya.np14 at 11:23, 29 September 2015

2015-09-29T11:23:46Z

Show changes

Sandhya.np14 at 09:20, 29 September 2015

2015-09-29T09:20:21Z

Gaurav at 09:32, 9 July 2014

2014-07-09T09:32:36Z

Minal: Created page with '{| border=1 !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 r…'

2012-12-27T11:15:07Z

Created page with '{| border=1 !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 r…'

New page

{| border=1
!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

@@ 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.
@@ Line 303: / Line 303: @@
 |-
-||07;54
+||07:54
 ||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.
@@ Line 327: / Line 327: @@
 |-
-||08;25
+||08:25
 ||Select report layout And * choose report type: static or dynamic.

@@ Line 12: / Line 12: @@
 |-
 ||00:07
-||* Create a '''report'''.
+||Create a '''report'''. Select, Label and Sort the report fields.
-* Select, Label and Sort the report fields.
 |-
 ||00:12
-||* Select report layout and choose report type: static or dynamic.
+||Select report layout and choose report type: static or dynamic.
 |-
@@ Line 325: / Line 324: @@
 |-
 ||08:21
-||* Create a Report
+|| Create a Report Select, Label and Sort the report fields
-−
-|-
-||08;22
-||* Select, Label and Sort the report fields
 |-
 ||08;25
-||* Select report layout
+||Select report layout And * choose report type: static or dynamic.
-−
-|-
-||08:26
-||And * choose report type: static or dynamic.
 |-

@@ Line 4: / Line 4: @@
 |-
 ||00:00
-||Welcome to the Spoken tutorial on LibreOffice Base.
+||Welcome to the '''Spoken tutorial''' on '''LibreOffice Base'''.
 |-
 ||00:03
-||In this tutorial, we will learn how to
+||In this tutorial, we will learn how to:
 |-
 ||00:07
-||Create a report.Select, Label and Sort the report fields.
+||* Create a '''report'''.
 |-
 ||00:12
-||Select report layout and Choose report type: static or dynamic.
+||* Select report layout and choose report type: static or dynamic.
 |-
 ||00:19
-||For this, let us consider our familiar Library database example.
+||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,
+||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.
+||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.
+||We learnt how to create '''form'''s and queries in the previous tutorials.
 |-
 ||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
-||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
-||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
-||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
-||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
-||There are two categories of reports - static and dynamic.
+||There are two categories of reports - '''static''' and '''dynamic'''.
 |-
 ||01:38
-||Whenever a Static report is opened for viewing,
+||Whenever a '''Static report''' is opened for viewing,
 |-
@@ Line 72: / Line 73: @@
 |-
 ||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 81: @@
 |-
 ||02:05
-||In the Library database,
+||In the 'Library' database,
 |-
 ||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 97: @@
 |-
 ||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 105: @@
 |-
 ||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
-||History of books issued to the Library members’
+||''''History of books issued to the Library members’'''.
 |-
 ||02:51
-||We are in Step 1 - Field Selection.
+||We are in '''Step 1 - Field Selection'''.
 |-
@@ Line 120: / Line 121: @@
 |-
 ||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 129: @@
 |-
 ||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
-||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
-||Step 2. Labelling Fields.
+||'''Step 2. Labelling Fields'''.
 |-
 ||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
-||Okay, let us click on the next button now.
+||Okay, let us click on the '''Next''' button now.
 |-
 ||03:55
-||We are in Step 3 - Grouping.
+||We are in '''Step 3 - Grouping'''.
 |-

@@ Line 1: / Line 1: @@
 {| border=1
-!Visual Cues
+|'''Time'''
-!Narration
+|'''Narration'''
 |-
 ||00:00