In the Layout slide-out panel, you can configure the default layout settings for the report output. The settings you configure here are defaults, and users can adjust them as required when they run reports.
Click the Layout button to show the default layout settings, and configure the following options:
Output Options
- Report Header Display Name: Enter an alternate title to show in the report header instead of the report name.
- Include filter criteria: Select the checkbox and the filter values that you specify when you run the report are shown in the report header.
- Only include unique records: Select the checkbox and Dayforce returns only unique records in the report output. By default, reports show all database records according to the report filters and parameters, even if all fields contain identical data in more than one record.
- Note: This option can't be used together with totals because all records (not just unique ones) must be included to generate an accurate total. Dayforce clears this option if you have it enabled and then add totals on the report. Consider an example with a SUM function where there are three records that all have the value of 40. With Only include unique records selected, only one of these records would be included in the sum and the total would be 40. With the checkbox cleared, the total is correct at 120.
- Max Number of Records: Enter a value for the maximum number of rows in the report. Reports are limited to 5,000 rows by default, and the maximum possible is 900,000.
- Report Type: This drop-down list is displayed only for V2 reports, and it's enabled only for reports that have pivot tables configured. Select Base report, and the base report is generated by default. Select Pivot table, and the pivot table is generated by default.
- Output Format: Select the file format that you require for the report output.
Page & Format Options
The following Excel format options are enabled if you select Excel as the output format:
- Suppress formatting in Excel output): Select this checkbox and Dayforce removes all formatting from the report output, including headers, grouping information, and totals.
- Suppress formatting - Include Totals in Output: Select this checkbox and Dayforce removes all formatting in the output, but it still displays totals.
The following PDF format options are enabled if you select PDF as the output format:
- Orientation: Specify whether the PDF output uses landscape or portrait orientation. Dayforce fits PDF report output to one horizontal page, so landscape can be the better option for reports with a large number of columns.
- Paper Size: Select a paper size from the drop-down list.
- Repeat column headers on each page: Select this checkbox and Dayforce includes the column headers at the top of each page of the PDF output. By default, this checkbox is cleared, and the headers appear just once at the top of the report.
- Insert page break between first-level groups: Select this checkbox and Dayforce inserts a page break between each group at the first grouping level. For example, if your report records are grouped by department and then by manager, each department begins on a new page in the report output. A page break isn’t inserted between the manager groupings.
- Include signature line: Select this checkbox to include a signature line at the end of the PDF. Signature lines do not show in reports with no data.
- Support for double-sided printing: Select this checkbox and Dayforce inserts a blank page if a new group after a page break starts on an even-numbered page. This setting ensures that a new first-level group doesn't start on the back page if you’re printing double sided. This checkbox is enabled only if Insert page break between first-level groups is selected.