Symptom
- Where to find information about all the registry keys used in Crystal Reports?
- What are the registry keys that can affect how Crystal Reports works ?
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
- Crystal Reports Developer for Visual Studio
- SAP BusinessObjects Enterprise 4.x .NET SDK package
- Crystal Reports Server Embedded ( OEM ) ( same as BOE 4.1 )
Resolution
- This SAP Knowledge Base Article list all the Microsoft Registry keys used to change the behavior and functionalities of Crystal Reports.
WARNING: The following involves editing the registry. Using the Microsoft Registry Editor incorrectly can cause serious problems. Use the Microsoft Registry Editor at your own risk. For more information, see the SAP Knowledge Base Article 1323322
- Crystal Reports Registry Keys location:
HKEY_LOCAL_MACHINE : Applies to all users on the computer.
HKEY_CURRENT_USER : Applies only to the user currently logged on the computer.
Most of the Microsoft Registry keys found in the table below can be set in both locations.
If both location keys are set, Crystal Reports will take the value from HKEY_CURRENT_USER
- Microsoft Registry Keys base path for each version of Crystal Reports:
- For Crystal Reports 2013, 2016: ( 32bit )
- HKEY_LOCAL_MACHINE\Software\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\ (on 64 bit OS)
- HKEY_LOCAL_MACHINE\Software\SAP BusinessObjects\Suite XI 4.0\ (on 32 bit OS)
- HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\
- For Crystal Reports 2020: ( 64bit )
- HKEY_LOCAL_MACHINE\Software\SAP BusinessObjects\Suite XI 4.0\
- HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\
- For Crystal Reports for Visual Studio 2010 and above:
- HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0 (on 64 bit OS)
- HKEY_CURRENT_USER\Software\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0
- Note: Some of the Microsoft Registry keys are applicable to specific versions of Crystal Reports only, read the relevant SAP Knowledge Base Article.
|
Registry Key Name |
Values |
Used for |
SAP Knowledge Base Article |
...\Crystal Reports\ |
|
-Dhttps.protocols=TLSv1 |
to disable the SSL 3.0 or Configure Proxy |
|
...\Crystal Reports\ |
|
1 |
Disable auto update |
|
...\Crystal Reports\CheckForUpdates |
|
1 |
Disable auto update |
|
|
||||
...\Crystal Reports\Database\ |
|
Date, DateTime |
Date prompt format |
|
...\Crystal Reports\Database\ |
|
database server name, or the ODBC DSN name |
Date prompt format |
|
...\Crystal Reports\Database\ |
|
Yes, No |
Windows Integrated Security used with OLE DB |
|
...\Crystal Reports\Database\ |
|
100 |
Null date displays in Crystal Reports as 01/01/2001 when connecting to an IBM DB2 data source |
|
...\Crystal Reports\Database\ |
|
Dword: 1000 |
Query Panel list of Values limit |
|
...\Crystal Reports\Database\ |
|
Yes, No |
some special characters display incorrectly as random characters. |
|
...\Crystal Reports\Database\ |
|
.:{}()@&$#^!*~|%\\\" |
special characters not allowed to be used in table alias names |
|
...\Crystal Reports\Database\ |
|
Yes, 1 |
List of Values in Crystal Reports based off a Universe is not returning all values |
|
...\Crystal Reports\Database\ |
|
Yes, No |
extra and unneeded connections are made to database when the report is viewed |
|
...\Crystal Reports\Database\ QueryBuilder\JoinBuilder |
|
Driver file name without extension |
Change SQL Join syntax |
|
...\Crystal Reports\Database\ QueryBuilder\NameBuilder |
|
ODBC Driver file name without extension |
Name Builder builds the syntax for specific naming conventions of ODBC drivers |
|
...\Crystal Reports\Database\ QueryBuilder\ValueBuilder |
|
ODBC Driver file name without extension |
Value Builder builds the syntax for specific unicode drivers as well as other syntax related to Boolean values, date-time and wild card search characters of ODBC drivers |
|
...\Crystal Reports\Database\ QueryBuilder\ OuterJoinEscSeq
|
|
ODBC Driver file name without extension |
Change SQL Join syntax |
|
...\Crystal Reports\Database\ QueryBuilder\DateTimeEscSeq
|
|
ODBC Driver file name without extension |
Date Time Escape Sequence builds the syntax for ODBC drivers using date time identifiers like {d"} for date. |
|
...\Crystal Reports\Database\ QueryBuilder\StoredProcedureClauseBuilder
|
|
ODBC Driver file name without extension
|
Stored Procedure Clause Builder builds the syntax for calling stored procedures based on the ODBC drivers in use |
|
...\Crystal Reports\Database\ QueryBuilder\UnicodeConversionOptions |
|
ODBC Driver file name without extension
|
Always Unicode Conversion is used for ODBC Drivers which require Unicode strings to be prefixed with "N". |
|
...\Crystal Reports\Database\ QueryBuilder\WhereClauseBuilder |
|
ODBC Driver file name without extension
|
Sybase Where Clause Builder is used for Sybase ODBC Drivers which require the Sybase 'where' clause. |
|
...\Crystal Reports\Database\ODBC |
|
0 to 65534 |
Text field over 255 characters truncates |
|
...\Crystal Reports\Database\ODBC |
|
dword: 1 or 2 or 4 or 8 |
Change to uncommitted read ("dirty read") |
|
...\Crystal Reports\Database\ODBC |
|
dword:00000001 |
Open a Read/Write connection |
|
...\Crystal Reports\Database\ODBC |
|
name of the DLL for the specific database |
'Database Expert' allows cyclic links and many-to-one relationships |
|
...\Crystal Reports\Database\ODBC |
|
String : 0 or 1 |
the remote link synonym does not display |
|
...\Crystal Reports\Database\ODBC |
|
Yes, No |
stored procedure with a NVARCHAR field containing a number |
|
...\Crystal Reports\Database\ODBC |
|
xml |
Requirements to distribute runtime |
|
...\Crystal Reports\Database\ODBC |
|
2 |
Sybase closes second connection |
|
...\Crystal Reports\Database\ODBC |
|
name of ODBC Driver DLL |
aliases for tables with special characters or duplicate names |
|
...\Crystal Reports\Database\ORACLE |
|
Yes, No |
Non English data in Oracle connectivity |
|
...\Crystal Reports\Database\DAO\ |
|
Yes, No |
"Logon failed" with MA Access DAO connection |
|
...\Crystal Reports\Database\QueryEngine |
|
String : 0 or 1 |
Pervasive SQL database connection, created in an earlier version |
|
...\Crystal Reports\Database\Btrieve\ |
|
Yes, No |
sort settings are ignored in native Btrieve reports. |
|
...\Crystal Reports\Database\Btrieve\ |
|
Yes, No |
Pervasive database displays blank fields and inaccurate values |
|
...\Crystal Reports\Database\DB2\ |
|
Yes, No |
Unicode driver, crdb_db2cli.dll, incorrectly displays double-byte character set (DBCS) |
|
...\Crystal Reports\Database\DB2CLI\ |
|
0101/01/01 |
CR generates an incorrect date in a record selection when using "1/1/1" as the date |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
trailing spaces removed |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
Store settings from File > Options > Database tab |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
Store settings from File > Options > Database tab |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
Store settings from File > Options > Database tab |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
Viewer will not process the subreport until it is double-clicked |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
Do not Verify Stored Procedure |
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
stored procedure executes with null parameter values |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
Store settings from File > Options > Database tab |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
Store settings from File > Options > Database tab |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
Store settings from File > Options > Database tab |
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
Store settings from File > Options > Database tab |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
to turn off Smart Linking |
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
Store settings from File > Options > Database tab |
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
unable to export a query from the Info SQL Designer to any format |
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
‘Description’ |
Display a description of BW field |
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
dword:00000001 |
zero running totals appear as nulls values instead of zero values |
|
...\Crystal Reports\DatabaseOptions\ |
|
dword:00000001 |
zero running totals appear as nulls values instead of zero values |
|
...\Crystal Reports\DatabaseOptions\ |
|
|
|
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
change the parameters of a custom jdbc connection in a Crystal Report |
|
...\Crystal Reports\DatabaseOptions\ |
|
No |
blank password is passed to the database before the logon box appears |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
the number of decimal places set for Numeric type data fields is reset to zero |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
Forcing StarEqual Syntax With SQL Server |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
retrieving the number of columns in a large DB/2 table |
|
...\Crystal Reports\DatabaseOptions\ |
|
"(BSTR FunctionName([IN] BSTR inStr, [IN] VARIANT inUnknown))" |
launch a different query tool |
|
...\Crystal Reports\DatabaseOptions\ |
|
‘Yes’ or ‘No’ |
Convert Null Values |
|
...\Crystal Reports\DatabaseOptions\ |
|
0 or 1 |
This is for Crystal Reports for Visual Studio only. When setting location for your PC databast to Same As Report use this key - Default is the Users \Temp folder |
|
...\Crystal Reports\DatabaseOptions\ |
|
Yes, No |
To expose the native errorcode of the vendor |
|
...\Crystal Reports\DatabaseOptions\LOV |
|
Default: 1000 |
Increase limit for List of Values |
1218588, 1574483, 1270986, 1219715, 1716853, 1201072
|
...\Crystal Reports\DatabaseOptions\ODBC |
|
1 or 2 or 4 or 8 |
Change to uncommitted read ("dirty read") |
|
...\Crystal Reports\DatabaseOptions\ODBC |
|
Yes, No |
quotes around field and table names in the SQL statement |
|
...\Crystal Reports\DatabaseOptions\ODBC |
|
‘0’ or ‘1’ |
connection access mode to read-only |
|
...\Crystal Reports\DatabaseOptions\ODBC |
|
Yes, No |
Unicode characters support |
|
...\Crystal Reports\DatabaseOptions\Universe |
|
FilePath ie: c:\tmp\Querypanel.log |
enable logging for the Query Panel |
|
...\Crystal Reports\DatabaseOptions\OuterJoin |
|
ODBC Driver file name without extension |
Change Join syntax |
|
...\Crystal Reports\DatabaseServer |
|
Dword value |
not all of the data from the database is shown in parameter or browse field |
|
...\Crystal Reports\FetchOptions |
|
DWORD Value |
Max number of objects to get a listing of from the database. |
|
|
||||
...\Crystal Reports\Export\Excel |
|
dword:00000001 |
To export the object formatting for NULL values to MS Excel Data-Only format |
|
...\Crystal Reports\Export\Excel |
|
dword:00000001 |
Apply Wrap Text |
|
...\Crystal Reports\Export\Excel |
|
0 or 4 |
set the options for the DHTML viewer |
|
...\Crystal Reports\Export\Excel |
|
True |
headers do not appear in the exported document |
|
...\Crystal Reports\Export\CSV |
|
dword:00000001 |
Export report containing “umlaut” characters like: ä,ë,ï |
|
...\Crystal Reports\Export\CSV |
|
dword:00000001 |
the page header appears at the beginning of each record |
|
...\Crystal Reports\Export\CSV |
|
dword:00000001 |
Multibyte characters can't be exported to CSV properly from a Crystal Reports report |
|
...\Crystal Reports\Export\CSV |
|
dword:00000001 |
Null or empty values are not surrounded by delimiter when exported to CSV format |
|
...\Crystal Reports\Export\RTF |
|
dword:00000001 |
The exported hyphen character ASCII value should be 45 |
|
...\Crystal Reports\Export\RTF |
|
String: “0”, “1”… |
When exporting a report the font size is reduced |
|
...\Crystal Reports\Export\rtfeditable |
|
Yes, No |
exported file is blank If a page break has been inserted into the report |
|
...\Crystal Reports\Export\PDF |
|
dword:00000001 |
Fonts shrink by approximately 10% when a report is exported to Adobe Acrobat Format (PDF) |
|
...\Crystal Reports\Export\PDF |
|
dword:00000001 |
text fields are either truncated incorrectly, or the text is wrapped to the next line incorrectly |
|
...\Crystal Reports\Export\PDF |
|
Dword from 1 to 10 |
To adjust truncation |
|
...\Crystal Reports\Export\PDF |
|
dword:00000001 |
objects are truncated on the right |
|
...\Crystal Reports\Export\PDF |
|
dword:00000000 |
the file size of the exported PDF is larger. Crystal Reports containing Arabic text displayed incorrectly while exporting |
|
...\Crystal Reports\Export\PDF |
|
dword:00000001 |
Create bookmarks for subreport |
|
...\Crystal Reports\Export\Text\ |
|
dword:00000001 |
A blank line appears at the end of the text file |
|
...\Crystal Reports\Export\Text\ |
|
dword:00000001 |
blank lines are added between rows. |
|
...\Crystal Reports\Export\Text\ |
|
dword:00000001 |
Chinese characters show as question marks when exporting CR report to text |
|
...\Crystal Reports\Export\TextExport |
|
1 |
Dialog box to prompt for Characters per Inch does not prompt |
|
...\Crystal Reports\Export\TextExport |
|
dword:00000012 |
Formatting the report, while exporting the report to the Text format |
|
...\Crystal Reports\Export\CSV |
|
dword:00000001 |
Multibyte characters can't be exported to CSV properly |
|
...\Crystal Reports\Export\HTML\ |
|
no (this is case-sensitive) |
to execute JavaScript in a Crystal report by clicking a hyperlink when viewing a Crystal report in a DHTML viewer |
|
...\Crystal Reports\Export\ |
|
dword:00000064 |
on a Solaris operating system, charts are out of focus in reports viewed in the DHTML viewer |
|
...\Crystal Reports\Export\ |
|
file path as a String |
How to set a default path to save the file created after exporting to any format from Crystal Reports |
|
|
||||
...\Crystal Reports\FetchOptions |
|
Dword:008000 |
Increase number of database objects in Data explorer |
|
...\Crystal Reports\FetchOptions |
|
Yes, No |
Modify Database Expert Settings |
|
...\Crystal Reports\FormatOptions |
|
Yes, No |
ADO recordset that contains a very large memo field |
|
...\Crystal Reports\FormatOptions |
|
Yes, No |
Enable javascript hyperlink |
|
...\Crystal Reports\FormatOptions |
|
Yes, No |
modify the record selection formula, you are prompted to log on to the database |
|
...\Crystal Reports\Formula Workshop\Formula\ |
|
f000 |
Dock the dialog box or window |
|
...\Crystal Reports\Formula Workshop |
|
10,10,10,10 |
Formula Editor Window dialog out of the screen area |
|
...\Crystal Reports\Logging |
|
dword:00000003 |
turn on/off crpe logging for the Crystal Reports |
|
...\Crystal Reports\logging\ craxdrt.Diagnostics |
|
dword:00000003 |
enable/disable logging for the Report Designer Component (RDC) |
|
...\Crystal Reports\NewObject |
|
String : 0.0001 |
number fields are rounded at the first decimal position |
|
...\Crystal Reports\Recent Files |
|
FilePath, Report name |
Recently accessed information |
|
...\Crystal Reports\Reportview\ |
|
0x78 = 120 or 0xe = 14 |
Manually change Grid size or report Layout |
|
...\Crystal Reports\Reportview\ |
|
200 |
Change Batch size of LOV |
|
...\Crystal Reports\ResizableDialogs |
|
325,180,911,571 |
Window outside of the screen area |
|
...\Crystal Reports\SavedData |
|
Yes, No |
key that allows you to force Crystal Reports to save all data in a subreport |
|
...\Crystal Reports\SavedData |
|
Yes, No |
fields in the text objects are truncated |
|
...\Crystal Reports\SavedData |
|
'Yes', 'No' (Default), or '#' |
In Crystal Reports Web viewers, fields in the number objects are truncated |
|
...\Crystal Reports\SavedData |
|
Yes, No |
Print output is different |
|
...\Crystal Reports\StartPage |
|
Yes, No |
Disable Start Page |
|
…\LanguageOptions\ |
|
dword:00000409 |
How to change Preferred Viewing Locale (PVL) of Crystal Reports |
|
…\LanguageOptions\ |
|
dword:00000c09 |
How to change Preferred Viewing Locale (PVL) of Crystal Reports |
|
...\Crystal Reports\DesignerOptions |
|
dword:00000000 |
Use the same margins as the Report Designer uses in a .NET application with RAS |
|
|
||||
…\SAP\ |
|
c:\SAP_Logs |
Activate Trace |
|
…\SAP\Authentication |
|
Yes, No |
Activate Trace |
|
…\SAP\BW MDX Query Driver |
|
10000 |
Define Packet Size for MDX connection |
|
…\SAP\BW MDX Query Driver |
|
Yes, No |
Null values displayed as 0 |
|
…\SAP\BW MDX Query Driver |
|
Yes, No |
Activate Trace |
|
…\SAP\BW Publisher Service |
|
IP Address |
configure the BW Publisher |
|
…\SAP\BW Publisher Service |
|
Yes, No |
configure the BW Publisher |
|
…\SAP\BW Query Driver |
|
Yes, No |
Activate Trace |
|
…\SAP\BWQueryReportWrapper\ |
|
200 |
Not all values for a SAP variable are displayed |
|
…\SAP\CrystalExtension |
|
Yes, No |
Activate Trace |
|
…\SAP\Infoset Driver |
|
Yes, No |
Activate Trace |
|
…\SAP\ODS Driver |
|
Yes, No |
Activate Trace |
|
…\SAP\OpenSQL Driver |
|
Yes, No |
Activate Trace |
Keywords
CR, regkey
Yes, No |