SAP Knowledge Base Article - Public

2039868 - Unable to dock the Field Tree in the Formula Editor in Crystal Reports

Symptom

  • Field tree window is undocked in Formula Editor.
  • Unable to dock Field Tree in Crystal Reports Formula Editor.
       
        
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
  • SAP Crystal Reports 2025

Reproducing the Issue

  1. In Crystal Reports designer, open a report.
  2. Edit a formula.
  3. In the Formula Workshop, right click the Field Tree button in the top menu, and uncheck the option "Allow Docking"
  4. Notice the Field Tree window is undocked.
     
    Unable_To_Dock_01.png

Resolution

  • To dock the Field Tree window in the Formula Workshop in Crystal Reports designer:
      
    1. In the Field Tree window, right-click and make sure "Allow Docking" has a check in front of it.
        
       Unable_To_Dock_02.png
         
        
    2. Drag the Field Tree window to where you want it to dock.
        
       Unable_To_Dock_03.png

 

  • If you are having difficultes docking the Field Tree window, then a second option will be to remove the settings from User Profile in the registry for the Formula Workshop.
       
    ***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 the SAP Knowledge Base Article 1323322 for more information.
    1. Close Crystal Reports designer.
       
    2. Open the Microsoft Registry Editor (regedit)
       
    3. Navigate to the folder:  
        
        HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Formula Workshop
         
    4. Backup the content of the folder, by right-clicking on the folder: Formula Workshop, and select Export.
       
    5. Enter a name and the location for the back-up copy of the folder.
       
    6. Delte the folder. To do so, right-click on the folder Formula Workshop and select "Delete"
        
    7. Start Crystal Reports designer and Formula Workshop objects should all now be at their default location.

Keywords

Docking, fix position, landing, window, tool bar , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025