Format a report
- Formatting in Business Objects is very similar to formatting in Excel.
- As with most standard Windows applications, the Formatting toolbar allows you to change the font, size, colour and justification of selected text.
- You can adjust row height or column width.
- You can change the format of the numbers, the alignment of the text within cells, and apply borders and shading.
Videos
Watch the following videos to explore the different formatting options in Business Objects:
Cloze Activity
Read the paragraph below and fill in the missing words.
on the right hand edge of a column to resize the column automatically.
Multi-choiceNumber tab
|
This changes the format of the number, for example, to currency.
| |
|
This changes the type of numbering system, for example, to Roman numerals.
| |
|
This changes the calculation that is done on the numbers, for example, to count or sum.
|
Alignment tab
|
Allows you to change the margins of the report.
| |
|
Allows you to align data in relation to cell borders.
| |
|
Allows you to adjust all columns to the same width.
|
Font tab
|
Allows you to write HTML in the report.
| |
|
Allows you to specify whether the font is right aligned or centred.
| |
|
Allows you to specify the font, font size and font formats.
|
Border tab
|
Allows you to place borders around selected cells.
| |
|
Allows you to align data in relation to cell borders.
| |
|
Allows you to apply a light grid to cells.
|
Shading tab
|
Allows you to change the colour of cell borders.
| |
|
Allows you to fill in the space between the end of the text in a cell and the cell border.
| |
|
Allows you to fill in cells with different colour shadings.
|
To paste formatting only from a cell:
|
Use the 'Fill' option on the Alignment tab.
| |
|
Use the Paste button on the Standard toolbar. | |
|
Use the Paste Format Only button on the Standard toolbar.
|
Activity
Practice formatting the cells in one of your own reports.
Use the menu on the left to navigate your way to the next page.