To continue with this content, please log in with your Data Access ID or create a new account.
Cancel Data Access ID
You may not be authorized to see this content. Please contact Data Access Europe for more information.
Cancel Data Access Europe
You are not authorized to see this content.
Cancel Data Access Europe
Next lesson:
Creating SQL Statements

DataFlex Reports – New Feature 5.0 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.