Using the Setting Tab in Report Collection

Settings Tab

Using the settings tab, you can configure the output settings of the report collection.

• Click the Settings tab to select Report Collection output settings.
• Select an Output Format (Excel, PDF, or Google Sheets). A Report Collection can have only one output format configured and the same format applies to all the reports added to the Report Collection. (Google for Work must be configured by your System Administrator in order to enable export for Google Sheets.)
• You can select the Suppress Empty Reports checkbox to exclude a blank report from the Report Collection output file.
• You can apply the recipient’s dimension security to the Report Collection output files using the Apply Bursting Dimension Security of Recipient checkbox. If this checkbox is selected for every user added to the distribution list, the corresponding reports are generated after applying specific dimension security. The selected dimension security is applicable to PDF, Excel, and Google Sheets output.
  Notes:

  • The existing Report Collections are run based on the sender’s dimension security.
  • The sender’s dimension security will be applied to the reports for the Non-Planful users and for the recipients who are in CC in the distribution list.
  • If a user group is added to the distribution list, the output is generated for every distinct dimension security combination of the individual users within the user group.
• Select the Generate Single Output File checkbox to generate a single workbook with an individual sheet for each report in Excel. For PDF, a single PDF file is generated, and each report consumes a single or multiple pages based on report size. If this option is not selected, the number of output files generated depends on the bursting criteria applied.
• The Custom File Name checkbox is available when the Generate Single Output File is selected. Select to enter a File Name for the output. When Custom File Nameis not selected and the output format is Excel, the following fields are available:
  • Report Collection - The code and name that you entered on the General Information tab. The label is a combination of the report code and name. Select which you would like to appear on the report output.
  • Report Bursting - Include the bursting name in the report output. The name was entered on the Reports tab.
  • Member– Select to include dimension member name, code, label, or no dimension information in the report output.
    Note:

    You can select the None option to exclude the report collection name in the Output File Name from the generated output. You must select at least one value from the Report Collection, Report Bursting or Member drop-down lists. You cannot select None in all the drop-down lists.
• You can Exclude or Include the date and time stamp in the Report Collection output file name from the Date and Time field.
• Further, customize Excel sheets by including sheet names. Select Report to include the report name, label, or code for each sheet. Select Member to include the dimension member name, label, or code in each sheet for page dimension members.
  Note:

  You can select the None option to exclude the report collection name in the sheet name from the generated output. You must select at least one value from the Report or Member drop-down lists. You cannot select None in all the drop-down lists.

• In the In Excel Export, Display Header & Footer as section, select Header & Footer Section to export header and footer section details. The setting is applicable for all reports added to the Report Collection but is not applicable for PDF output (only Excel output). For PDF output, the header and footer are exported as header and footer sections by default. Alternatively, select Rows to export the header and footer section details as normal rows. Logos, formatting, and alignment (left/center/right) remain intact and are adjusted to fit the rows in the sheet.
• In the Table of Contents section, select the following fields based on your requirements:
  • Table of Contents: Allows you to Show or Hide the table of contents from the Report Collection output.
  • Page Orientation: Allows you to select Portrait or Landscape orientation.
  • Sheet Number: Allows you to Show or Hide the sheet number from the output. You can show or hide the sheet number when you generate Excel or Google Sheet output and the page number in the PDF output.
  • Company Logo: Allows you to align the logo to the Top Left or Top Right based on your requirements.
  • Style: Allows you to customize the table of contents format. You can also add or remove the logo, report collection name, report collection title, Generated By, and Generated On information. After configuring the Table of Contents, you use the Preview option to know how the output may look before generating the actual Report Collection. If you don't like the output, you can use the Reset option to return to the default formatting.
    
    The table of content settings is retained when you generate PDF, Excel, and Google Sheets output files. The output files generated from the Process flow also display the table of contents.
    Note

    The Table of Contents Settings are retained when you Save, Save as, or Copy a Report Collection.