1. Home
  2. Reporting
  3. How to Schedule a Report via Email
  1. Home
  2. For Teachers
  3. How to Schedule a Report via Email

How to Schedule a Report via Email

In this guide, which includes a video demonstration, you will be shown how to Schedule a Built In Report to be sent to Staff/Departments etc via email, as well as how to manage Scheduled Reports.

Access: The ability to Schedule a Report comes from having general access to running Reports, which are found in the Reports Module of Config>Setup>Roles & Permissions.

Schedule a Report

You can Schedule any Report within the MIS. In the example below, the Student Attendance Report has been selected from Reports>Attendance.

You can also schedule an Adhoc Report by going to Reports>Adhoc>View Reports and pressing Run once you have highlighted a Report. On the next screen, you can press Schedule.

After you have selected a Report, set the Parameters to look at the data you need such as the date, students and any relevant tick boxes.

Schedule

Once you have set your Parameters, instead of previewing the Report press Schedule.

Pressing Schedule will take you to the next screen where you will have 3 Export options;

  • Export to file – This will Export the Report to your PC when the Schedule runs
  • Email – This will send the Report via Email when the Schedule runs
  • My Reports – This will store the Report in your ‘My Reports’ area

For this process, select the Email option.

DMS Options

The Format dropdown is for you to select which type of File you wish to send the Report as, while the DMS options control other functions:

Single Document – If multiple Students are selected, ticking this keeps all of the data together in one file. Note: Please ensure to UNTICK this if Publishing to MCAS or Student Portal otherwise the collective data in the Report will be published to each account.

Multiple Documents – If multiple Students are selected, ticking this will split the data in to multiple Reports based on each Students unique ID. Note: These Reports will show in the DMS with a Focus against the Student.

Save DMS Copy – This will be greyed out but required for this process as the Reports will store in the DMS so you can ignore this. DMS means Document Management Server , these documents are saved in the My Account area ( click on your photo on the top right of Bromcom and click My Documents)

Publish to MCAS – If ticked, this will publish the Report to Parents MCAS Accounts when you finish the next step.

Publish to Student Portal – if ticked, this will publish the Report to Student’s Student Portal accounts when you finish the next step.

Save Local Copy – This will store a copy of the Report on your PC locally out of Bromcom. Note: This will be greyed out as we are not generating the Report in this process so there is nothing to save.

Underneath the DMS Options, you will have some additional boxes (To, Cc, Bcc, Subject & Message which you can type in to. Note: Subject & Message are optional but To is required.

To, Cc, Bcc, Subject and Message

You will also see there are Add/Edit/Delete buttons.

Pressing Add will allow you to choose from some system generated recipient options such as Head of House, Deputy Head of Department or Head of Year.

Using Edit/Delete you can amend/remove those that you previously added.

Built in Recipient options

Once you are happy with this section and have set your recipients, press Next.

You should now have a new page with some Schedule options as seen below;

Default options

The Schedule dropdown at the top of the page is for setting how frequently you want this Scheduled Report to run, Daily or Weekly would be the most common/practical.

Schedule Options

Selecting Daily or Weekly will leave you with a Start Time box and Include in Schedule from/until selectors.

You would set these as the desired time/date you want this process to begin and provide an end date or leave it open so that it runs continuously.

Note: When selecting the Time, please make sure that it is not set to run at the same Time as any of your other Scheduled Reports as this can prevent the Report from running as intended. We recommend ensuring that there is at least a few minutes in between each Scheduled Report.

Page view when set to Weekly

Lastly, at the bottom of the page you have Start Date and End Date fields with Fixed set by default in the dropdown.

If these are set to Fixed, the Report will look at the data purely based on the Parameters that you set in the earlier steps.

You have the ability to change this by selecting Relative to the Academic Day/Week.

Start/End Date options

Relative to the Academic Day or Week offer the most flexibility. When you select either of these you now then see a Number Selector appear to the right/ Please see below;

Number Selectors

These selectors work in the following way;

Relative to the Academic Day 0, would be today’s data.

Relative to the Academic Day -2, would be data from 2 days ago.

Relative to the Academic Week -4 would be data from 4 weeks ago.

Note: These can be affected by your earlier Schedule choice and the include in Schedule from/until dates so make sure the dates you want are covered/included.

An example would be if I want the Report to send out every Friday at 3pm, this is how I would configure the Report;

Once you have chosen your settings, press Done and this will confirm your selections which will now set the Schedule based on the settings you selected prior.

Manage Scheduled Reports

To delete a scheduled report go to My Account>Scheduled Reports

My Account – Scheduled Reports

Note: Scheduled Reports by default will load any Reports that you have personally Scheduled, you can tick Show All Users Scheduled Reports to find Reports from other users if required.

Once you can see the Report, select it and click Delete.

Delete a Scheduled Report

To amend the Scheduled Report, you would take the same path but press Schedule Settings instead of Delete once you have selected the Report.

Amend a Scheduled Report

This will essentially take you through the editing process of the Schedule, where you determine the recipients etc.

Unless you want to amend anything here, you can just press Next.

Schedule Settings – Part 1

You will then be taken to the actual Schedule of the Report which you can amend as desired.

Once you are happy, press Done and this will update the Schedule Settings for the Report.

Schedule Settings – Part 2

Updated on September 27, 2024

Was this article helpful?

Related Articles

Noticed a missing guide?
Fill the form below and we will get this created.
Suggest Help Article