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

A. 1. First Impressions of Crystal Solutions

PDF Step-by-Step Guide: Check out the valuable features and capabilities of Crystal Solutions.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-First-Impressions.pdf?

A. 2. Download SAP Crystal sample files

Download our SAP Crystal templates in RPT format:

https://crystal-reports-downloads.s3.amazonaws.com/SAP-Crystal-Reports-sample-reports.zip

---

Download our SAP Crystal sample database in MS Excel format:

https://www.sapstore.com/medias/Ridin-Round.xls?

Download our SAP Crystal sample database in MS Access format:

https://crystal-reports-downloads.s3.amazonaws.com/xtreme1.mdb
---

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 2020: From evaluation to production

PDF Step-by-Step Guide: Learn to continue with an installation of Crystal Reports 2020 by replacing the trial keycode with a production license.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-From-trial-to-production-license-key.pdf?

PDF SAP Crystal Reports 2020 Installation Guide:

https://www.sapstore.com/medias/cr20-installgd-en.pdf?

Start a 30 days trial for SAP Crystal Reports 2020:

https://www.sap.com/products/crystal-reports/trial.html

B.2. SAP Crystal Reports 2016: From evaluation to production

PDF Step-by-Step Guide: Learn to continue with an installation of Crystal Reports 2016 by replacing the trial keycode with a production license.

https://www.sapstore.com/medias/SAP-Crystal-Step-by-Step-guide-From-trial-to-production-license-key.pdf?

PDF SAP Crystal Reports 2016 Installation Guide:

https://help.sap.com/doc/431da886be3446ac87f68a25530fd45b/2016.7/en-US/cr16_installgd_en.pdf

Start a 30 days trial for SAP Crystal Reports 2016:

https://www.sap.com/products/crystal-reports/trial.html

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

PDF Step-by-Step Guide: Leverage our sample reports to learn how to use SAP Crystal reports.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-Learn-from-sample-reports.pdf?

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

PDF Step-by-Step Guide: Follow the steps to learn how to connect to a data source.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-How-to-connect-to-a-data-source.pdf?

B. 5. 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://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Connect-to-MS-SQL-Server.pdf?

B. 6. 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://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Connect-to-MS-Access.pdf?

B. 7. 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://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Connect-to-MS-Excel.pdf?

B. 8. SAP Crystal Reports: Connect to MySQL

PDF Step-by-Step Guide: Report from MySQL data sources by following the steps in this guide to establish a connection.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Connect-to-MySQL.pdf?

B. 9. SAP Crystal Reports: Create an invoice

PDF Step-by-Step Guide: Use this guide to create a report you can use as an invoice (or modify to create statements, shipping documents, etc.).

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-How-to-create-an-invoice.pdf?

B. 10. SAP Crystal Reports: Replicate a pre-printed form

PDF Step-by-Step Guide: Match the layout of a pre-printed form (tax forms, government submissions, bank certificates, payroll checks).

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-How-to-replicate-a-pre-printed-form.pdf?

B. 11. SAP Crystal Reports: Create a sales report

PDF Step-by-Step Guide: Create a report for operations, in this use-case follow the guide to build a sales report.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Create-a-sales-report.pdf?

B. 12. SAP Crystal Reports: Create a human resources report

PDF Step-by-Step Guide: Use Crystal Reports' flexible design tools and features to create a report for your business, in this case, an HR report.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Create-an-HR-report.pdf?

B. 13. SAP Crystal Reports: Create an interactive dashboard

PDF Step-by-Step Guide: When building dashboards with SAP Crystal Reports read this guide to follow some best practices.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Create-an-Interactive-Dashboard.pdf?

B. 14. SAP Crystal Reports: Create reports for publishing

PDF Step-by-Step Guide: Create a Publishing report for data-driven report bursting.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-How-to-create-Crystal-Server-Publications.pdf?

B. 15. SAP Crystal Reports: Data Handling (select, group, sort)

PDF Step-by-Step Guide: Use fundamental data handling features in any report.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Data-Handling.pdf?

B. 16. SAP Crystal Reports: Using Formulas with Crystal Reports

PDF Step-by-Step Guide: Learn how to use the Formula Workshop and the Formula Editor to create values not included in your data source.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Formulas.pdf?

Get additional help with Formulas: https://help.sap.com/docs/SAP_CRYSTAL_REPORTS/dfc124becfa845ffa91b1e717b20e3ec/477b49c46e041014910aba7db0e91070.html

B. 17. SAP Crystal Reports: Using Charts with Crystal Reports

PDF Step-by-Step Guide: Use this guide to learn how to use charts within your reports.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Charts.pdf?

See the different chart types available: https://www.sapstore.com/medias/SAP-Crystal-Solutions-2020-Chart-types.pdf?

Look into third party charting capabilities: https://www.crchart.com/

