Wednesday 17 November 2010

Formula Editor Selectors That Refuse To Dock

If you have ever had the urge to rip one of the tree selectors from the Formula Editor dock: big mistake.  The first thing you will notice is that it offers no benefit being a floating window, if anything it's annoying and gets in the way.  The second thing, you will try and put it back.  This is where the real problem manifests itself.

To put it simply; you can't.  Double clicking, trying to push the window back, verbal abuse - none of these work.


Fortunately I have done the legwork for you.  After a combination of investigation and experimentation I have compiled the following to hopefully resolve this issue once and for all.

Warning : Before editing the registry in some of the resolutions below I advise you back it up first and create a restore point.  The fixes have been tested - but you can't be too careful.

Version 12
Plan A
First off, let's make sure you've got a problem.  Right-click in the middle of the window and make sure you have 'Allow Docking' selected.  Once confirmed then double click on the window title bar and see if that does the job.

Plan B
Make sure Crystal Reports is closed.
Click START/RUN and type in 'regedit' and hit enter.  Then navigate to :

HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\Formula Workshop\Formula\

Right click on 'MRUDockingState', select 'Modify' and change its setting to '0'.

Now, depending on which pane won't dock change the 'Docking Style' to 'f000' (Hex).

Field Tree                ToolBar-Bar1
Function Tree         ToolBar-Bar2
Operator Tree          ToolBar-Bar3

Finally reopen Crystal Reports, open a Formula Editor and double click on the floating window.

Version 11
Same as above except the regkey is:

HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\Formula Workshop\Formula\

NOTE : For older versions the tree references are as follows and you only have to alter the 'Docking Style' again to 'f000'.

Field Tree                ToolBar-Bar2
Function Tree         ToolBar-Bar3
Operator Tree          ToolBar-Bar4

Version 10
HKEY_CURRENT_USER\SOFTWARE\Crystal Decisions\10.0\Crystal Reports\Formula Workshop\Formula\


Version 9
HKEY_CURRENT_USER\SOFTWARE\Crystal Decisions\9.0\Crystal Reports\Formula Workshop\Formula\


Version 8
HKEY_CURRENT_USER\SOFTWARE\Seagate Software\Crystal Reports\Dialogs\


Sources :
http://forums.sdn.sap.com/thread.jspa?threadID=1492258
http://www.sdn.sap.com/irj/scn/advancedsearch?query=1270805
http://www.sdn.sap.com/irj/scn/advancedsearch?query=1215919

3 comments:

  1. Paul, you should cite one more source - the blog post where this material originated:

    http://kenhamady.com/cru/archives/814

    I am trying to figure out exactly what your 'legwork' added to the original material.

    ReplyDelete
  2. Hi kendataman,

    I hadn't had the privilege of coming across the article you mentioned.

    My sources were as stated, and as you can see from their date-time stamps, they preceded and therefore supersed your post.

    It's all good if it helps at all decipher the wonders of Crystal Reports.

    Kind regards,

    Paul

    ReplyDelete
  3. The sources would have to predate my article, since they were listed as MY sources. So not only were the articles virtually identical, you then cited the exact same 3 sources, in the exact same position, in the exact same order. Not one more or less. Most blog posts like this don't even cite sources, so it is an amazing coincidence that both of us chose to list sources, and then cited the exact same ones, on articles that are virtually identical. But mine was one year earlier than yours and is one of hundreds of Crystal articles I have written. Some coincidence.

    ReplyDelete