Sandhya.np14 at 12:29, 29 September 2015

2015-09-29T12:29:33Z

Pratik kamble at 11:35, 8 May 2015

2015-05-08T11:35:34Z

Gaurav at 09:34, 9 July 2014

2014-07-09T09:34:48Z

Minal: Created page with ''''ERRATA:''' 03:21 Next, let us add another label to the report footer as shown on the screen The above phrase was to be added to Report Footer. But in the Video, it has…'

2012-12-27T11:15:51Z

Created page with ''''ERRATA:''' 03:21 Next, let us add another label to the report footer as shown on the screen <pause> The above phrase was to be added to Report Footer. But in the Video, it has…'

New page

'''ERRATA:'''
03:21 Next, let us add another label to the report footer as shown on the screen <pause>
The above phrase was to be added to Report Footer. But in the Video, it has been added to Report Header.

{| border=1
!Visual Cues
!Narration
|-
|00:02
|Welcome to the Spoken tutorial on LibreOffice Base.

|-
|00:06
|In this tutorial, we will learn how to

|-
|00:09
|Modify a report by customizing the layout and the look and feel of the report.

|-
|00:16
|For this, let us consider our familiar Library database example.

|-
|00:23
|In the previous tutorial, we learnt how to create a report

|-
|00:28
|And we built a report with the title ‘Books Issued to Members: Report History’.

We will now learn how to modify this report.

|-
|00:40
|In the Library database,

|-
|00:42
|Let us click on the Reports icon on the left panel.

|-
|00:47
|On the right panel, we see the ‘Books Issued to Members: Report History’ report in the reports list.

|-
|00:57
|Let us right click on (it and then) click on Edit to open the report for modifying or editing.

|-
|01:08
|We now see a new window which is called the Report Builder window.

|-
|01:14
|This screen is composed of three main sections.

|-
|01:19
|Page Header and Footer section that form the top and the bottom.

|-
|01:26
|Then the Header section

|-
|01:29
|and the Detail section.

|-
|01:34
|We can also add a record header and a footer section

|-
|01:40
|by right-clicking on the main screen in the white area and clicking on the ‘Insert Report Header/Footer’.

|-
|01:51
|We can shrink or expand these sections, by double clicking on the orange areas on the left of the screen.

|-
|02:00
|Before we move on, here is a screenshot of the Report design window.

|-
|02:06
|We will modify our report design to look like this.

|-
|02:11
|We will add some text labels, fonts, formatting and adjust the spacing among the various sections.

|-
|02:20
|Okay, now let us add some report headers and footers.

|-
|02:27
|To do this, we will click on the Label field icon

|-
|02:31
|In the Report Controls toolbar found below the menu bar at the top.

|-
|02:40
|Let us draw it on the Report Header area, as being shown now

|-
|02:48
|and double click on the Label to bring up its properties on the right.

|-
|02:55
|Here, let us type ‘Books Issued to Members:

|-
|03:00
|Report History’ against the Label
and press Enter.

|-
|03:07
|Let us also change the font style; we will choose Arial Black, Bold and Size 12

|-
|03:17
|and click on the Ok button.

|-
|03:21
|Next, let us add another label to the report footer as shown on the screen <pause>

|-
|03:31
|For example, lets type, ‘Report Prepared by Assistant Librarian’ <pause>

|-
|03:42
|and then change the font style to Arial, Bold Italic and Size 8. <pause>

|-
|03:51
|Now we will repeat the same steps again to add a label in the Page Footer area. <pause>

|-
|03:59
|This time, we will type, ‘Nehru Library, New Delhi’ against the label.<pause>

|-
|04:09
|and change the font style to Arial, Bold Italic and Size 8. <pause>

|-
|04:20
|Now let us adjust the spacing.

|-
|04:24
|First let us reduce the Page Header area by double clicking on the grey line between the Page Header and Report Header;

|-
|04:37
|And we will take it all the way to the top by using the click, drag and drop method.

|-
|04:47
|Next let us reduce the Report header area

|-
|04:52
|by double clicking on the grey line between the report header and the header. <pause>

|-
|05:01
|We will repeat the same steps to reduce the spacing between the Report footer and the Page footer also. <pause>

|-
|05:13
|Next, let us centre the Header labels.

|-
|05:18
|We will do this, by first selecting all the labels by clicking on the Book Title,

|-
|05:26
|And then while pressing the Shift key; we will click on the rest of the labels as shown.

|-
|05:35
|Now let us use the up arrow key to centre them.

|-
|05:41
|We will now, give the header a light blue background.

|-
|05:47
|To do this, we will go to the properties and change the Background transparent to No,

|-
|05:55
|And then select Blue 8 from the list for Background colour.

|-
|06:03
|We will do the same with the Detail section as well. <pause>

|-
|06:09
|For this we will first increase the spacing between the Detail and report footer sections <pause>

|-
|06:20
|and then centre the fields.<pause>

|-
|06:24
|We will select Light gray background for the Detail section as shown. <pause>

|-
|06:32
|Next, we will change the data formatting for the Checked In field.

|-
|06:39
|Since this holds Boolean values 1 or 0, it displays True or False.

|-
|06:47
|We will change this to show a friendlier Yes or No option.

|-
|06:53
|For this, we will double click on the CheckedIn field on the right in the Detail section.

|-
|07:01
|Now in the properties on the right, let us click on the Data tab first.

|-
|07:08
|Let us click on the button next to the Data field that says CheckedIn.

|-
|07:15
|This opens a new popup window called the Function wizard.

|-
|07:20
|Here, let us first empty the Formula text box at the bottom right;

|-
|07:27
|Then click on the Category dropdown, and then double click on ‘IF’.

|-
|07:35
|Now on the right we see new controls.

|-
|07:40
|Let us click on the Select icon on the right next to the first text box.

|-
|07:49
|Here we will double click on CheckIn.

|-
|07:53
|Next we will type in Yes within double-quotes in the second text box

|-
|08:01
|And then type in No in the third text box. <pause>

|-
|08:12
|Now we will go to the General tab within the Properties section

|-
|08:18
|And click on the button against Formatting at the bottom.

|-
|08:24
|Here we will click on ‘Text’ in the Category list

|-
|08:28
|And then click on the OK button.

|-
|08:32
|And, now, we will save the report.

|-
|08:36
|Okay, let us run our modified report now.

|-
|08:41
|For this, we will click on the Edit menu at the top and then click on the Execute Report.

|-
|08:50
|And there is our nice report history on the Books issued to the Library members.

|-
|08:57
|Notice the spacing, headers, footers, fonts

|-
|09:01
|And the CheckedIn field which says Yes or No.

|-
|09:06
|And we are done with modifying our report.

|-
|09:11
|This brings us to the end of this tutorial on Modifying a Report in LibreOffice Base

|-
|09:17
|To summarize, we learned how to:

|-
|09:20
|Modify a report by customizing the layout and the look and feel of the report.

|-
|09:26
|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. This project is co-ordinated by http://spoken-tutorial.org. More information on the same is available at the following link.

|-
|09:48
|This script has been contributed by Priya Suresh, DesiCrew Solutions.

And this is Soundharya, DesiCrew Solutions, signing off.

Thanks for joining

|-

@@ Line 1: / Line 1: @@
 {| border=1
 |'''Time'''
@@ Line 29: / Line 24: @@
 |-
 |00:28
-|And we built a report with the title ‘Books Issued to Members: Report History’.
+|And we built a report with the title ‘Books Issued to Members: Report History’.We will now learn how to modify this report.
-−
 We will now learn how to modify this report.
 |-
@@ Line 119: / Line 112: @@
 |-
 |03:00
-|Report History’ against the Label
+|Report History’ against the Label and press Enter.
 and press Enter.
 |-
@@ Line 340: / Line 332: @@
 |-
 |09:48
-|This script has been contributed by Priya Suresh, DesiCrew Solutions.
+|This script has been contributed by Priya Suresh, DesiCrew Solutions.And this is Soundharya, DesiCrew Solutions, signing off.
-−
 And this is Soundharya, DesiCrew Solutions, signing off.
-−
-−
 Thanks for joining
 |-

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

LibreOffice-Suite-Base/C2/Modify-a-Report/English-timed - Revision history

Sandhya.np14 at 12:29, 29 September 2015

Pratik kamble at 11:35, 8 May 2015

Gaurav at 09:34, 9 July 2014

Minal: Created page with ''''ERRATA:''' 03:21 Next, let us add another label to the report footer as shown on the screen The above phrase was to be added to Report Footer. But in the Video, it has…'