Create a Layout Calculation

Create a layout calculation to add run-time information to your report, such as current date, current time, and user name.

When creating layout calculations, only report functions are available to you in the expression editor. These functions are executed in the report layout, as opposed to the other functions which are executed in the query.

Procedure

  1. From the Toolbox tab toolbox tab, 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, on the source tab source tab, double-click data items.
    • To add data items from a specific query, on the queries tab queries tab, double-click data items.
    • To add functions, summaries, and operators, on the functions tab functions tab, double-click elements.
    • To add a value that is derived from a parameter, on the parameters tab parameters tab, double-click a parameter.

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

    Tip: You can also type the expression directly in the Expression Definition box.

    For more information about creating expressions, see Using the expression editor.

  3. Click the validate button validate icon.