Adding runtime information

Create a layout calculation to add runtime information to your report, such as current date, current time, and username.

When you create layout calculations, supported functions appear in the Functions tab of the expression editor. Report expressions and calculations that are based on layout expressions are performed in IBM® Cognos® Analytics - Reporting.

To see the complete list of functions available in the expression editor, except for report functions, create a query calculation. All functions are available when you create a query calculation because these calculations are performed in the database and not in Cognos Analytics - Reporting.

Procedure

  1. Click the Toolbox icon The toolbox icon and drag Layout calculation to the report.
  2. In the Available Components box, define the calculation:
    • To add data items that are not shown in the report, click the Source tab Source tab, then double-click the data items.
    • To add data items from a specific query, click the Queries tab Queries tab, then double-click the data items.
    • To add functions, summaries, and operators, click the Functions tab Functions tab, then double-click the elements.
    • To add a value that is derived from a parameter, click the Parameters tab Parameters tab, then double-click a parameter.

      Parameters define prompts, drill-through reports, and master detail relationships.

    Tips:
    • You can also type the calculation directly in the Expression Definition box.
    • When typing date values, ensure that the date format is correct for your database type.
    • To copy and paste expression components in the Expression Definition pane, you can use the Copy button Copy icon and the Paste button Paste icon.
  3. Click the Validate button validate icon.