Add Blank or Pre-Defined Cells

Definition

Blank cells are single, empty table cells that you can place anywhere on your report. They can be filled with any information such as extra titles or comments. Blank cells can contain text, objects from the Available Objects data palette or even functions. (For more information about functions, see the Formulas Guides.)

Pre-defined cells are single cells that have a function pre-programmed in to make inserting them quick and easy. These cells contain the most-used functions for single table cells, including last refresh dates and prompt or filter values. See below for a list of options.

Video

Step-by-Step Guide

Prerequisite: Have your report open and make sure it is in Design Mode. If necessary, refresh your report.

Empty Cell

1. Navigate to the menu "Report Elements", then the submenu "Cell"

Screenshot of InfoView menus showing location of buttons and sub-menus

2. To add a blank cell, click the "blank" button and click on your report

Note: Blank cells always have the bottom border in black by default. To change this, check out our Cell Formatting guide.

3. To fill the cell with text or a function, first double click on your header. (Click on the header rapidly until the text becomes highlighted). Then, type in your desired content (text or formulas), then hit "Enter".

To fill the cell with an object, select the object in the Available Objects data palette and drag it into the blank cell.

Alternately: The contents of your cell can be changed by using the Formula Bar. For more information, check out the Formula Bar Guide.

Pre-defined Cell

1. Navigate to the menu "Report Elements", then the submenu "Cell"

Screenshot of InfoView menus showing location of buttons and sub-menus

2. Click on "Pre-defined" and select from the list of options.

Screenshot of InfoView Pre-Defined cells drop-down menu options

The most used are:

  • "Document Name" shows the file name of the entire report
  • "Last Refresh Date" shows the last time the report was refreshed
  • "Drill Filter" shows the combined values of all of the drill filter selections
  • "Prompt" shows the combined values of all of the prompt inputs (individually or as a single summary field)
  • Several options for displaying page numbers

3. Click on your report where the cell should go.

Delete an Unwanted Cell

1. Right click on the cell (control + click on a mac) and select "Delete".

Screenshot of InfoView right-click to delete menu