Overview

Reports can be produced in different formats depending on how and where you use the reports for. In Report Builder, you can find the following format options for your perusal: Print Format HTML, Bulk Student Select, CSV, Report Summary, Custom CSV, XLS, Uploaded HTML template, and JSON. All of these will be explained in details on this page.

Print Format HTML

On Screen data export.

In using Report Builder and when testing out small amount of data or information, this is the fastest way to check if your filter clauses are working. If selected to be your output format, Paradigm will open a new window to display your report (see sample screenshot below).

back to top

Bulk Student Select

Used for bulk reports and actions within the system

back to top

CSV

Comma-separated value, a text file that has a specific format which allows data to be saved in a table structure. This output format is very useful in exporting large amount of data from Paradigm. Another advantage of using this format is its flexibility to work with many other applications.

back to topv

Custom CSV

A CSV output format for your report can be customised more by using delimiter and enclosure.

Delimiter

This will tell the program or application you used to open the CSV file where is the starting point of the field and where it ends. The most commonly used delimiter is the comma (,).

Enclosure

This will tell the program or application to enclose fields which contains a delimiter character that you’ve set to be read as one field. (e.g. using (,) as a delimiter and in one of the fields to be outputted contains the text “Unit1, Unit2, Unit3” which is intended to be read as one field). The most commonly used enclosure is the double quotes (“).

Example

Delimiter is set as comma (,) and Enclosure is set as double quotes (“) sample data output: "Mr.","Marcus","Fernandez","7 Birch St.,","Bayswater","VIC","3153"

back to top

Report Summary

Some data or fields in your report can be summarised (as set under the SUMMARISE DATA section). This output format will give you options to display your report with data and summary, summary only, or data and summary in separate files.

Sample Data with Summary

Data and Summary

This output type will give you the data and their summary, e.g. Invoice Amount field and its Sum

Summary Only

This output type will give you only the summary of the data or field selected, e.g. just the Sum of the Invoice Amount, without giving you all the data that has been summed up.

Data and Summary in Separate Files

This output type will give you two separate files. One for the data, in the example above all the data or information under the Invoice Amount Field, and the other file contains the summary of the data.

back to top

XLS

The original file extension type for Microsoft spreadsheets.

back to top

Uploaded HTML Template

Used for mail merge documents.

back to top

JSON

JavaScript Object Notation (JSON) is used if you want the data generated in Paradigm to be transmitted to your other web applications used in your business or institution.

back to top

_{Advanced Report Builder | Order By Clauses | Alternative Data Formats | Bulk Student Select | Complex Filter Clause Operators | Nested Operators Using Brackets | User-Defined Parameters | Summarise Data | Generic Report Query}