APPX Software Library

Chapter 6: Create Reports with Crystal Reports 2016

Create a COUNTRY Report

  1. Select Report wizard on the Crystal Reports start page.
  2. Expand Create New Connection → ODBC (RDO), choose AppxODBC, and select Next.
  3. Enter the APPX user and password and select Finish.
Crystal connects using AppxODBC with a masked APPX password.
Figure 21. Crystal connects using AppxODBC with a masked APPX password.

Server AppxODBC here names the ODBC data source. Its optional Service field can remain blank; the driver then uses the default sqlnw lookup to reach this gateway on TCP 1992. The provider dialog shown here does not display that field. DSN and connection fields.

  1. Expand appx, select dmo_dmo_country, and move it into Selected Tables with the right arrow.
Crystal connects to COUNTRY through the same ODBC data source.
Figure 22. Crystal connects to COUNTRY through the same ODBC data source.
  1. Select Next, then add name, region_label, no_words and post_code_loc to Fields to Display.
  2. Select Finish. The Preview displays 7 records with the four selected fields.
The Crystal report returns seven full country names and the expected sample values.
Figure 23. The Crystal report returns seven full country names and the expected sample values.
  1. Select File → Save As, choose a local folder and save APPX-ODBC-COUNTRY.rpt.
  2. To make a PDF, select File → Export → Export Report. Choose Adobe Acrobat (PDF) and Disk file, select OK, choose All pages, and save the PDF locally.

Verified result: the native report displays all seven records with the selected fields. The report-save and PDF-export route also completed.