New Feature DR 5.0 SQL Statements

Lesson 1: Creating 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.

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
Depending on the SQL used, may not be portable to other databases.

Follow these steps to create SQL statements:

Choose File, New, New Report Wizard…
Choose the Standard Report.
Double Click the ODBC datasource to open the ODBC wizard.
Select AdventureWorks as the Data Source.
Finish the wizard.
An extra option SQL statement appeared.
Double click the SQL statement.
Enter the SQL statement.
Double click the table or click the table and press the > button.
On the next page select the fields:
- Name
- ListPrice
- Class
On the further pages of the wizard just click Next and finish the wizard.
Go to View, Preview Report.
The output shows up.
This ends this lesson.

SQL Statements

DataFlex courses

Information

New Feature DR 5.0 SQL Statements

Lesson 1: Creating SQL Statements