Skip to Content
Nous contacter
Discutons en ligne Discussion en direct hors ligne
Discutez en ligne avec un interlocuteur SAP qui vous aidera à résoudre vos problèmes.
Nous contacter
Nous envoyer vos commentaires ou vos questions par e-mail.

Frequently Asked Questions

Search the list below to find answers to frequently asked questions on topics such as SAP Crystal Reports, SAP Crystal Server plus other Crystal solutions and tools.

Facts

What are SAP Crystal Solutions?

Products which are branded “SAP Crystal” are software tools used for data analysis and data reporting. Current products include: Crystal Reports, Crystal Server, Crystal Reports for Visual Studio, Crystal Reports for Eclipse, and Crystal Reports Viewer. 

What do these products do?
  • SAP Crystal Reports allows a report designer to bring data in from various sources to create a document where the data is formatted into a design of their choosing, such as an invoice, sales or operational report, marketing letter or some sort of analytic.
  • SAP Crystal Server provides a platform through which you can share documents (such as SAP Crystal Reports files) with end users. With Crystal Server you can schedule reports to be pushed out to recipients as PDF email attachments, or access the reports securely and refresh the data entering parameters using a browser or mobile app.
  •  SAP Crystal Reports for Visual Studio and SAP Crystal Reports for Eclipse are free add-ons for developers using .NET and Java respectively to embed reporting capabilities into their applications.
  • SAP Crystal Reports Viewer is a free desktop application (Windows or Mac) allowing recipients of Crystal Reports files (.rpt file extension) to open the document and interact with the data saved with the file, including search, drill-down, print and export – but not refresh.
  • SAP Crystal Dashboard Design is included with the Named User License package of Crystal Server 2016. It is a designer which creates interactive data visualizations you can embed into web pages, PDF, Word and PowerPoint documents. These documents can be standalone, linked to data sources, or embedded into a Crystal Reports file.
Where can I find a SAP Crystal solution overview?

You can download the brief with the Crystal Solutions overview. This solution brief is also available in Spanish, French, German, Portuguese and Chinese.

What other SAP Crystal solution materials are available for download?

We have documents such as product availability matrix or installation, administration and user guides.

How do SAP Crystal Reports and SAP Crystal Server work together?

Start with Crystal Reports to create a report. Crystal Server distributes reports by pushing reports out, for example as a scheduled email attachment. Crystal Server also provides a portal for end users to access content securely via browser or mobile app to view, enter parameters, refresh and print or export a report. 

What can SAP Crystal Reports and SAP Crystal Server do for me?

If you need to understand your business; if you need the data for an action plan; if you want to provide information on an aspect of your business, then the analytic capabilities of Crystal Reports will be valuable to you. Once you have created the print-ready report, chances are that others want to use the report too. Crystal Server provides the ability to distribute the report to end users. 

Who typically uses SAP Crystal Solutions?

People who use Crystal Reports are usually those who use data a lot in their day-to-day role, such as Database Administrators, IT, Finance, Accounting, and Business Power Users. The people who log on to the portal provided by Crystal Server to access pre-build content are usually end users, business users, and management; in other words, consumers of reports who want answers to business question already asked on their behalf (by those who created the report with Crystal Reports).

Do you have some use case scenarios?

You can view a list of use cases by industry with a few summary videos for these hypothetical use cases.

How many people are using Crystal products?

More than 1.000.000 users worldwide are using Crystal products.

Licensing

What are the different licenses?
  • SAP Crystal Reports 2016, Named User License: SAP Crystal Reports is sold on a Named User License basis; one unique license is required for each person using the software. That individual as the Named User License holder may install the software to any number of computers (including concurrently), any number of times for their exclusive use with a valid, non-expiring license code; a Named User License cannot be shared with another individual.
  • SAP Crystal Server 2016 licensing. Crystal Server has two types of license: Named User License (NUL) and Concurrent Access License (CAL). Licensing determines access to the interfaces where documents are shared, available for viewing: BI Launch Pad, SAP Mobile BI app. Crystal Server 2016, 1 NUL includes a single license of the content creation tool Crystal Reports 2016. Note: CAL includes Publishing, a feature where the data in a report is unique for each recipient (such as invoices and statements). Publishing to an unlimited number of unique recipients is included with Crystal Server 2016 CAL.
What is included in the Crystal Server 1 NUL License?
  • The SAP Crystal Server 1 NUL license includes 1 named user license of SAP Crystal Server 2016 and 1 license of SAP Crystal Reports 2016. 
  • It also comes with support for mobile access on iOS devices. 
  • The 1 named user license (1 NUL) allows usage by a single, specific individual user only. 
