SAP Knowledge Base Article - Public

2165260 - *** Master KBA *** List of Registry Keys used in Crystal Reports, Crystal Reports for Visual Studio and BOE 4.x .NET SDK to fix, change or correct behavior.

Symptom

Where to find Information about all the registry keys used in Crystal Reports?

Environment

  • Crystal Reports 9
  • Crystal Reports 10
  • Crystal Reports XI
  • Crystal Reports XI Release 2
  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • Crystal Reports Developer for Visual Studio
  • BusinessObjects Enterprise 4.x .NET SDK package
  • Crystal Reports Server Embedded ( OEM ) ( same as BOE 4.1 )

Resolution

This SAP Knowledge base article was created to list registry keys used to fix, correct or change behavior and functionalities of Crystal Reports.

 

***WARNING***: The following resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems. Use the Registry Editor at your own risk. Refer to KBA 1323322 for more information.

 

Crystal Reports Registry Keys Base Location:

Most of the Registry keys found in the table below could be set in both locations:  HKEY_LOCAL_MACHINE and HKEY_CURRENT_USER.

Registry settings in  HKEY_LOCAL_MACHINE applies to all Users on the machine, but the HKEY_CURRENT_USER applies only to the User currently logged in to the machine.

If both keys set, Crystal Reports will take the value from  HKEY_CURRENT_USER.

Registry Keys Base location according to version of Crystal Reports:

For Crystal Reports 9:

  • HKEY_LOCAL_MACHINE\Software\Crystal Decisions\9.0\
  • HKEY_CURRENT_USER\Software\Crystal Decisions\9.0\

For Crystal Reports 10:

  • HKEY_LOCAL_MACHINE\Software\Crystal Decisions\10.0\
  • HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\

For Crystal Reports XI:

  • HKEY_LOCAL_MACHINE\Software\Wow6432Node\Business Objects\Suite 11.0\ (on 64 bit OS)
  • HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.0\ (on 32 bit OS)
  • HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\

For Crystal Reports XI Release 2:

  • HKEY_LOCAL_MACHINE\Software\Wow6432Node\Business Objects\Suite 11.5\ (on 64 bit OS)
  • HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11.5\ (on 32 bit OS)
  • HKEY_CURRENT_USER\Software\ Business Objects\Suite 11.5\

For Crystal Reports 2008:

  • HKEY_LOCAL_MACHINE\Software\Wow6432Node\Business Objects\Suite 12.0\ (on 64 bit OS)
  • HKEY_LOCAL_MACHINE\Software\ Business Objects\Suite 12.0\ (on 32 bit OS)
  • HKEY_CURRENT_USER\ Software\ Business Objects\Suite 12.0\

For Crystal Reports 2011, Crystal Reports 2013, Crystal Reports 2016:

  • 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 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

Please Note, some of the registry keys are applicable to specific versions of Crystal Reports only, read the relevant SAP KBA.

Registry   key path (base location +) 

Registry   Key Name

Value

Used   for

SAP KBA

...\Crystal Reports\

  •   JVMOptions

“-Dhttps.protocols=TLSv1”

to disable the SSL 3.0

2092680

...\Crystal Reports\

  •   DisableCheckForUpdates

“1”

Disable auto update

1204702

...\Crystal Reports\CheckForUpdates

  •   DisableOnStartUp

“1”

Disable auto update

12047021368945

 

Registry Keys for Database Connectivity and returned records format

 

...\Crystal Reports\Database\

  •   DB2iSeriesUniversePromptType

Date, DateTime

Date prompt format

1202380

 

...\Crystal Reports\Database\

  •   useDateInsteadOfDateTime

database server name, or the ODBC DSN name

Date prompt format

12012802032630,   1204856, 1337842, 1362039

...\Crystal Reports\Database\

  •   useIntegratedSecurity

‘Yes’  or ‘No’

Windows Integrated Security used with OLE DB

1217766

 

...\Crystal Reports\Database\

  •   NumberOfYearToShift

100

Null date displays in Crystal Reports as 01/01/2001 when connecting to an IBM DB2 data source

12177851217956

 

...\Crystal Reports\Database\

  •   QPMaxLOVSize

