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

How to Create a Mail Merge Report for Assessment

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. This is explained in the video.

Start from Mail Merge from the Create New Report menu.

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 January 13, 2021

Was this article helpful?

Related Articles

Noticed a Missing Guide?
Can't find the guide you need?
Email Us

Leave a Comment