SAP Crystal How-to Guides

Whether you are a novice user, or an experienced designer looking to see if you are following best practices, these guides are made for you.

A. SAP Crystal Solutions

Note that these guides are meant for SAP Crystal Reports 2016, SAP Crystal Reports 2020, SAP Crystal Server 2016 and SAP Crystal Server 2020. SAP Crystal Reports 2016 is 32 bit and SAP Crystal Reports 2020 is 64 bit. All data connectors / drivers need to follow the same logic: 32 bit for SAP Crystal Reports 2016 and 64 bit for SAP Crystal Reports 2020.
---
For question please contact sales@sap.com

A. 1. First Impressions of Crystal Solutions

A. 2. Download SAP Crystal sample files

Note: To open the MS Access file from SAP Crystal Reports 2016, you will need to save it as a Microsoft Access Database 2002-2003 file.

B. SAP Crystal Reports

B.1. SAP Crystal Reports: From evaluation to production

PDF Step-by-Step Guide: Learn to continue with an installation of Crystal Reports by replacing the trial keycode with a production license.
https://d.dam.sap.com/a/p4ZNNYx/SAP%20Crystal%20Step%20by%20Step%20guide%20from%20trial%20to%20production%20license%20key.pdf?rc=10

B. 2. SAP Crystal Reports: Learn from our sample reports

B. 3. SAP Crystal Reports: Connect to a data source

B. 4. SAP Crystal Reports: Connect to Microsoft SQL Server

PDF Step-by-Step Guide: Start reporting from Microsoft SQL Server data sources by following the steps in this guide to establish a connection.
https://d.dam.sap.com/a/Ch2T4td/SAP%20Crystal%20Step%20by%20Step%20guide%20connecting%20to%20MS%20SQL%20Server.pdf?rc=10

Note: For SAP Crystal Reports 2020, you will need a 64 bit connection so please download and install Microsoft Access Database Engine 2016 Redistribuable, not Microsoft Access Database Engine 2010 Redistribuable. This solution can be found on the Microsoft web site.

B. 5. SAP Crystal Reports: Connect to Microsoft Access

PDF Step-by-Step Guide: Report from Microsoft Access sources by following the steps in this guide to establish a connection.
https://d.dam.sap.com/a/B5ADjFg/SAP%20Crystal%20Step%20by%20Step%20guide%20Connecting%20to%20MS%20Access.pdf?rc=10

Note: For SAP Crystal Reports 2020, you will need a 64 bit connection so please download and install Microsoft Access Database Engine 2016 Redistribuable, not Microsoft Access Database Engine 2010 Redistribuable. This solution can be found on the Microsoft web site.

B. 6. SAP Crystal Reports: Connect to Microsoft Excel

PDF Step-by-Step Guide: Report from Microsoft Excel (.xls and .xlsx) sources by following the steps in this guide to establish a connection.
https://d.dam.sap.com/a/EwMrLB7/SAP%20Crystal%20Step%20by%20Step%20guide%20Connecting%20to%20MS%20Excel.pdf?rc=10

Note: For SAP Crystal Reports 2020, you will need a 64 bit connection so please download and install Microsoft Access Database Engine 2016 Redistribuable, not Microsoft Access Database Engine 2010 Redistribuable. This solution can be found on the Microsoft web site.