Example 1 - Running a report on all application within a programme by Qualification Status

The example below describes the steps taken to create a basic report to return data on all applications within a programme delimited by their Qualification Status:

Step 1 – Selecting the objects to report upon

To create a basic Qualifications Status report the following objects are required:

To create a basic standard decision report the following objects are required:

Select the objects noted above and move them into the Results Objects area

The objects within the Results Objects area will be displayed as columns in the report.

Step 2 – Selecting the objects to filter upon

Move the following objects from the Results Objects area into the Query Filters area:

1. Academic Year Code
2. Applicant Status Description & Code
3. School Description & Code

Step 3 – Selecting the values to filter upon

We now need to select the values within the objects noted above to filter the data we need.

To filter on these values click on the InList operator

For example for Academic Year Code click on the InList operator

Select Value(s) from list

Click on 2009/0 from the Academic Year Code list of values for selection and then click on the  button. This will move the value into the Value(s) Selected box.

Click on Ok to complete the value selection.

The Object should now be displayed as below:

Click on the InList Operator for the following Objects within the Query Filters area and select the value as described.

Your Query Filter area should look like this:

Step 4 – Running the query

You can now run the query to view the report by clicking on the  button.

This should produce the report as below:

Step 5 – Amending the Report display

The report in its raw state is hard to decipher and the application count is only counting each row and not the total under each Qualification Status.

Therefore, we are now going to amend the report display to get the most out of the results.

Creating a Report Header

First of all we will move the Qualification Status Description object from within the body of the report to be a header. This is done by highlighting the Qualification Status Description column and then dragging it above the body of the report and beneath the Report title.

Click on the Qualification Status Description Column beneath the column header. This should highlight the entire column.

Hold the left mouse button down on the column and drag it to the left hand side, aiming below the report title and above the body of results.

Once in position let the mouse button go.

This should create a new report header, and effectively sort the results under the applicable Qualification Status.

Positioning the ‘Number of Applications’ object

The Number of Applications object can be used to count the applications within the sections of a report.

To enable the object to produce the count for each Qualification Status section we need to re-position it from within the body of results to opposite the Qualification Status Description header.

Click on the Number of Applications Column beneath the column header. This should highlight the entire column.

Hold the left mouse button down on the column and drag it to the left hand side, aiming below the report title and above the body of results.

Once in position let the mouse button go.

This should create a new count header, totalling the applications held under each report section.