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