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

From Script | Spoken-Tutorial
Jump to: navigation, search
Time 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- let's 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 pop-up 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 drop-down 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 coordinated 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