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

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.

In this tutorial, we will learn how to

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

Modify a report

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.

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

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.

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

Point cursor over orange areas.

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 Image ReportDesignScript12.JPG

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.

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.

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.

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.

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

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

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.

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>

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.

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>

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.

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.

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.

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>

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.

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.

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.

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.

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

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.

Summary

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

To summarize, we learned how to:

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