Dword: 1000

Query Panel list of Values limit

1218573

 

...\Crystal Reports\Database\

  •   TranslateDOSStrings
  •   TranslateDOSMemos

‘Yes’ or ‘No’

some special characters display incorrectly as random characters.

1218654

...\Crystal Reports\Database\

  •   InvalidAliasCharList

.:{}()@&$#^!*~|%\\\"

special characters not allowed to be used in table alias names

1218839, 1874513

 

...\Crystal Reports\Database\

  •   AlwaysRefreshUniverseLOV

Yes, 1

List of Values in Crystal Reports based off a Universe is not returning all   values

1219958

...\Crystal Reports\Database\

  •   AvoidEmptyPasswordLogon

‘Yes’     or ‘No’

extra and unneeded connections are made to database when the report is   viewed

1220377, 2178997 

...\Crystal Reports\Database\

QueryBuilder\JoinBuilder

  •   OJSyntax
  •   StarEqualJoinBuilder
  •   SQLServerJoinBuilder
  •   InformixJoinBuilder
  •   OracleJoinBuilder
  •   OracleJoinBuilder2
  •   SybaseJoinBuilder
  •   DB2JoinBuilder
  •   LotusNotesJoinBuilder
  •   CannotSupportExternalJoins

Driver file name without extension

Change SQL Join syntax

12178201181187,   12126981976296,   12019431218727, 1785343, 1976296

...\Crystal Reports\Database\

QueryBuilder\NameBuilder

  •   SQLServerNameBuilder
  •   InformixNameBuilder
  •   OracleNameBuilder
  •   SybaseNameBuilder
  •   AccessNameBuilder
  •   DB2NameBuilder
  •   DoubleQuotation
  •   BackQuotation
  •   SquareBracket
  •   NoQuotes
  •   Dot
  •   AtSign
  •   Colon

ODBC Driver file name without extension

Name Builder builds the syntax for specific naming conventions of ODBC drivers

1217820, 1202064, 12035341216295, 2050922, 2117215

...\Crystal Reports\Database\

QueryBuilder\ValueBuilder

  •   SQLServerValueBuilder
  •   SQLServer65ValueBuilder
  •   InformixValueBuilder
  •   OracleValueBuilder
  •   OracleValueBuilder2
  •   SybaseValueBuilder
  •   AccessValueBuilder
  •   DAOAccessValueBuilder
  •   DB2ValueBuilder

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

1217820

 

...\Crystal Reports\Database\

QueryBuilder\ OuterJoinEscSeq

 

  •   MSOuterJoinEscSeq
  •   NoOuterJoinEscSeq

ODBC Driver file name without extension

Change SQL Join syntax

1217820, 1196470, 1199192 

...\Crystal Reports\Database\

QueryBuilder\DateTimeEscSeq

 

  •   MSDateTimeEscSeq1
  •   MSDateTimeEscSeq2

ODBC Driver file name without extension