What are the minimum and maximums for Crystal Server 2016 licensing?
  • SAP Crystal Server 2016 deployments require 1 NUL as a minimum. 
  • Purchased separately from NUL, CAL is added to a NUL deployment. 
  • SAP Crystal Server 2016 NUL can be added together up to a maximum of 100 NUL. 
  • SAP Crystal Server 2016 CAL is sold in increments of 5 and can be scaled up to 50 CAL.
Where can I get detailed information on Crystal Solutions licensing?

Read a doc explaining SAP Crystal solutions licensing or watch a video on licensing options.

What are the SAP Software Usage rights?
  • Software usage rights (see pages 31 - 33 for SAP Crystal solutions)
  • SAP BusinessObjects Software Clickwrap Agreement

Product versions

How are SAP Crystal Reports versions named?
  • SAP Crystal Reports includes version numbering with the product name up to SAP Crystal Reports Xi (version 11). 
  • Subsequent versions include the year of release with the product name; SAP Crystal Reports 2008 is version 12, SAP Crystal Reports 2011 is version 14.0, SAP Crystal Reports 2013 is version 14.1 and SAP Crystal Reports 2016 is version 14.2. 
  • All versions of SAP Crystal Reports designer are 'Developer' editions. 
  • The last version which had Standard, Professional and Developer editions was SAP Crystal Reports Xi. 
  • The Standard and Professional editions were eventually discontinued after the release of SAP Crystal Reports 2011. 
  • SAP Crystal Reports Xi Developer edition remains available and does everything that Standard and Pro could do - and more.
What is version 13 of SAP Crystal Reports?
  • SAP Crystal Reports, version for Visual Studio and SAP Crystal Reports, developer version for Eclipse share the designation of version 13 of the Crystal Reports product family.
  • These are tools available for developers to create basic reports and to embed a Crystal Reports engine to run report files (.rpt format) in an application they have developed using a Crystal Reports software development kit (SDK).
  • The version numbering for these free downloads of the SDK and runtime are version 13.
What versions of SAP Crystal Reports are officially supported by SAP?

SAP Crystal Reports, version for Visual Studio, SAP Crystal Reports, developer version for Eclipse, SAP Crystal Reports 2013 and SAP Crystal Server 2013 (until the end of 2018) as well as SAP Crystal Server 2016 and SAP Crystal Reports 2016.

What versions of SAP Crystal Reports are available through the SAP Store?
These version are available from the SAP Store: 
  • SAP Crystal Reports Xi R2* (version 11.5)
  • SAP Crystal Reports 2008* (version 12.1)
  • SAP Crystal Reports 2011* (version 14.0)
  • SAP Crystal Reports 2013 (version 14.1) 
  • SAP Crystal Reports 2016 (version 14.2)  
    * These versions are no longer supported

Languages

What languages are supported?

SAP Crystal Reports 2016 User Interface is localized into these languages:

  • English, French, German, Japanese, Spanish, Simplified Chinese, Italian, Dutch, Russian, Korean, Traditional Chinese, Portuguese, Swedish, Polish, Danish, Norwegian, Finnish, Thai, Czech, Hungarian, Slovakian, Turkish, Romanian, Slovenian.  
  • Arabic, Hebrew, Ukrainian, Kazakh are only supported in SAP Crystal Reports DHTML Viewer, when using Internet Explorer and Firefox.

Service packs

Where can I find more information about available service packs?

View all information related to available service packs

Compatibility

Is SAP Crystal Reports backwards compatible?

Yes. You can open reports created with earlier versions, such as SAP Crystal Reports 9 and higher with the later versions, including the highest: SAP Crystal Reports 2016. Any changes or new reports you create with SAP Crystal Reports 2016, can only be saved as a version 14.2 .rpt file.

Can I use an old report with SAP Crystal Server 2016?

It is recommended to migrate the report to be the same version as SAP Crystal Server. Do this by opening the .rpt file with SAP Crystal Reports 2016, then save. The report will save as a 14.2 version .rpt file. You may want to ‘Save As’ and rename the copy to archive the document in the original, older version until all content has been migrated to your satisfaction.

Can I use a SAP Crystal Reports 2016 report with SAP Crystal Server 2013?

It is recommended you use SAP Crystal Reports 2013 to create/modify reports run through SAP Crystal Server 2013.

