Optional Content Commands

Please Note: Optional Content commands can only be used in report templates.

Optional Content commands conditionally copy content from the template to the report during the new report process. When you create a report from a template that contains an Optional Content command, the software checks the workbook cell that the command is linked to. If the cell evaluates to True, then the command's content is copied into the new report. You change the settings for an Optional Content command from the Edit Command Panel in the Report Navigator.

tog_minusOptional Content Cell Controls

Optional Content Command - Cell Controls

The Optional Content Cell text displays the location of the linked cell. The number in brackets is the file ID. The rest of the text string is the cell's address. The address can use Excel's [sheet name]![column & row] notation, or it can be a range name. To view the linked cell, click on the Go to Cell Button. To change the linked cell:

Step01Select the Cell

Please Note: Remember that the cell you select must evaluate to True or False.

Select the workbook cell that will determine if the report content is included or excluded.

wTo link to the report's Analysis file, use Analysis Mode to select the cell.

wTo link to a standard Excel workbook file, use Workbooks Mode to select the cell.

Step02Copy the Cell

Click on the Copy Link Button in the Desktop Toolbar. You can also select Edit | Copy Link.

Step03Paste the Cell

Go to to Report Mode and click on the Paste Cell Button in the top right corner of the Edit Command Panel.

Step04Update the Command

Click on the Apply button in the lower right corner of the Edit Command Panel. The new cell will be applied to the command.
tog_minusDescription Control

Optional Content Command - Description Control

Enter a brief description that explains the purpose of the Optional Content command and the content that it contains.