Displaying Data in Free-Standing Cells

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.

There are several types of free-standing cells available in the Insert section of the toolbar.

You can add the following information to your reports:

• Blank Cell: Empty cell in which you can enter any text or formula.
• Comment: A cell in which you can type a general comment.
• Document Name: Displays the name of the document.
• Last Refresh Date: You can display the date when the document results were refreshed with the most recent data from the data source.
• Drill Filters:You can display the names of the objects by which the data in a drilled report is filtered.
• Query Summary: Displays the details of the queries in the document.
• Prompt Summary: Displays the details of the user prompt selections.
• Page Number: You can display the page number of each report page.

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.

You can format several objects at the same time.

Resizing, aligning, defining borders, background colors, or relative positions are examples of what's possible when formatting multiple report elements simultaneously. The formatting options available depend on the report elements you select.

Options available within these tabs depend on the type of selection you make and the settings the report elements you select have in common. Also, some of these settings may appear as undetermined when the report elements have different values for the same setting. These settings are reset to make sure that the new value you enter applies to all the report elements you select.

There are three possible selections:

• Selection of report elements of the same type, such as two vertical tables.
• Selection of report elements of different types, such as a vertical table and a horizontal table.
• Selection of report elements of heterogeneous type, such as a pie chart and a free cell.