Versions Compared

Old Version 5

changes.mady.by.user Chanel Zhang

Saved on

compared with

New Version 6

changes.mady.by.user Chanel Zhang

Saved on

Key

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

...

The Report builder is a tool to aid in accessing the information stored within the system and extract it in meaningful and useful reports. Each report is custom designed to meet your institutions data requirements and needs. Reports can be produced in various output formats to meet the institutions requirements. The report builder uses SQL (Structured Query language) however you don’t need to be able to write in SQL to create report. The Report builder has a user friendly interface to help you create your own reports.

...

Expand
title4. How to add filter clauses to a report

  1. Click on the Reports option in the side menu

  2. Click on the Report Builder option in the side menu

  3. Click on the Global reports or Private reports drop box

  4. Select the report to be loaded

  5. Click on the Load Report button

  6. The report has now been loaded

  7. Scroll down to the Filter Clause section

  8. Click on the Column Name drop box

  9. Select the Column name to be filtered

  10. Select the required Operator

Expand
title4. How to add operators to a reportThe rule of Order by Clauses

The order by function works as intended if you export the report in a csv format.

When you produce report in a HTML or create a bulk list, the screen displays the order by to the first column by default.

Workaround suggestions if you want to see order by in a HTML version.

  1. You can either manually ascending/descending the columns by click on the first-row header once you get to the screen of bulk student select

  2. Change the order number of the column you want to see the order by function to 1

Expand
title5. How to add Conditions to a report

...