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:
Change SQL Statements and add parameters

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:

  1. Choose File, New, New Report Wizard…

  2. Choose the Standard Report.
  3. Double Click the ODBC datasource to open the ODBC wizard.

  4. Select AdventureWorks as the Data Source.

  5. Finish the wizard.
  6. An extra option SQL statement appeared.

  7. Double click the SQL statement.
  8. Enter the SQL statement.

  9. Double click the table or click the table and press the > button.

  10. On the next page select the fields:
    - Name
    - ListPrice
    - Class

  11. On the further pages of the wizard just click Next and finish the wizard.
  12. Go to View, Preview Report.

  13. The output shows up.

  14. This ends this lesson.