B. 18. SAP Crystal Reports: Share a Crystal report

PDF Step-by-Step Guide: Share reports with end users without the need to design or modify the report.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Sharing-a-Crystal-Report.pdf?

B. 19. SAP Crystal Reports: Upgrade from SAP Crystal Reports Viewer, SAP Crystal Reports for Visual Studio or SAP Crystal Reports for Eclipse to Crystal Reports

PDF Step-by-Step Guide: Learn why you should upgrade to SAP Crystal Reports or SAP Crystal Server

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-upgrade-from-viewer.pdf?

B. 20. SAP Crystal Reports: Entry level video tutorials

Watch tutorial videos for SAP Crytal Reports 2020: https://www.youtube.com/playlist?list=PLNmCOqDvMhACCxIjBZy9cGFBIQxxwtLCx

C. SAP Crystal Server

C. 1. SAP Crystal Server: Installation Guide from Evaluation to Production

PDF Step-by-Step Guide: Learn how to download, install and configure SAP Crystal Server for report distribution.

https://www.sapstore.com/medias/SAP-Crystal-Server-2020-Step-by-Step-from-evaluation-to-production-installation.pdf?

PDF SAP Crystal Server 2020 Installation Guide:

https://www.sapstore.com/medias/crs2020-install-win-en.pdf?

Start a 60 days trial for SAP Crystal Server 2020:

https://www.sap.com/products/crystal-server/trial.html

C. 3. SAP Crystal Server: View interactive reports

PDF Step-by-Step Guide: View pixel-perfect, fully interactive, real-time reports within a web browser.

https://www.sapstore.com/medias/SAP-Crystal-Server-2020-Step-by-Step-View-interactive-reports.pdf?

C. 4. SAP Crystal Server: Schedule reports

PDF Step-by-Step Guide: Automate reports to run and distribute on a flexible schedule.

https://www.sapstore.com/medias/SAP-Crystal-Server-2020-Step-by-Step-guide-Schedule-reports.pdf?

C.5. SAP Crystal Server: Mass Invoicing

PDF Step-by-Step Guide: Set up invoices to populate with individualized data.

https://www.sapstore.com/medias/SAP-Crystal-2020-Step-by-Step-guide-Mass-invoicing.pdf?

C.6. SAP Crystal Server: Sophisticated Distribution (Requires SAP Crystal Server 2020 (CS))

PDF Step-by-Step Guide: Distribute reports automatically customized for individual recipients. Using this capability requires the separate purchase of SAP Crystal Server 2020 (CS).

https://d.dam.sap.com/a/oqQLLCm/SAP%20Crystal%20Server%205%20CAL%20Step%20by%20Step%20view%20sophisticated%20distribution.pdf?rc=10

D. Overview Material

D. 1. Read our overview brochures

PDF Overview: Product features to leverage with SAP Crystal Solutions for the small to midsize business

https://www.sapstore.com/medias/SAP-Crystal-Solutions-summary.pdf?

PDF Overview: Business goals to achieve with SAP Crystal Solutions for to midsize business

https://www.sapstore.com/medias/SAP-Crystal-Solutions-Costs.pdf?

PDF Overview: Implementation costs to consider with SAP Crystal Solutions

https://www.sapstore.com/medias/SAP-Crystal-Solutions-Business-Goals.pdf?

PDF Overview: Use pixel-perfect report design to your advantage

https://www.sapstore.com/medias/SAP-Crystal-Solutions-Pixel-perfect-reports.pdf?

D. 2. Watch our overview videos

Video: Solution overview:
https://www.youtube.com/embed/W9-oDxRByDg

Video: Create a compelling data story:

https://www.youtube.com/embed/6bL_dZwF7Sg

Video: Use color and contrast in your visualizations:

https://www.youtube.com/embed/Z5xt7WLZZ_c

Video: Eliminate clutter in your visualizations:

https://www.youtube.com/embed/T98wthL8ibU

E. SAP Store purchases

E. 1. Buy SAP Crystal Reports on SAP Store

PDF Step-by-Step Guide: Buy SAP Crystal Reports in a digital fashion with a credit card or per invoice.

https://www.sapstore.com//medias/SAP-Crystal-Reports-Step-by-Step-SAP-Store-purchase.pdf?

Video: How to buy SAP Crystal Reports digitally:

https://www.youtube.com/embed/9bhXZnhMZFU

E. 2. Buy SAP Crystal Server on SAP Store

PDF Step-by-Step Guide: Buy SAP Crystal Server in a digital fashion with a credit card of per invoice.

https://www.sapstore.com/medias/SAP-Crystal-Server-Step-by-Step-SAP-Store-purchase.pdf?

Video: How to buy SAP Crystal Server digitally:

https://www.youtube.com/embed/8IM8bEG1e68