Difference between revisions of "LibreOffice-Suite-Base/C2/Modify-a-Report/English-timed"

|Welcome to the Spoken tutorial on LibreOffice Base.

|Modify a report by customizing the layout and the look and feel of the report.

|For this, let us consider our familiar Library database example.  

|In the previous tutorial, we learnt how to create a report  

|And we built a report with the title ‘Books Issued to Members: Report History’.  

 

We will now learn how to modify this report.

|In the Library database,  

|Let us click on the Reports icon on the left panel.  

|Let us right click on (it and then) click on Edit to open the report for modifying or editing.

|We now see a new window which is called the Report Builder window.

|This screen is composed of three main sections.  

|Page Header and Footer section that form the top and the bottom.  

|Then the Header section  

|and the Detail section.  

|We can also add a record header and a footer section  

|by right-clicking on the main screen in the white area and clicking on the ‘Insert Report Header/Footer’.  

|We can shrink or expand these sections, by double clicking on the orange areas on the left of the screen.

|Before we move on, here is a screenshot of the Report design window.  

|To do this, we will click on the Label field icon  

|In the Report Controls toolbar found below the menu bar at the top.

|Let us draw it on the Report Header area, as being shown now  

|and double click on the Label to bring up its properties on the right.  

|Here, let us type ‘Books Issued to Members:  

|Report History’ against the Label  

and press Enter.  

|Let us also change the font style; we will choose Arial Black, Bold and Size 12  

|and click on the Ok button.

|Next, let us add another label to the report footer as shown on the screen <pause>

|For example, lets type, ‘Report Prepared by Assistant Librarian’ <pause>

|and then change the font style to Arial, Bold Italic and Size 8. <pause>

|Now we will repeat the same steps again to add a label in the Page Footer area.  <pause>

|This time, we will type, ‘Nehru Library, New Delhi’ against the label.<pause>

|and change the font style to Arial, Bold Italic and Size 8. <pause>

|Now let us adjust the spacing.  

|First let us reduce the Page Header area by double clicking on the grey line between the Page Header and Report Header;

|Next let us reduce the Report header area  

|by double clicking on the grey line between the report header and the header. <pause>

|We will repeat the same steps to reduce the spacing between the Report footer and the Page footer also. <pause>

|We will do this, by first selecting all the labels by clicking on the Book Title,

|And then while pressing the Shift key; we will click on the rest of the labels as shown.  

|Now let us use the up arrow key to centre them.  

|We will now, give the header a light blue background.  

|To do this, we will go to the properties and change the Background transparent to No,

|And then select Blue 8 from the list for Background colour.  

|We will do the same with the Detail section as well. <pause>  

|For this we will first increase the spacing between the Detail and report footer sections <pause>

|and then centre the fields.<pause>

|We will select Light gray background for the Detail section as shown. <pause>

|Next, we will change the data formatting for the Checked In field.  

|Since this holds Boolean values 1 or 0, it displays True or False.  

|We will change this to show a friendlier Yes or No option.  

|For this, we will double click on the CheckedIn field on the right in the Detail section.  

|Now in the properties on the right, let us click on the Data tab first.  

|Let us click on the button next to the Data field that says CheckedIn.

|This opens a new popup window called the Function wizard.  

|Here, let us first empty the Formula text box at the bottom right;

|Then click on the Category dropdown, and then double click on ‘IF’.  

|Now on the right we see new controls.  

|Let us click on the Select icon on the right next to the first text box.  

|Here we will double click on CheckIn.

|Next we will type in Yes within double-quotes in the second text box  

 

|And then type in No in the third text box. <pause>

|Now we will go to the General tab within the Properties section  

|And click on the button against Formatting at the bottom.  

|Here we will click on ‘Text’ in the Category list  

|And then click on the OK button.  

|And, now, we will save the report.

|Okay, let us run our modified report now.  

|For this, we will click on the Edit menu at the top and then click on the Execute Report.

|And there is our nice report history on the Books issued to the Library members.  

|Notice the spacing, headers, footers, fonts  

|And the CheckedIn field which says Yes or No.  

 

|This brings us to the end of this tutorial on Modifying a Report in LibreOffice Base  

|Modify a report by customizing the layout and the look and feel of the report.

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

|This script has been contributed by Priya Suresh, DesiCrew Solutions.

 

And this is Soundharya, DesiCrew Solutions, signing off.  

 

 

Thanks for joining