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

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.

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

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.
     
    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.
        
       Dock - 02.png 
         
        
    2. Drag the Field Tree window to where you want it to dock.
        
       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 BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016