1. Home
  2. Reporting
  3. How to Create a Mail Merge Report for Assessment

How to Create a Mail Merge Report for Assessment

Important: The below guide refers to an older version of our Reports module, which not all schools will have access to. The pathways discussed in this guide therefore may not be relevant if you only have access to Quick Reports. This will typically apply to schools that are relatively new to Bromcom as well as Northern Ireland schools and they therefore should refer to Quick Reports guidance instead.

Note: All pages below are subject to having relevant Roles and Permissions.

A Mail Merge or Web Merge takes a file and creates letters to selected people, for example, an individual letter to parents. In this example we will create an Assessment report.

Note: Running a Web Merge report requires the user to create a Word Document in .dox format with Data Fields for mapping against system-selected Data Items.

Start from Mail Merge from the Create New Report menu.

For any new schools being onboarded after Monday 30th January 2023 the Create New Report Menu will only show Quick Report.

Pathway

Select the Results option from the Assessment Domain, is will open the Report Design page.

Find and drag and drop the data items from the Data Items tab into the Detail box.

For the example here, assessment mailmerge, we pick the following:

Students – First nameLast nameStudent tutor groupStudent IDAM/PM present percentageTutors

Assessment Type – Assessment Type Name

Term – Term name

Year Group – Year Group Name

Subject – Subject Name

Result

Note: The Student ID must be selected as this is the identifier.

Click on the Report Filters and Intervals tab.

From the Report Intervals area select Show for Selected Dates for Students AM/PM Attendance Percentage. The page will refresh,  now tick the Runtime box.

Now from the Report Filters area, select the following Filters:

Students

Assessment Type Name

Term Name

Year Group Name

Subject Name.

Example below on how the Assessment Type Name is added. Simply drag and drop the field into the Drag Items here area.

Now set the Filter by ticking the Ask at runtime box and clicking Apply, each time you add the filter.

Set the Ask at Runtime for all Filters listed below.

Click on the Report Properties tab.

Give the report a Title and a Description, select the Folder in which the report will reside, give Access Permissions to others to View and Run this report, then click OK.

When you’re finished click Save.

Updated on June 10, 2024

Was this article helpful?

Related Articles

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