LibreOffice-Suite-Base/C2/Modify-a-Report/English-timed
From Script | Spoken-Tutorial
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. |