2211751 - Error: 'This report contains invalid Crystal Reports formulas that cannot be evaluated.' when opening a report in Crystal Reports Viewer

SAP Knowledge Base Article - Public

2211751 - Error: 'This report contains invalid Crystal Reports formulas that cannot be evaluated.' when opening a report in Crystal Reports Viewer

Symptom

  • Error: This report contains invalid Crystal Reports formulas that cannot be evaluated; or
  • Error: This report file does not contain saved data and connet be viewed.
  • Unable to view a report with saved data in Crystal Reports Viewer.
  • When opening a report with saved data in Crystal Reports Viewer, it fails with the error:
     
        Formula Evaluation Problem
        This report contains invalid Crystal Reports formulas that cannot be evaluated.
        Contact the report author to correct the problem.

       CRV - Formula Error.png 
            
  • The report successfully open in Crystal Reports designer and display the saved data,  the error only occurs when opening the report in Crystal Reports Viewer.

Environment

  • Crystal Reports Viewer 2008
  • Crystal Reports Viewer 2011
  • Crystal Reports Viewer 2013

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
         
  2. Create a formula using the ShiftDateTime function, set the time zone to be empty, and insert the formula on the report.
    An empty time zone indicates it will take the local time zone of the computer. The formula will look like:
     
    ShiftDateTime (DateTime (2013, 01, 01,0, 0, 0), "UTC,0", "")
     
  3. Save the report with data.
       
  4. In Crystal Reports Viewer, when opening the report with saved data, it displays the error:
      
       " Formula Evaluation Problem
         This report contains invalid Crystal Reports formulas that cannot be evaluated.
         Contact the report author to correct the problem."

Cause

  • This issue occurs when the report contains a formula using the function: ShiftDateTime.
  • The issue has been identified and logged under Problem Report ID ADAPT01698517

Resolution

  • The issue is resolved in the following product updates:
          
    • Crystal Reports Viewer 2013 - Support Pack 06 and higher.

Keywords

shiftdatetime, CRV, CR Viewer , KBA , BI-RA-CRV , SAP Crystal Reports Viewer , Bug Filed

Product

Crystal Reports Viewer 2008 ; SAP Crystal Reports Viewer 2011 ; SAP Crystal Reports viewer 2013