Can I use SAP Crystal Reports 2016 to edit a report which is run through a legacy application?
  • If your application uses an SAP Crystal Reports runtime engine of version 13, then you can probably use SAP Crystal Reports 2016 for report design.
  • If your application uses an earlier version of SAP Crystal Reports runtime, then it is recommended to use the same version of SAP Crystal Reports as the designer to match for compatibility.
  • It is best to check with the developer of the application for their recommendation.
How are versions of SAP Crystal Reports different?

View a comparison chart to see the differences in the SAP Crystal Reports versions.

Can SAP Crystal Reports 2016 be installed to a virtual environment?

Yes, see page 8 of the SAP Crystal Reports 2016 Product Availability Matrix (PAM) for details. Please ensure the installation is compliant with the Named User License agreement wherever the software is installed.

What data sources can SAP Crystal Reports 2016 report from?

For the full range of data sources and the connections you can use, you can refer to the SAP Crystal Reports 2016 supported data sources document.

Is there a 64-bit Version?

As of SAP Crystal Reports 2016, this software is 32-bit only

What are the hardware specs for SAP Crystal Server 2016?

Minimum Server Hardware Requirements:

  •  Processor: 2.0 GHz dual-core 64 bit CPU
  •  Memory: 16 GB RAM memory
  • Disk space – Default Installation English only/11 GB All Languages/30 GB

Operating System Requirements:

  •  Windows Server: 2019, 2016, 2012 R2, 2008 R2
  • Linux: SUSE x86_64 SLES 11, 12, Red Hat x86_64 EL 6, 7, Oracle Linux 7.2, 7.5

Minimum System Requirements: 

  • Browsers: IE 10, 11, Edge HTML 14.1, 15.15, 16.x, 17.x, Firefox ESR 45.x, 52.x, 60.x, Safari 7-12, Google Chrome

For additional details see the Supported Platforms for BI Platform 4.2, the technology Crystal Server 2016 is based on.

Product maintenance

Is there a support/maintenance program for SAP Crystal Reports, desktop products?
  • There is no maintenance or software assurance program, customers move to new versions by buying a discounted upgrade license. 
  • There is no phone-line support for desktop products, they are supported via our free online forum on the community pages. Create a free account and post a new discussion to the forum and one of our developers will respond and direct you to the best resource for a fix. 

For any technical issues, use one of these resources:

Support levels

What Support is there available for SAP Crystal Server?
  • For all SAP Crystal Server support issues, please contact the SAP Customer Interaction Center at 1-800-677-7271.
  • Visit the SAP Service Marketplace portal. 
  • Note an S-User ID and password will be required to access support. S-User IDs are only available with a valid Maintenance and Support Contact. If this has been lost or you did not purchase maintenance and support initially: please escalate with your vendor as they will need to be involved in order to achieve a proper resolution.
Where can I get support for my product?
  • If you have purchased SAP Crystal Server and have a current maintenance agreement, you can access the SAP Service Marketplace to create a support ticket for an engineer to work with you to resolve the problem.
  • Also available for customers under maintenance in the SAP Service Marketplace is 'Ask an Expert Peer' for up to 20 questions a month can be asked for 1:1 consultation with an SAP partner at no extra charge.
  • You can access free support through the SAP Community. 
Can I buy support for a specific case?

When customers have a technical issue, they can make use of this paid resource: 

  • SAP Crystal Single Case. Your purchase of SAP Crystal Single Case gives you access, in English, to our customer support engineers via an online ticketing process and is valid for one full year from the date of your purchase, excluding weekend, for the single issue. There is no software to download or install. 
  • You can purchase SAP Crystal single case support through the online store (for supported versions only) in North America (USD), UK (GBP), Germany (EUR), France (EUR), APJ.
When is support ending for the different versions?
  • SAP Crystal Reports 2016: 31 December 2020 
  • SAP Crystal Reports 2013: 31 December 2018 
  • SAP Crystal Reports 2011: 31 December 2015 
  • SAP Crystal Reports 2008: 31 December 2015 
  • SAP Crystal Reports Xi R2 (2005): 30 June 2011

SAP Crystal solutions for developers

What is available for a customer developing a custom application?

SAP Crystal Reports runtime is free for internal use, and as for what version you run, we strongly suggest using the latest version to ensure compatibility. Make sure your version of SAP Crystal Reports matches your version of Visual Studio or if the application is JAVA based use the version for Eclipse. 

  • SAP Crystal Reports, version for Visual Studio
  • SAP Crystal Reports, version for Eclipse
  • SAP Crystal Reports .NET SDK Developer Guide
