Excel database crystal reports

Video Tutorials

• Overview of Crystal Reports
• Creating a report
• Connecting to an ODBC data sources
• Connecting to MS Excel via ODBC
• Connecting to MS Excel via OLEDB
• Inserting Groups
• Calculate Totals and Subtotals
• Filter the data
• Exporting a report to different format ( Excel, PDF, . )
• List of over 90 video tutorials on creating reports

Related Pages

• SAP Crystal Reports Community
• Questions around SAP Crystal Reports
• Blog Posts for SAP Crystal Reports
• SAP Crystal Reports Installation and User Guide
• Supported Platforms (PAM) for Crystal Reports 2020
• System Requirements and Prerequisites (PAM) for all product
• SAP Crystal Reports Roadmap
• SAP BusinessObjects Maintenance Schedule ( Support Pack and Patches )

Recommended Articles

Downloading and Installing Crystal Reports

• KBA 1291961 - How to download Crystal Reports?
• KBA 2175455 - Where can I download updates for Crystal Reports without a support Contract?
• KBA 1502717 - How to request a permanent license key for Crystal Reports?
• KBA 1638102 - Installation Best Practices for Crystal Reports

Database Connectivity

• KBA 1669329 - How to create a report off MS Excel spreadsheet saved in .xlsx format in Crystal Reports?
• KBA 2238875 - Connecting to Oracle from Crystal Reports
• KBA 1181947 - Oracle Stored Procedures Requirements for Crystal Reports
• KBA 1892878 - Stored Procedure requirements for creating reports in Crystal Reports
• KBA 1527666 - How to connect to a database using a JDBC connection in Crystal Reports?
• KBA 2443638 - How to connect to HANA via a JDBC connection in Crystal Reports?
• KBA 1615056 - How to connect to SAP data source from Crystal Reports?

• KBA 1946358 - Crystal Reports features supported by exporting format
• KBA 1835763 - Text truncates when exporting a report to PDF format
• KBA 1841430 - How to design a report that will export well to MS Excel from Crystal Reports?
• KBA 1220516 - Font size decreases when exporting a report to PDF format
• KBA 1817212 - Column headers repeats for each row of data when exporting a report to CSV
• KBA 1381498 - Chinese, Korean, Japanese, Greek, or Arabic characters show as question marks when exporting a report to Text

Parameter and Dynamic List of Values (LOV)

• KBA 2388686 - Crystal Reports Dynamic Parameter Best Practice
• KBA 1856647 - Reasons causing empty List of Values (LOV) prompt in Crystal Reports
• KBA 2358049 - How to troubleshoot Crystal Reports Dynamic Parameter List of Values (LOV) ?
• KBA 3408821 - Guided Answer for troubleshooting Dynamic Parameter List of Values in Crystal Reports
• KBA 1218588 - How to increase the number of values for dynamic parameter list of values (LOV)?
• KBA 1695453 - LOV prompt groups are not visible after using Promotion Management to promote Crystal Reports (CR) along with Business View dependencies

General and Troubleshooting Tool

• KBA 2719284 - Default or hard-coded limits in Crystal Reports
• KBA 2165260 - List of Registry Keys used in Crystal Reports, to fix, change or correct behavior
• KBA 1603398 - How to perform a trace in Crystal Reports using crlogger?
• KBA 1212428 - How to use SQLCON to test ODBC drivers and database connectivity?
• KBA 1220085 - How to trace report connectivity to SAP data sources, like SAP Tables or BEx Queries, from Crystal Reports?
• KBA 1842413 - How to use Process Monitor with Client Tools of SAP BusinessObjects Business Intelligence Platform?
• KBA 3062411 - How to post a question on Crystal Reports on the SAP Community?
• KBA 1868899 - Top SAP Knowledge Base Articles for Crystal Reports
• KBA 3032096 - Statement of direction for Crystal Reports and Crystal Reports for Enterprise