Overview

If you are familiar with SQL, the data elements in Paradigm, and how to build queries from scratch, this feature could be your playground when it comes to generating data or information to produce meaningful reports. This would require utmost care and responsibility though, not to anyway compromise your business or institution’s data.

Image Modified

As a guide in building your own query, you can try loading any base or saved reports which are designed closer to the output that you want to produce and just edit or change some lines of the query that will meet your requirements, you can go to the SAVE REPORT section and click the VIEW SQL button.

Image Added

After clicking the VIEW SQL button, it will then load the SQL Query of the report for your perusal.

Image Added

_{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}