What is SAP Crystal Reports for Developers?

SAP Crystal Reports developer tools are also known as SAP Crystal Reports, version for Visual Studio and SAP Crystal Reports, developer version for Eclipse.

Developing an application with SAP Crystal Reports, version for Visual Studio for use within my company. Is it still free?

Yes. The downloads of the SDK and the runtime software are free. The runtime license for an internally developed and internally deployed application is also free for desktop (thick) or server (thin) client deployments.

When a contractor develops an app with SAP Crystal Reports, version for Visual Studio for our company, is the runtime still free?

Yes, if a contractor developed a one-off application for your company exclusively, this counts as an internal deployment.

When developing a desktop application to sell to external customers. Is this free too?

Yes, the SAP Crystal Reports, version for Visual Studio runtime is free for thick client applications for external deployments, including for commercial use.

When do you need to sell a license of SAP Crystal Reports with the application for runtime licensing?

If you develop an application which uses the SAP Crystal Reports, version for Visual Studio runtime engine in a server-based application deployed to your external customers’ server(s) then each customer will need a license of SAP Crystal Reports 2016 (or SAP Crystal Reports 2013 or SAP Crystal Reports 2011) for the required runtime license.

Can licenses be bundled with SAP Crystal Reports with my external, server-based application for runtime license?

Yes, you can consider becoming an OEM partner, especially if you wanted a version of SAP Crystal Reports designer restricted to use only your data source.

When the web application is running PHP. What have you got for me?

We offer SDKs and runtime for .NET and Java only.

Purchasing SAP Crystal solutions

What SAP Crystal Solutions products are available for a free?

SAP Crystal Reports Viewer 2016, SAP Crystal Reports, version for Visual Studio and SAP Crystal Reports, version for Eclipse are available as free downloads. 

What SAP Crystal Solutions products are available for a free trial?

SAP Crystal Reports 2016 is available for a 30-day trial, SAP Crystal Server 2016 has a 60-day trial. 

What’s the difference between a trial and what I would install in production?

Aside from price, the length of time you can use the software for is the only functional difference between a free trial and paid production installations; temporary use with a trial, or non-expiring with a production installation. There is no limitation to functionality and there is no use of a watermark when using SAP Crystal Reports software with a temporary or production license.

Can I convert a trial into a production installation?

Yes, you already have the full software installed, you just need to unlock its continuous use by removing the temporary key and replacing it with your non-expiring production code in the Help > License Manager menu.

How do I get started with a trial?

You can use this video to help you get started.

Buying SAP Crystal Reports on 3rd party marketplaces

Purchases other than on SAP Store can be made on the following Amazon, Alibaba or Flipkart sites:

What if someone who was the buyer for my company has left and I want to access my purchase history, and licenses or contact for technical support?

Please get in touch with the SAP Store team to update your organization’s profile and access with the necessary information.

The end user’s role changed/left the company. Can I reassign the license to someone else?

Yes, you can assign the Named User License to someone else to become the licensed user. There is no need to inform SAP of the change, but you will need to remove the software and license from the original license holder’s computer to install to the new user’s computer to ensure license compliance.

What discounts are available?
  • There is a discount for volume based on the quantity of items purchased per transaction. For example, if you buy a quantity of 2 licenses of SAP Crystal Reports 2016 through the SAP Store, a volume discount of 10% is applied at the checkout. 

  • There is a discount for the purchase of SAP Crystal Reports 2016 as an upgrade from an earlier version of SAP Crystal Reports (see next section). 
Does the order come with media?

Physical Media is no longer available.  All orders are Electronic Software Delivery (ESD).

Which versions are eligible to purchase with an upgrade discount?

You are eligible to purchase a license of SAP Crystal Reports 2016 (version 14.2) with an upgrade discount if you are the named user license holder of any of these previous versions of SAP Crystal Reports (see list below): 

  • SAP Crystal Reports 2013 (version 14.1) 
  • SAP Crystal Reports 2011 (version 14.0) 
  • SAP Crystal Reports 2008 (version 12) 
    SAP Crystal Reports Xi (version 11.0) and/or SAP Crystal Reports Xi R2 (version 11.5) 
  • SAP Crystal Reports 10 
  • SAP Crystal Reports 9 
  • SAPCrystal Reports 8 
  • Crystal Reports 7 
  • SAP Crystal Reports, version for Visual Studio 2008 (version 10.5) 
  • SAP Crystal Reports, version for Visual Studio 2005 (version 10.2) 
  • SAPCrystal Reports, version for Visual Studio 2003 (version 9.1) 
  • SAP Crystal Reports, version for Eclipse (with registered copies)
