Overview

All data in Paradigm are stored in tables, and the collection of tables (organised and structured) is called a database. Report Builder allows you to extract data from the database and generate the required data for you to make meaning and analysis. Knowing what data or information to extract is key in building a report. Report Builder is built on SQL (Structured Query Language), however, you don’t need to be able to write in SQL to create reports. It has a friendly user interface to help you create your reports.

The following steps will guide you on how to create a new saved report using the Report Builder menu in Paradigm:

_{Base Reports | Report Columns | Filter Clauses | User Defined Parameters | Order By Clauses | Generic Report Query | Summarise Data | Save Report |} Format _{Introduction to Report Builder | Step 1 - Select a Base Report | Step 2 - Add and Remove Fields | Step 3 - Rename and Reorder Fields | Step 4 - Add Filter Clauses | Step 5 - Save Report}