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.
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.
After clicking the VIEW SQL button, it will then load the SQL Query of the report for your perusal.
INFO: To get rid of the SQL Query section, just click the LOAD BASE REPORT button to refresh the page and you’ll be ready to write or create your customised SQL query under the GENERIC REPORT QUERY section, and save and produce your report as required.