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

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