Which versions of SAP Crystal Reports are NOT eligible to purchase SAP Crystal Reports 2016 with an upgrade discount?

These versions are not eligible to purchase SAP Crystal Reports 2016 as an upgrade (please purchase a new, full license): 

  • Any version of SAP Crystal Reports as a trial 
  • SAP Crystal Reports, developer version for Visual Studio (version 13) 
  • SAP Crystal Reports, developer version for Eclipse (version 13) 
  • SAP Crystal Reports Viewer 
  • OEM version of SAP Crystal Reports (included/embedded with a 3rd-party application), for example, SAP Crystal Reports for SAGE
I’m buying on behalf of someone else in my company. Can I purchase even though it’s the other person who is eligible to the upgrade discount?

Yes. If you are purchasing on behalf of a user who is eligible to SAP Crystal Reports 2016 as an upgrade, you may forward the acquired license key and download link for them to install with.

Is it OK to keep using an old version of SAP Crystal Reports when I want to also purchase SAP Crystal Reports 2016 with an upgrade discount?

Yes. There is no need to surrender the use of the old license of SAP Crystal Reports; you may still use the software and license for the older version at the same time as SAP Crystal Reports 2016 as an upgrade, but you are still under the Named User License for both versions. You may not reassign the license of the new version to someone else if you purchased with the upgrade discount.

Do I have to do anything to install SAP Crystal Reports 2016 purchased as an upgrade when I already have SAP Crystal Reports 2011 (or SAP Crystal Reports 2013) installed?

Yes. For users of SAP Crystal Reports 2011 or SAP Crystal Reports 2013, this software will need to be uninstalled before SAP Crystal Reports 2016 is installed to the same computer.

Can I buy an upgrade to SAP Crystal Reports 2016 and give my old version to someone else to use?

No. As the named user license holder of an older version, you cannot reassign the upgrade license to a different end user. The new user will need to buy their own, full license of SAP Crystal Reports 2016.

Can I purchase SAP Crystal Reports 2016 with an upgrade discount for each eligible version I have?

As an individual, if you have more than one eligible SAP Crystal Reports product, you are entitled to only a single (qty 1) named user license of SAP Crystal Reports 2016 as an upgrade.

I have an old application which has embedded reports I would like to modify or add to. Can I purchase SAP Crystal Reports 2016 as an upgrade for report design?

No, you would not be eligible to purchase SAP Crystal Reports 2016 as an upgrade from an application which uses a SAP Crystal Reports runtime engine; a new license of SAP Crystal Reports would be needed for report design.  

NOTE: Legacy applications which use a Crystal Reports runtime earlier than version 13 may require you to continue to use your older version of SAP Crystal Reports for creating and modifying reports run through that application. Check with your vendor/developer on your application’s compatibility with version 14.2 report files saved by SAP Crystal Reports 2016.

With SAP Crystal Reports 2016, can I use my existing reports from an older version of SAP Crystal Reports?

Yes, probably. Report files created with SAP Crystal Reports version 9 and higher should work the same with SAP Crystal Reports 2016. The process to migrate an older version report file (.rpt) is to open the file with SAP Crystal Reports 2016 (choose File>Open, rather than double-clicking the file in Windows Explorer), then Save. The report will save as a SAP Crystal Reports 2016 (version 14.2) .rpt file. You cannot ‘Save As’ with SAP Crystal Reports 2016 to save a version other than 14.2. Consider renaming the file before you save it with SAP C,rystal Reports 2016 to retain an original in case that earlier version is still needed.

Can I upgrade to SAP Crystal Server 2016 from a previous version of SAP Crystal Server?

