Report Designer: Adding conditional expressions above title rows

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.

Characters left:

Although conditional expressions are not supported in title rows, you can customize title rows by adding conditional expressions in a row above the title row.

To open a report or financial statement layout for editing, choose File > Report Designer. In the Reports list frame, click the plus (+) sign next to the document type folder to expand the list, and then double-click a report or financial statement layout to open it in the design grid.

Prior to making changes to a financial statement we recommend that you save the original copy by choosing File > Save As to save the report with a different name. To restore a predefined report in which changes have been made, you can choose File > Restore Default.

The following example describes how to display different column headings based on the client’s current period.

Income Statement – Current Year – Prior Year

  1. In the design grid of the Report Designer, select row 1 by clicking on the row number, and then choose Insert > Row > Above.

  2. With row 1 highlighted, choose Insert > Conditional Expressions.

  3. Create a conditional expression that prints rows 1 through 4, if the variable [Client.AccountingProcessing.CurrentPeriodEndDate] is less than (<) the variable [Client.AccountingProcessing.CurrentFiscalYearEndDate].

    Show dialog

  4. Select rows 1 through 4 in the design grid, and choose Edit > Copy.
  5. Select row 5 and choose Edit > Paste.
  6. With row 5 highlighted, choose Insert > Conditional Expressions.
  7. Create a conditional expression that prints rows 5 through 8, if the variable [Client.AccountingProcessing.CurrentPeriodEndDate] is equal (=) to the variable [Client.AccountingProcessing.CurrentFiscalYearEndDate].

    Show dialog

  8. Select cell B6, remove the variable and enter One Year to change the contents of the cell to One Year Ended.
  9. Repeat for cell D6.

    Show design grid

  10. Save the report changes by choosing File > Save As.

See also: Reporting and Report Designer: Procedures

Share This