1206001 - How to disable the Field Hierarchy feature in Crystal Reports

SAP Knowledge Base Article - Public

1206001 - How to disable the Field Hierarchy feature in Crystal Reports

Symptom

In Crystal Reports XI Release 2, a new feature called Field Hierarchy was introduced.

With this feature, if your database field name contains a hyphen ( - ) it will consider the name before the hyphen a folder, and the name after the hyphen the database field name in the Field Explorer.

For example, if you have database fields name like:

   Customer - Last Name
   Customer - First Name

Then Customer will become a folder, under which will appear the database field name. When viewing the content of a table in the Field Explorer, you will see the following:

Table Name
- Customer
     - Last Name
     - First Name
 
How can you disable this functionality so you can see the database fields as they appeared before XI Release 2? For example:

Table Name
   Customer - Last Name
   Customer - First Name

Resolution

There is not an option to turn off this functionality, but you can change the default character used as the delimiter to something that none of your database fields use which will have a similar result to disabling the feature.

To do so, change the hyphen characters found in the following registry sub key:

HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\Docking2\Field Explorer\GroupFieldDelimiter
 
to a value that you are not likely to have in a database field name. For example: %, ^, &, ~.

Keywords

Crystal Reports, Field Hierarchy, Disable, Field Explorer, hyphen , 8908576 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2