Free-standing cells are single cells that stand alone in a report. You can use free-standing cells to display information that adds meaning to your report.
Insert a Free-Standing Cell
There are several types of free-standing cells available in the Insert section of the toolbar.
Icons
Web Intelligence embeds the SAP Fiori font. This font contains more than 600 icons that you can use in your documents.
In Design mode, in the toolbar’s Insert section, select the Insert cell → Icon command. In the displayed Insert an Icon dialog box, you can select an icon among the ones proposed.
Once you have selected an icon, click Insert and click in the report to add a new cell containing this icon at the location of your choice. This cell’s font is SAP-Icon and contains the formula: =Char(IconCode).
This means you can manually add an icon in a cell by using this formula with the icon code and by setting the SAP-Icon font in the Format → Text Settings tab.
As these icons are provided in a font, you can change their size, color, and apply the Bold, Italic, Underline and Strike through properties.
These icons can also be used in cells defined as hyperlinks or in formatting rules to display visual indicators depending on values.
To see these icons when exporting a Web Intelligence document to Excel, you need to install the version 4.13 of the SAP-Icon font in your client machine.
Watch this video to learn how to add an icon in a report:
Cell Format
You can format your report and report elements in order to present the report with a company style.
Select a free-standing cell and the Format tab to view formatting settings.
The table lists the Display settings:
In Design mode, right-click a column of a vertical table or a row of a horizontal table to open the context menu. The possible options under the Hide menu are:
- Hide Column/Row: to always hide the column or the row. This option is static and can only be changed by the report designer.
- Hide Column/Row When Empty: to hide the column/row if the corresponding object contains no data.
- Hide Column/Row When…: to hide the column/row depending on a formula. If you select this option, the Build Side Panel → Format tab → Display sub-tab opens. Enter the formula in the Hide when formula is true text field.
The table lists the Appearance settings:
You can add a gradient color effect in your report or any report element (header, footer, chart, cell…) background.
In the Build Side Panel → Format tab → Appearance sub-tab, select the Linear Gradient option in the Background, Pattern section, and use the drop-down menus to choose:
- Two colors, including their transparency.
- The gradient direction: Horizontal, Vertical, Diagonal, …
For the moment, this property is not yet available in Formatting Rules.
The table lists the Text settings:
You may justify a text in a cell. In Design mode, select a cell, a column, or a row. In the Build Side Panel → Format tab → Text sub-tab, click the Justify button to apply this alignment to the selected item.
The table lists the Layout settings:
