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

From Script | Spoken-Tutorial
Jump to: navigation, search
Visual Cue Narration
Show Slide Number 1

Spoken tutorial on LibreOffice Base: Modify a Report

Learning Objectives

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

Welcome to the Spoken tutorial on LibreOffice Base.

In this tutorial, we will learn how to

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

Show Slide Number 2

Modify a report

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

In the previous tutorial, we leant 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 Base main window,

Click on Reports on the left panel, and click on 'Create Query in Design view'

In the Library database,

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

On the right panel, we see the ‘Books Issued to Members: Report History’ report in the reports list.

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

Point cursor over the report builder screen areas as narration goes forward.

Right-click on the main screen in the white area and click on the ‘Insert Report Header/Footer’

Point cursor over orange areas.

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 then 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 to the left of the screen.

Show Slide number 3

Show Image ReportDesignScript12.JPG

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

We will modify our report design to look like this.

We will add some text labels, fonts, formatting and adjust the spacing among the various sections.

Point over the label icon from the report control toolbar, show tooltip and then click on the Label field icon,

Click drag and drop it in the Report Header area and then align it to the left, as shown in reference image ReportDesignScript12.JPG.

Double click on the label, and on the right in the properties section,

Type ‘Books Issued to Members: Report History’ against label,

And press enter.

In the properties, click on button right of font, choose Arial Black, Bold and Size 12.

Click on the Ok button.

Okay, now let us add some report headers and footers.

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

This is in the Report Controls toolbar found below the menu bar at the top.

And add the label 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.

Point for 2 or 3 seconds for the tooltip to appear and then click on the Label field icon, click drag and drop it in the Report Footer area and then align it to the left, as shown in reference image ReportDesignScript12.JPG.

Double click on the label, and on the right in the properties section, type ‘Report Prepared by Assistant Librarian’ against label and press enter.

In the properties, click on button right of font, choose Arial, Bold Italic and Size 8. Click on the Ok button.

Next, let us add another label to the report header 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>

Point for 2 or 3 seconds for the tooltip to appear and then click on the Label field icon, click drag and drop it in the Report Footer area and then align it to the left, as shown in reference image ReportDesignScript12.JPG.

Double click on the label, and on the right in the properties section, type ‘Nehru Library, New Delhi’ against label, and press enter.

In the properties, click on button right of font, choose Arial, Bold Italic and Size 8. Click on the Ok button.

Now we will repeat the same steps again to add a label in the Report 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>

Double click on the grey line between the Page Header and Header section;

Take it all the way to the top by using the click, drag and drop.

Double click on the grey line between the report header and header section; and reduce height by using the click, drag and drop.

Double click on the grey line between Report footer and Page footer section; and reduce height by using the click, drag and drop.

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;

And we will take it all the way to the top by using the click, drag and drop method.

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>

Centre the Header labels.

For this, select all the labels by clicking on the Book Title,

While pressing the Shift key; on the rest of the labels.

Use the up arrow key to centre them.

Go to properties window, Change Background transparent to No;

then select Blue 8 from the list for Background colour.

Next, let us centre the Header labels.

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.

Increase space between Detail and Report footer by clicking on the grey line in between.

Use the arrow keys to move up or down to centre the fields in the detail section.

Go to properties window, Change Background transparent to No; then select Light gray 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>

Show cursor movement as narration goes forward

Double click on the CheckedIn field on the right in the Detail section.

In the properties, Click on the Data tab

Click on the button next to the Data field.

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.

Delete all the text in the Formula text box in the bottom right;

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

Click on the Select icon on the right next to the first text box.

Here double click on CheckIn.

Next type in Yes within double-quotes in the second text box and then type in No within double quotes in the third text box. Double Quotes is important.

Click on general tab. Click on the button against the Formatting at the bottom.


Click on ‘Text’ in the Category list Click on the OK button

Click on Save icon on top.

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.

Click on Edit menu at the top and click on Execute Query.

Show cursor movement over the appropriate areas on the report as narration goes forward.

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.

And we are done with modifying our report.

Show Slide Number 5

Summary

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

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

To summarize, we learned how to:

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

Acknowledgement Slide 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 http://spoken-tutorial.org/NMEICT-Intro. This script has been contributed by Priya Suresh, DesiCrew Solutions Pvt Ltd, signing off. Thanks for joining.

Contributors and Content Editors

Chandrika, Pravin1389