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

From Script | Spoken-Tutorial
Revision as of 16:45, 27 December 2012 by Minal (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.


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


Contributors and Content Editors

Gaurav, Minal, Pratik kamble, Sandhya.np14