Displaying Data in Free-Standing Cells

You can use blank cells to add text, numbers, or formulas outside tables and charts. You can move blank cells and change their content, format, or style. This helps you match your report and highlight key information.

You can use icons to add visual elements to your reports.

In the Insertion section of the toolbar, select Insert Elements. Then, choose Cells from the drop-down list and select Icon.

Once you have selected an icon, select Insert, then click on the report to place a cell.

The cell uses the SAP-Icon font and contains the formula =Char(IconCode), where IconCode is the code for the icon you want to use.

Icons are a type of font, so you can resize or change their color. You can also apply bold, italic, underline, or strikethrough. You can use icons in hyperlink cells or in formatting rules to show visual indicators.

You can also add icons manually. Use the formula =Char(IconCode) and set the SAP-Icon font in the Build panel→Report Element Format tab→Text sub-tab.

Predefined cells streamline report creation by offering ready-made options for displaying common information types. These cells automatically display specific, often-used data such as the document name or last refresh date without needing manual setup or complex formulas.

Using predefined cells standardizes reports, ensuring consistency and saving time during report development.

Web Intelligence provides predefined cells such as:

• Document Name: A cell that shows the name of the current document. You can place this cell anywhere in the document.
• Last Refresh Date: A cell that shows the date when the document was last refreshed. You can place this cell anywhere in the document.
• Query Summary: A cell that lists details for the queries used in the document. You can place this cell anywhere in the document.
• Page Number / Total Pages: A cell that shows the current page number and the total number of pages in the report. You can place this cell anywhere in the document.

You can use the rich text cell to apply different formats to text within the same cell.

In the Insertion section of the toolbar, select Insert Elements Supported When Exporting to WIDX. Then, select Cells from the drop-down list and select Rich Text.

You can edit the cell text in the Build panel→Report Element Format tab→Specific sub-tab.

You can use the Visual or HTML button to display the formatted text or its HTML version.

You can also add objects to the report element in the Build panel→Report Element Data tab→Feeding sub-tab. Use the last icon in the toolbar to select one of these added objects. The object values are evaluated in the element context and shown in the cell.

In the Layout section, you can set these properties for the text:

• Wrap Text: Makes the text appear on multiple lines to fit the cell width. If this is not set, a horizontal scroll bar appears so you can view text that does not fit the cell.
• Horizontal Padding: Sets the space before the text.
• Vertical Padding: Sets the space above the text.

In the Multiple Value Management section, you choose how to display object values:

• Distinct Dimension Values: Display all values, or only distinct values.
• Separator: Define the string to separate the values.
• Display Separator as HTML: Interpret the separator as HTML or not.

You can add a PNG, JPEG, or SVG image to your document using the image cell.

In the Insertion section of the toolbar, select Insert Elements Supported When Exporting to WIDX. Then, select Cells from the drop-down list and select Image.

After you insert the image element in the document, click the Upload link to select an image from your file system. You can also drag and drop an image into the element to display it in the cell.

You can change the image display mode in the Build panel→Report Element Format tab→Specific Settings sub-tab.

• Use free-standing cells to add and format text, numbers, formulas, or icons outside tables and charts.
• Insert predefined cells to quickly display common report information, such as document name, page numbers, or filters.
• Apply rich text formatting within a single cell and manage how multiple values are displayed.
• Add images to reports using image cells, with options to upload and adjust display settings.