Yes, if you are currently under a maintenance agreement for an earlier version of SAP Crystal Server you can upgrade at no extra cost through the SAP Service Marketplace. Please note that licensing and features of the previous version of SAP Crystal Server will be retained (see pages 14 and 15 of the SAP Crystal Licensing document for details.

What about upgrading to SAP Crystal Server 2016 for deployments without maintenance?

For customers of older versions of SAP Crystal Server not under maintenance, SAP Crystal Server 2016 1 Named User License is a new license type and has no upgrade path from previous Named User License deployments. There is no upgrade option for SAP Crystal Server 2016 5 Concurrent Access License; the purchase of a new license is required.

SAP Crystal solutions installation and use

Are you having trouble installing the software?

View following items for details.

  • Installation and set-up video
  • Crystal Reports Installation Instructions (simplified)
  • If your download does not match the files in that instruction, please initiate a chat with the SAP Store or contact your vendor. 
  • If you are still experiencing difficulties, please follow this guide:

    If you are still experiencing the INS00140 Error after following the above guides, it can be a conflict with third party software that uses the same .dll name for keycode decryption. Please follow these steps: 
  • Search the machine for all local instances of “Cryptocme2.dll” (to see what other software may be using it) 
  • Rename the *.dll extension of the identified cryptocme2.dll files, using OLD (for example) 
  • Reboot machine 
  • Log on as Admin account 
  • Run the installation again and it should pass the keycode check 
  • Rename cryptocme2.old files back to cryptocme2.dll
What if I have lost my license key?

If the customer still has their order information: Please contact your vendor to retrieve the license information.

If purchased from the online store, please engage the chat team at the SAP Store.

How can I retrieve a license key from a local machine?
  • First, open the program and go to the Help menu and select License Manager 
  • You will see a portion of your license key, write down those first few characters 
  • Next, start the Registry Editor by going to the Windows Start menu and selecting “Run” (or hold the 'Windows' key and press 'R') 
  • In the new open window, type in “regedit” and click “OK” 
  • Once RegEdit is open: Click on HKEY_LOCAL_MACHINE, press Ctrl+F (find) 
  • Enter the partial license you copied from the license manager and choose “find next” 
  • Search will find the key. Your code will show with the date of installation added to the end. Your code starts with the recorded 5 characters and ends with the last two shown in the License Manager. The Registry Editor path is likely to be: Computer>HKEY_LOCAL_MACHINE>SOFTWARE>WOW6432Node>SAP BusinessObjects>Suite Xi 4.0>Crystal Reports> Keycodes> CR Dev (ignore the semicolon and numbers - this is the date of installation)
What if I have lost my registration number?

For SAP Crystal Reports Xi, SAP Crystal Reports Xi R2 and SAP Crystal Reports 2008, please use generic registration number 8886909502 when prompted for your registration number.

What do SAP Crystal Solutions look like in use?

For a general idea of the capabilities and how Crystal Reports and Crystal Server look in action, visit this page.

Do you offer tutorials on how to use SAP Crystal Solutions?

Yes. You can access tutorials for SAP Crystal Reports and SAP Crystal Server, as part of the BI Platform family of technology.

Where can I access paid third party tutorials?

Access an expert' partner's useful formulas, guides for cross-tabs, sub-reports, parameters and more.

Did you get an INS00140 Error?

Please follow these steps: 

  • Search the machine for all local instances of “Cryptocme2.dll” (to see what other software may be using it) 
  • Rename the *.dll extension of the identified cryptocme2.dll files, using *.OLD (for example) 
  • Reboot machine 
  • Log on as Admin account 
  • Run the installation again and it should pass the keycode check 
  • Rename cryptocme2.old files back to cryptocme2.dll
How can I access crucial knowledge base information?

You can leverage the following link to get access to the most frequently consulted knowledge base articles.

Is it possible to edit the SQL generated by SAP Crystal Reports?

When you build a query, SAP Crystal Reports automatically generates the SQL (Structured Query Language) that corresponds to the query and saves it as a SAP Crystal SQL Command object. The SQL statement generated by crystal reports cannot be edited, but it can be viewed. In the Query Panel, click View SQL. The SQL dialog box appears. It contains the SQL that constitutes your query. Use this option when you want to check the SQL as you create a query. 

When creating a report, can you use your own SQL statements?

You can create your own SQL query by using the tool “SAP Crystal SQL Designer”. There you can insert your own SQL statement. It will be saved as a .qry file. To use it in a report, select the “Crystal SQL Statement” button instead of using the “Database” button. To maintain optimum report processing speeds, avoid using formulas (whether Crystal or Basic syntax) within record selection formulas. Instead, replace the original formula with an equivalent SQL Expression field, and then incorporate the SQL Expression field into your record selection formula. 

What chart types are available?

You can find the list of available chart types here.

Where can I find the complete user guide for SAP Crystal Reports 2016?

You can find the the user guide in English language and other languages such as Chinese, Dutch, French, German, Italian, Japanese, Korean, Russian, Spanish. 

Back to top