SAP Knowledge Base Article - Public

1374826 - Formula Editor window disappears in Crystal Reports

Symptom

  • Using Crystal Reports Designer with a dual monitor where the reports created on one monitor (display) and while editing a formula in the report the Formula Editor (Formula Workshop) window opens on other monitor (display).
  • When the second monitor is removed the Formula editor window does not display in the first monitor
  • Crystal Reports being used on a dual monitor goes unresponsive when the formula editor is opened
  • When clicking on the conditional formatting button of any field, the formula editor does not open up
  • The Formula Editor which earlier used to show up on the Main/Secondary display is off-screen
  •  

Environment

  • Crystal Reports XI R2 (All Patch levels)
  • Crystal Reports 2008 (All Patch levels)

Reproducing the Issue

  1. Create a Crystal Report on a machine with dual monitor setup (You may chose not to have any data source for this report)
  2. Add a text field on the Report Header section and type some text in it
  3. Right click the text field and go to ‘Format field’
  4. In the ‘Common’ tab click on any of the conditional formatting buttons (x+2)
  5. Observe that the formula editor opens up on the Secondary display
  6. Now, without closing Crystal Reports disconnect the Secondary display
  7. Save the report and open it again on another machine with dual monitor setup
  8. Click on the conditional formatting button on the same text field
  9. The formula editor which would usually open up, fails to show up on the Main/Secondary

Cause

  • As the Crystal Reports designer is using dual monitor, the Formula Workshop was mapped for XY axis position of the window to display on the second monitor
  • This issue is not specific to Crystal Reports, however is applicable to any application on the Windows platform. This happens when you disconnect the Secondary display without moving the window (in our case, the Formula Editor) back to the Primary display

Resolution

Resolution 1:

***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 KB 1323322'' for more information.

  1. Close the Crystal Report Application.
  2. Click Start > RUN.
  3. Type "Regedit" and Click OK.
  4. Navigate to HKEY_CURRENT_USER\SOFTWARE\BUSINESS OBJECTS\SUITE 12.0\Crystal Reports\Formula Workshop
  5. Change the value data for Editor Position as 10,10,10,10

Resolution 2:

  1. Open the Crystal Report on any machine with dual monitor setup
  2. Click on the Conditional Formatting button (x+2) of any field
  3. Now, with Crystal Reports open and in focus use Alt + Space, then M, then Arrow key, and then move your mouse around
  4. The Formula Editor window which was earlier off-screen would appear from one of the sides of the screen
  5. Re-open the report and the Formula Editor should up on the Primary Display

Keywords

Formula Window disappears, Crystal Reports , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0