Define Cells to Contain Comments and Files

In Data Entry - Reported Values you can enter comments in a value cell, if the account has been defined to contain a comment in the Define Account Structure window. Alternatively you can use a separate cell in the form for entering comments on an account (in Standard and Free forms):

Procedure

  1. Select the specific cell where the user should enter a comment.
  2. Click the Insert Formula button. A shortcut menu appears.
  3. Select the fPutComment command.
  4. Edit the cell content and make sure the cell references within the formula point to the cells determining the account and actuality to store the comment on. The comment cell will be blank when no comment has been entered in the Data Entry - Reported Values window. You can add a comment heading in the cell preceding the comment cell.

Results

For Standard, Free and Intercompany forms, you can use the Enter a Comment button to insert comments, files, links to files and hyperlinks for accounts defined to contain comments.
  • You cannot enter comments on summation accounts.
  • The other sheets in the workbook can be used to type texts, but the IBM® Cognos Controller formulas will not be saved.
  • Macros and pivot tables are not supported.