Date Time Escape Sequence builds the syntax for ODBC drivers using date   time   identifiers like {d"} for date.

1217820

 

...\Crystal Reports\Database\

QueryBuilder\StoredProcedureClauseBuilder

 

  •   DefaultStoredProcedureClauseBuilder
  •   SQLServerStoredProcedureClauseBuilder
  •   InformixStoredProcedureClauseBuilder
  •   OracleStoredProcedureClauseBuilder
  •   SybaseStoredProcedureClauseBuilder
  •   AccessStoredProcedureClauseBuilder
  •   DB2StoredProcedureClauseBuilder
  •   PSFTStoredProcedureClauseBuilder

ODBC Driver file name without extension

 

Stored Procedure Clause Builder builds the syntax for calling stored procedures  based on the ODBC drivers in use

1217820

 

 

 

...\Crystal Reports\Database\

QueryBuilder\UnicodeConversionOptions

  •   AlwaysUnicodeConversion

ODBC Driver file name without extension

 

Always Unicode Conversion is used for ODBC Drivers which require Unicode strings to be prefixed with "N".

1217820

 

...\Crystal Reports\Database\

QueryBuilder\WhereClauseBuilder

  •   SybaseWhereClauseBuilder

ODBC Driver file name without extension

 

Sybase Where Clause Builder is used for Sybase ODBC Drivers which require the Sybase 'where' clause.

1217820

 

...\Crystal Reports\Database\ODBC

  •   MapMaxTypeToString

0 to 65534

Text field over 255 characters truncates

1256215, 1422831

 

...\Crystal Reports\Database\ODBC

  •   IsolationLevel

dword: 1 or 2 or 4 or 8

Change to uncommitted read ("dirty read")

1183629, 1199763,

1216415

 

...\Crystal Reports\Database\ODBC

  •   AccessMode

dword:00000001

Open a Read/Write connection

1197846, 1621593, 18391511883150

...\Crystal Reports\Database\ODBC

  •   AvoidCyclicSmartLinks
  •   AvoidManyToOneSmartLinks

name of the DLL for the specific database

'Database Expert' allows cyclic links and many-to-one relationships

1214577

...\Crystal Reports\Database\ODBC

  •   AutoCommit

String : 0 or 1

the remote link synonym does not display

1216704

 

...\Crystal Reports\Database\ODBC

  •   FetchStordProcSchemaOnlyAfterExecution

‘Yes’ or ‘No’

stored procedure with a NVARCHAR field containing a number

1216758

...\Crystal Reports\Database\ODBC

  •   TreatMemoAsString

"xml"

Requirements to distribute runtime

1217235

 

...\Crystal Reports\Database\ODBC

  •   ODBC Behavior

“2”

Sybase closes second connection
Any ANSI 89 ( ODBC 2 Standard ) driver support

1216130

 

...\Crystal Reports\Database\ODBC

  •   UseTableNameAsAlias

name of ODBC Driver DLL

aliases for tables with special characters or duplicate names

1618336

...\Crystal Reports\Database\ORACLE

  •   UseOSLocaleForConversion

‘Yes’ or ‘No’

Non  English data in Oracle connectivity

1217515, 1220023

...\Crystal Reports\Database\DAO\

  •   IsThreadSafe

‘Yes’  or ‘No’

"Logon failed" with MA Access DAO connection

1217210, 1218154

 

...\Crystal Reports\Database\QueryEngine

  •   AllAtOnce_BackwardCompatible

String : 0 or 1

Pervasive SQL database connection, created in an earlier version

1207420, 1952354

 

...\Crystal Reports\Database\Btrieve\

  •   DoNotPushDownSorting

‘Yes’ or ‘No’

sort settings are ignored in native Btrieve reports.

1218730

 

...\Crystal Reports\Database\Btrieve\

  •   DoNotPadWithBlanksToFillCharColumns

‘Yes’ or ‘No’

Pervasive database displays blank fields and inaccurate values

1220301, 1220396, 1873343

 

...\Crystal Reports\Database\DB2\

  •   UseOSLocaleForConversion

‘Yes’ or ‘No’

Unicode driver, crdb_db2cli.dll, incorrectly displays double-byte character   set   (DBCS)

1219704

...\Crystal Reports\Database\DB2CLI\

  •   CustomDateMap

“0101/01/01”

CR     generates an incorrect date in a record selection when using     "1/1/1" as the date

1220288

...\Crystal Reports\DatabaseOptions\

  •   TrimTrailingSpace

‘Yes’ or ‘No’

trailing spaces removed

1926391, 1284188,   16884711203739, 1220398, 1220462

...\Crystal Reports\DatabaseOptions\

  •   BrowseDistinct

‘Yes’ or ‘No’

 

 

...\Crystal Reports\DatabaseOptions\

  •   SortTableNames

‘Yes’ or ‘No’

Store settings from File > Options > Database tab

 

...\Crystal Reports\DatabaseOptions\

  •   ConvertOtherNullsToDefault

‘Yes’ or ‘No’

 

 

...\Crystal Reports\DatabaseOptions\

  •   DoAsyncQuery

‘Yes’  or ‘No’

Store settings from File > Options > Database tab

 

...\Crystal Reports\DatabaseOptions\

  •   VerifyWhenDBDriverUpgraded

‘Yes’ or ‘No’

Store settings from File > Options > Database tab

1215755

...\Crystal Reports\DatabaseOptions\

  •   ViewOutOfPlaceSubreports

‘Yes’ or ‘No’

Viewer will not process the subreport until it is double-clicked

1210698

...\Crystal Reports\DatabaseOptions\

  •   VerifyStoredProceduresOnSetLocation

‘Yes’ or ‘No’

Do not Verify Stored Procedure

1218627

...\Crystal Reports\DatabaseOptions\

  •   DatabaseSelector

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   AutoExpandCurrentConnection

‘Yes’ or ‘No’

 

 

...\Crystal Reports\DatabaseOptions\

  •   DontVerifyAttachedRecordset

‘Yes’ or ‘No’

stored procedure executes with null parameter values

1215998

...\Crystal Reports\DatabaseOptions\

  •   VerifyStoredProceduresOnFirstRefresh

‘Yes’ or ‘No’

Store settings from File > Options > Database tab

 

...\Crystal Reports\DatabaseOptions\

  •   ShowAllHeadersOnDrillDown

‘Yes’ or ‘No’

 

 

...\Crystal Reports\DatabaseOptions\

  •   SkipServerTypeDialog

‘Yes’ or ‘No’

 

 

...\Crystal Reports\DatabaseOptions\

  •   DataDirectory

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   MapFieldsByOrdinalForAttachedRecordset

‘Yes’ or ‘No’

 

 

...\Crystal Reports\DatabaseOptions\

  •   AlwaysSortLocally

‘Yes’ or ‘No’

 

 

...\Crystal Reports\DatabaseOptions\

  •   SortFieldNames

‘Yes’ or ‘No’

Store settings from File > Options > Database tab

 

...\Crystal Reports\DatabaseOptions\

  •   ConvertDatabaseNullToDefault

‘Yes’ or ‘No’

Store settings from File > Options > Database tab

 

...\Crystal Reports\DatabaseOptions\

  •   CommandDLLPath

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   DatabaseDLLPath

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   DefaultDictionary

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   AllowMultipleLinkPaths

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   CloseConnectionAfterFirstPass

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   DontChangeJoinType

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   VerifyOnFirstRefresh

 

Store settings from File > Options > Database tab

 

...\Crystal Reports\DatabaseOptions\

  •   DoAutoSmartLinking

‘Yes’ or ‘No’

to turn off Smart Linking

1216993, 1215242

...\Crystal Reports\DatabaseOptions\

  •   NeverShowUniverseWarningAgain

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   SuppressPrintingIfNoRecordsSelected

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   CaseSensitiveSQLData

‘Yes’ or ‘No’

Store settings from File > Options > Database tab

 

...\Crystal Reports\DatabaseOptions\

  •   DontAutoConvertODBC

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   DataExplorerDatabaseOrder

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   IndexSpeed

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   GroupingOnServer

‘Yes’ or ‘No’

unable to export a query from the Info SQL Designer to any format

1214536

...\Crystal Reports\DatabaseOptions\

  •   SaveDataWithReport

 

 

 

...\Crystal Reports\DatabaseOptions\

  • SaveSummariesWithReport

 

 

 

...\Crystal Reports\DatabaseOptions\

  • DisplayDBFieldBy

‘Description’

Display a description of BW field

1528555

...\Crystal Reports\DatabaseOptions\

  • LinkMethod

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   MaxRecordsToRead

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   OverrideConvertDatabaseNullsToDefault

dword:00000001

zero running totals appear as nulls values instead of zero values

1218603

...\Crystal Reports\DatabaseOptions\

  •   OverrideConvertOtherNullsToDefault

dword:00000001

zero running totals appear as nulls values instead of zero values

1218603

...\Crystal Reports\DatabaseOptions\

  •   ViewTimeDynamicUniversePrompt

 

 

 

...\Crystal Reports\DatabaseOptions\

  •   MergeConnectionProperties

‘Yes’ or ‘No’

change the parameters of a custom jdbc connection in a Crystal Report

1253672, 1357877, 14450671220164

...\Crystal Reports\DatabaseOptions\

  •   AlwaysAttemptOlapLogon

‘No’

blank password is passed to the database before the logon box appears

1215804

...\Crystal Reports\DatabaseOptions\

  •   SYBASE

‘Yes’ or ‘No’

the     number of decimal places set for Numeric type data fields is reset to   zero

1215627

...\Crystal Reports\DatabaseOptions\

  •   UseStarEqualForSqlSrv

‘Yes’ or ‘No’

Forcing StarEqual Syntax With SQL Server

1210183

...\Crystal Reports\DatabaseOptions\

  •   UseDb2SysTable

‘Yes’ or ‘No’

retrieving the number of columns in a large DB/2 table

1213529

...\Crystal Reports\DatabaseOptions\

  •   QueryBuilderProgID

  •   QueryBuilderFunctionName

"(BSTR     FunctionName([IN] BSTR inStr, [IN] VARIANT inUnknown))"

launch a different query tool

1214074

...\Crystal Reports\DatabaseOptions\

  •   ConvertNullToDefault

‘Yes’  or ‘No’

Convert Null Values

1214313

 

...\Crystal Reports\DatabaseOptions\

  •  DataFileSameAsReportPath

 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

2298839

...\Crystal Reports\DatabaseOptions\

  •  ReturnVendorError

 ‘Yes’  or ‘No’

To expose the native errorcode of the vendor

2502573

...\Crystal Reports\DatabaseOptions\LOV

  •   MaxRowsetRecords

Default: 1000

Increase limit for List of Values

17822011255514,   12185881574483, 1270986, 1219715, 1716853, 1201072 

 

...\Crystal Reports\DatabaseOptions\ODBC

  •   IsolationLevel

1 or 2 or 4 or 8

Change to uncommitted read ("dirty read")

1212066, 1213635, 1213590

...\Crystal Reports\DatabaseOptions\ODBC

  •   IdentifierQuoted

‘Yes’ or ‘No’

quotes around field and table names in the SQL statement

1214140

...\Crystal Reports\DatabaseOptions\ODBC

  •   SQL_ATTR_ACCESS_MODE

‘0’ or ‘1’

connection access mode to read-only

12133501214176   1213373

 

...\Crystal Reports\DatabaseOptions\ODBC

  •   SupportUnicodeFetch

‘Yes’ or ‘No’

Unicode characters support

1214428

 

...\Crystal Reports\DatabaseOptions\Universe

  •   QPLog

FilePath ie: c:\tmp\Querypanel.log

enable logging for the Query Panel

1217775

...\Crystal Reports\DatabaseOptions\OuterJoin

  •   OJSyntax
  •   Informix
  •   StarEqual
  •   OpenIngres
  •   SpecialDll
  •   PlusJoinDBMS
  •   StarJoinDBMS
  •   Sql2JoinDBMS
  •   AccessDriver
  •   SimbaDriver

ODBC Driver file name without extension

Change Join syntax

1875946

...\Crystal Reports\DatabaseServer

  •   BrowseTimeout
  •   MaxNBrowseValues
  •    

Dword value

not all of the data from the database is shown in parameter or browse field

12119021213724, 2111806

  Registry Keys used for Exporting Reports

 

...\Crystal Reports\Export\Excel

  •   KeepObjectFormattingWhenNullValue

dword:00000001

To export the object formatting for NULL values to MS Excel Data-Only   format

1972949

...\Crystal Reports\Export\Excel

  •   WrapTextInDataOnly

dword:00000001

Apply Wrap Text

1204189

...\Crystal Reports\Export\Excel

  •   ColumnWidthBaseArea

0 or 4

set the options for the DHTML viewer

1217559

...\Crystal Reports\Export\Excel

  •   ExportColumnHeaders

True

headers do not appear in the exported document

1218265

...\Crystal Reports\Export\CSV

  •   IncludeUTF8BOM

dword:00000001

Export report containing “umlaut” characters like: ä,ë,ï

13711431276013

 

...\Crystal Reports\Export\CSV

  •   AreaExportOptions

dword:00000001

the page header appears at the beginning of each record

12167701196142, 1219510

...\Crystal Reports\Export\CSV

  •   UTF16Mode

dword:00000001

Multibyte characters can't be exported to CSV properly from a Crystal Reports   report

1278932

...\Crystal Reports\Export\CSV

  •   DelimiterEmptyString

dword:00000001

Null or empty values are not surrounded by delimiter when exported to CSV   format

1451960

...\Crystal Reports\Export\RTF

  •   UseOriginalHyphen

dword:00000001

The exported hyphen character ASCII value should be 45

1670482

...\Crystal Reports\Export\RTF

  •   ReduceFontSizeBy

String: “0”, “1”…

When exporting a report the font size is reduced

1810847

...\Crystal Reports\Export\rtfeditable

  •   EliminateBlankLinesToFitPage

‘Yes’ or ‘No’

exported file is blank  If a page break has been inserted into the report

1219959

...\Crystal Reports\Export\PDF

  •   ForceLargerFonts

dword:00000001

Fonts shrink by approximately 10% when a report is exported to Adobe Acrobat   Format   (PDF)

16445631643979,   1206087, 1218518, 12187531220516,   1835763, 1378632, 1752610, 1828347, 1969209, 1849961

...\Crystal Reports\Export\PDF

  •  UsePrecisePositioningForText 

dword:00000001

text fields are either truncated incorrectly, or the text is wrapped to the next line incorrectly

14359911835763

 

...\Crystal Reports\Export\PDF

  •  TruncationAdjustment

Dword from 1 to 10

 To     adjust truncation

14359911835763

 

...\Crystal Reports\Export\PDF

  •  UseCustomEncoding

dword:00000000

the     file size of the exported PDF is larger. Crystal Reports containg   Arabic text   displayed incorrectly while exporting

11823911542287

...\Crystal Reports\Export\Text\

  •  SuppressTrailingNewlines

dword:00000001

A blank line appears at the end of the text file

12193191856530

...\Crystal Reports\Export\Text\

  •  Force255TwipLineHeight

dword:00000001

blank lines are added between rows.

1219323 ,  1843997

...\Crystal Reports\Export\Text\

  •  UseUTF8Encoding

dword:00000001

Chinese characters show as question marks when exporting CR report to text

13814981804874

...\Crystal Reports\Export\TextExport

  •  PromptAgain

1

Dialog box to prompt for Characters per Inch does not prompt

12602951213543

...\Crystal Reports\Export\TextExport

  •  CharperInch

dword:00000012

Formatting the report, while exporting the report to the Text format

1206068, 1213543, 1213950

...\Crystal Reports\Export\CSV

  •  UTF16Mode

dword:00000001

Multibyte characters can't be exported to CSV properly

1278932

...\Crystal Reports\Export\HTML\

  •  EncodeHTMLForSingleLineFieldObjects

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

12192981217939

...\Crystal Reports\Export\

  •  BitMapMagnifDenominator

dword:00000064

on a   Solaris   operating system, charts are out of focus in reports viewed in  the DHTML viewer

1218828

...\Crystal Reports\Export\

  •  ExportDirectory

file path as a String

How to set a default path to save the file created after exporting to any format from Crystal Reports

1257222

 

Other   Registry Keys

 

...\Crystal Reports\FetchOptions

  •   NTablesMax

Dword:008000

Increase number of database objects in Data explorer

12137981215994

...\Crystal Reports\FetchOptions

  • IncludeStoredProcedure
  • IncludeSynonym
  • IncludeBaseTable
  • IncludeSystemTable

 

‘Yes’ or ‘No’

 Modify Database Expert Settings

2572686

...\Crystal Reports\FormatOptions

  •   ThinningOutPageStartInfo

‘Yes’ or ‘No’

ADO recordset that contains a very large memo field

1218195

...\Crystal Reports\FormatOptions

  •   DisableScriptsInHyperlinks

‘Yes’ or ‘No’

Enable javascript  hyperlink

1219527, 1219736

...\Crystal Reports\FormatOptions

  •   IgnoreSharedVarStateInLinkedSubRpt

‘Yes’ or ‘No’

modify the record selection formula, you are prompted to log on to the   database

12202951220426

...\Crystal Reports\Formula Workshop\Formula\

  •   DockingStyle

f000

Dock the dialog box or window

12708051215919

...\Crystal Reports\Formula Workshop

  •   Editor   Position

10,10,10,10

Formula Editor Window dialog out of the screen area

1374826, 2039868

...\Crystal Reports\Logging

  •   Destinations
  •   LogErrorsOnly
  •   Position

dword:00000003

turn on/off crpe logging for the Crystal Reports

1470978

...\Crystal Reports\logging\

craxdrt.Diagnostics

  •   Destinations
  •   LogErrorsOnly
  •   Position

dword:00000003

enable/disable logging for the Report Designer Component (RDC)

1477457

...\Crystal Reports\NewObject

  •   Numeric   Rounding Type

String : 0.0001

number fields are rounded at the first decimal position

12179651369014

...\Crystal Reports\Recent Files

  •   FileX
  •   CaptionX
  •   TooltipX

FilePath, Report name

Recently accessed information

1680994

...\Crystal Reports\Reportview\

  •   Gridsize

0x78 = 120 or 0xe = 14

Manually change Grid size or report Layout

12193571220455

...\Crystal Reports\Reportview\

  •   PromptingLOVBatchSize

200

Change Batch size of LOV

13813611311541,   18807051652210

...\Crystal Reports\ResizableDialogs

  •   Highlighting Expert

325,180,911,571

Window outside of the screen area

1200031

...\Crystal Reports\SavedData

  •   GenerateDataForAllSubreportInstances

‘Yes’ or ‘No’

key that allows you to force Crystal Reports to save all data in a   subreport

12182921210698, 1219195, 1793542

...\Crystal Reports\SavedData

  •   TruncateClippedFieldStrings

‘Yes’ or ‘No’

fields in the text objects are truncated

12177711218653, 1218120

...\Crystal Reports\SavedData

  •   ComplexScriptSupport

‘Yes’ or ‘No’

Print output   is different

1218295

...\Crystal Reports\StartPage

  •   Show   Online Resources

‘Yes’ or ‘No’

 Disable Start Page

1534868, 1370033

…\LanguageOptions\

  •   ProductLocale

dword:00000409

How to change Preferred Viewing Locale (PVL) of Crystal Reports

1969993

…\LanguageOptions\

  •   PreferredViewingLocale

dword:00000c09

How to change Preferred Viewing Locale (PVL) of Crystal Reports

1969993

 

SAP  Integration Kit Registry Keys

 

…\SAP\

  •   TraceDir

c:\SAP_Logs

Activate Trace

12200851650292, 2000028

…\SAP\Authentication

  •   Trace

‘Yes’ or ‘No’

Activate Trace

 

…\SAP\BW MDX Query Driver

  •   PacketSize

10000

Define Packet Size for MDX connection

1767542, 1574460, 1768046

…\SAP\BW MDX Query Driver

  •   TreatSAPNULLAsDatabaseNULL

‘Yes’ or ‘No’

Null values displayed as 0

1930599, 1404878, 2065574

…\SAP\BW MDX Query Driver

  •   Trace

‘Yes’ or ‘No’

Activate Trace

1220085, 1650292, 2000028

…\SAP\BW Publisher Service

  •   GwHost

IP Address

configure the BW Publisher

1757239

…\SAP\BW Publisher Service

  •   CloneConnections

‘Yes’ or ‘No’

configure the BW Publisher

1219218

…\SAP\BW Query Driver

  •   Trace

‘Yes’ or ‘No’

Activate Trace

1220085, 1650292

…\SAP\BWQueryReportWrapper\

  •   MaxPickListSize

200

Not all values for a SAP variable are displayed

12630411219701

…\SAP\CrystalExtension

  •   Trace

‘Yes’ or ‘No’

Activate Trace

1650292

…\SAP\Infoset Driver

  •   Trace

‘Yes’ or ‘No’

Activate Trace

1220085, 1650292

…\SAP\ODS Driver

  •   Trace

‘Yes’ or ‘No’

Activate Trace

1220085, 1650292

…\SAP\OpenSQL Driver

  •   Trace

‘Yes’ or ‘No’

Activate Trace

1220085, 1650292

 

 

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports, developer version for Microsoft Visual Studio