Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
title3. How to build and produce bulk students report via the report builder
  1. Click on Report Builder under Reports from side menu

  2. Select Student Course Enrolment Details as the base report

  3. Click on the Load Base Report button

  4. Scroll down to the Report Columns section

  5. Select the required fields for the report using the Control button and clicking the required options. Ensure that Course Enrolment Id is included or bulk report will not function correctly.

  6. Click the Add / Remove Columns button. To update the fields selected either select or deselect the required field and click the Add/ Remove Columns button.

  7. Update the Report Column Names and Columns Order numbers as required.

  8. Click the update Columns button to make any alterations.

  9. Scroll down to the Filter Clause section

  10. To filter the returned data clauses can be added either singly or joined together to produce only the required data. E.g. Start date > 01/01/2020 will produce a list of students whose start date is greater than 01/01/2020. But with an additional condition of: Start date > 01/01/2020 AND Funding Type is Fee -Help the data will include students who have both criteria. (For more information on this please see the Report builder KB)

  11. Scroll down to the Format Report section.

  12. Select the Bulk Student select option.

  13. Click the Produce Report button.

  14. A List of Student who meet the selected criteria will appear.

  15. Click the tick boxes next to the required students, alternatively click the tick all option.

  16. Scroll to the bottom of the page.

  17. Click the Add selected to list button

  18. A list of students has now been created.

  19. To remove any students prior to a bulk action click the un-link button

...