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:
Runtime Data Source

DataFlex Reports Quickstart

Lesson 2: ODBC

  1. The easiest way to create a DataFlex Reports report is using the New report wizard. 
  2. Choose the Standard report.
  3. Choose the ODBC database.
  4. Click 'Open...'
  5. The wizard shows the content of your system and user DSN’s. This allows to use a file DSN or a connection string.
  6. If your DSN is not in the list, open the ODBC manager from your windows environment. Do this by searching for ODBC data sources.
  7. On a 64 bit windows operating system, take the 32 bit version of the ODBC manager. 
  8. For this lesson: create a system DSN, by clicking the add button.
  9. Select the ODBC driver from the list that appears. In this case: the ODBC Driver 13 for SQL server.
  10. Click Finish.
  11. Enter the name of the data source and select the database server.
  12. Enter login credentials for this SQL Server. Choose integrated Windows authentification.
  13. To collect information from the database context change the default database to the order entry database.
  14. Accept the next page.
  15. A summery of the data source definition shows.
  16. Click the test data source button to confirm that you can connect to the database using this data source.
  17. This finishes the creation of the ODBC data source.
  18. Continu with the new report creation wizard by selecting the just created data source, ODBC.
  19. Choose the Order Entry SQL database. The wizards shows the schemas defined in the database. Select the DBO schema, expand the tables. Select the customer table.

  20. Select customer number, name and state.
  21. Finish the wizard.
  22. Click the Preview button to see the report.