Formula field tree that won’t dock

Sunday 1 November 2009 @ 9:26 am

Several of my customers have had docking problems and I have always known that the solution was in the registry, but because of the way the registry entries are named, it has been hit or miss to figure out the solution. So when I found some articles in the SAP/BO KB for solving these problems I decided to share them. They are all very similar solutions but there are some differences in the details.

Versions 11 and 12:
If a window in the formula editor won’t dock, start with the simple option. First right-click in the middle of the window and make sure that “Allow Docking” is checked. Then double click on the window title bar and see if that puts it into place. If this doesn’t work you will have to go into the registry, which is something that you should do very carefully, and after creating a restore point for your system or backing up the registry. Close Crystal Reports first and then follow these steps:

1.Open the Registry Editor and go to:
HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\Formula Workshop\Formula\
HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Formula Workshop\Formula\

2. Then depending on which window is floating:

  • Select ToolBar-Bar1 (Field Tree)
  • Select ToolBar-Bar2 (Function Tree)
  • Select ToolBar-Bar3 (Operator Tree)

4.On the right locate DockingStyle and set it to f000.
5. Also locate MRUDockingState and set it to 0.
6.Last reopen CR and the Formula Editor and then double click on the floating window

If you are using an older version of Crystal the process is similar, but:

  • the double-click doesn’t dock the window, you have to drag it
  • there is only one key to change, not two
  • and the toolbar numbers are different

In Version 10 use the registry key:
HKEY_CURRENT_USER\SOFTWARE\Crystal Decisions\10.0\Crystal Reports\Formula Workshop\Formula\

In Version 9 use the registry key
HKEY_CURRENT_USER\SOFTWARE\Crystal Decisions\9.0\Crystal Reports\Formula Workshop\Formula\

In Version 8.x use the registry key:
HKEY_CURRENT_USER\SOFTWARE\Seagate Software\Crystal Reports\Dialogs\

The field trees for these three version are different from those above:

  • Select ToolBar-Bar2 (Field Tree)
  • Select ToolBar-Bar3 (Function Tree)
  • Select ToolBar-Bar4 (Operator Tree)

And for all of these versions you make only one change:

Right-click the ‘DockingStyle’ Key, and then click ‘Modify’.
In ‘Value data’ enter:  f000

(For examples of my most popular formulas, please visit the FORMULAS page on my website.)

Leave a Reply

Recrystallize Pro