Report Designer: Period dialog

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:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Accounting CS phone support is available on that date from 9 AM - 5 PM ET due to the approaching deadline for quarterly payroll tax forms.

Links to our most popular payroll tax processing topics are available in the Alerts and notices section on the right side of most pages.

A period indicator is a symbol or code that tells the application the time period to pull amounts from for a specific column, row, cell, or group of cells. A period indicator can specify a single period, year-to-date, cumulative, beginning balance, or total amount for the current or preceding years.

In Column mode, Row mode, or Cell mode make your selection from the drop-down list in the Period field in the Properties frame. For a complete list of period indicators, you can click the Select Period Periods button button to open the Period dialog.

eg24 Example of creating a date formula

Follow these steps to create a simple formula that would display the beginning balance amount for the current period in the report.

  1. Select the column, row, or cell in the design grid for the selected report, and then click the Select Period Periods button button in the Properties section of the Design Tools grid.
  2. In the Period dialog, leave default value in the Year field as C - Current year, select CY - Current year-to-date in the Period grid, click the minus (-) operator button, and then select CP - Current period.
  3. Click OK to insert the formula into the selected column, row, or cell of the report.

eg24 Period indicator examples

The following is a list of some of the period indicators that are available in the Report Designer. (For a complete list of period indicators, you can click the Select Period Periods button button to open the Period dialog.)

Notes

  • You can format all of the cells in a column or row by clicking the column or row header buttons in the design grid.

    Procedure example: If column B should display the current period information, you can highlight the entire column and enter the correct period indicator, CP, in the Period field. This will automatically enter CP for all cells in that column. Then highlight and change the individual cells that require different indicators. This is much faster than inserting the period indicator in each cell for a column.

  • While many period indicators exist in the drop-down list for the Period field, you can specify other periods by clicking the Select Period Periods button button. A complete list of period indicators is displayed for current year. The Year field can be used to change the list of period indicators for up to 9 prior years.

Related topics

Report Designer, overview

Reporting and Report Designer: Procedures

Working with variables

Inserting variable formulas

Share This