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. |
