How to Create Report Collections in Dynamic Planning
- 3 Minutes to read
- Print
- DarkLight
- PDF
How to Create Report Collections in Dynamic Planning
- 3 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Overview of Report Collections in Dynamic Planning
- Advanced Distribution: Generate and distribute multiple reports in Excel format via cloud-based Report Collections, with email attachment and scheduling options.
- Flexible Customization: Customize report names, tabs, and output settings to create tailored workbooks or individual files for recipients.
- Scheduler Integration: Schedule report distribution with advanced recurrence settings, time zones, and recipient customization for efficient report delivery.
- Enhanced Navigation: Quickly toggle schedulers on or off for single or multiple reports directly from the Dynamic Planning Report Collections page.
To create report collections in Dynamic Planning, follow these steps:
- In Spotlight Web, click Reports, then click the Add icon and select Report Collection.
- In the Report Collection window, enter the Code and Name in the General Information tab, then select Dynamic Planning from the Reporting Area drop-down to automatically select the Dynamic Planning Report Collection in the Select Folder field.
- On the Reports tab, click the Select Reports link to add reports to your Report Collection.
- Select reports from either Spotlight Reports or Excel Reports in the Select - Dynamic Report window.
- Click Add to display the reports in the Selected Reports pane. In the Action column, you can rearrange or remove any unwanted reports.
- You can add, duplicate, or delete a tab in the Report Collection using the Tab drop-down menu. Navigate to Settings to adjust the Report Collection output settings.
- Select the Generate Single Output File checkbox to generate a single workbook with an individual sheet for each report in Excel.Note:If the Generated Single Output File checkbox is not selected, an output file will be generated for each report.
- Select the Custom File Name checkbox to enter a name for the report.Note:The default report name will be updated if this option is not selected.
- Select Name from the Tab drop-down list.
- Select Name from the Report Name drop-down list and select Include to display the Date and Time in the exported report collection.Note:Optionally, you can also select Exclude to not display the Date and Time in the exported report collection.
- Now, click Distribution and select the Send email notification to user(s) checkbox to send an email to selected users or user groups, and click the Compose Email link to create the email draft.Note:You can perform the following actions for customizing the email:
- Customize the subject and body of the email.
- Add e-mail addresses of Planful and non-Planful users in the CC.
- Select Include reports as an attachment to attach the Report Collection output to the email. Then, select Add / Remove User – User group to designate Planful Users, User Groups, and non-Planful Users for sending or sharing the output.
- Click Scheduler and select the Start Date from the calendar icon and select Start Time from the Time drop-down list.
- Select the Time Zone and optionally check the Repeat box to repeat the schedule. Select a Repeats option, specify the Recurrence Ends, and enter the email addresses in the Email Recipients box to schedule report distribution.
- Click Save.Notes:
- Save: Select this option to save the Report Collection.
- Save As: Select Save As to create a new report collection with a different name. The General Information, Reports, Settings, and Distribution tabs will be copied, but the Scheduler will be empty for setup. The report collection will not run during this process.
- Run: Select this option to run the report.
How to Toggle the Scheduler for Reports in Dynamic Planning Report Collections?
On the Dynamic Planning Report Collections landing page, you can turn the Scheduler On or Off. Simultaneously, you can also enable or disable the Scheduler for multiple reports.
Notes:
- If you turn on a Scheduler report after its due date, the report will not be sent at all.
- Reports will be sent for the number of times specified, regardless of the number of days calculated.
- Navigate to Reports and select Dynamic Planning Report Collections.
- Select a single report collection and select On/Off from the Scheduler drop-down list.
- Optionally, you can select multiple reports and click the Scheduler ON or OFF icon in the menu bar.
Was this article helpful?