REFERENCE LIBRARY
SQL Statements
This Course introduces you to a new feature in DataFlex reports 5.0: SQL statements. SQL statements are geared toward report designers who wish to have full control over how DataFlex Reports retrieves records from an ODBC data source and for developers who seek to optimize their reports performance. SQL statements allow report designers to include custom SQL in their report. This video will demonstrate how to create those SQL statements. Before we start let’s take a look at some of the facts using SQL statements in DataFlex reports. It’s geared towards report developers, they have the ability to optimize reports by using custom SQL, only available in Developers Edition of DataFlex Reports, only available for ODBC data sources, it requires only basic knowledge of the SQL language and depending on the SQL used, may not be portable to other databases.
