SAP Knowledge Base Article - Public

2553713 - "The remaining text does not appear to be a part of the formula" error on reports connected to Business Views

Symptom

  • "The remaining text does not appear to be a part of the formula" error on reports connected to Business Views
  • Filters in Data Foundation do not work as expected

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • Business View Manager 4.1
  • Business View Manager 4.2

Reproducing the Issue

  1. Start Business View Manager and login as Administrator.
  2. Create a new Data Connection to Efashion ODBC DSN. Save it (TESTDC)
  3. Create a new Data Foundation
  4. Create a new static string formula in DF like "ABC"
  5. Add a new Filter in the DF like @ABC="ABC" (the filter is always TRUE)
  6. Apply the filter for Everyone
  7. Apply Full Data Access filter to Everyone
  8. Save the Data Foundation (TESTDF)
  9. Create a new Business Element with some of the objects from the datasource. Save it (TESTBE)
  10. Create a new Business View. Save it (TESTBV)
  11. Start Crystal Reports Designer and login as Administrator
  12. Create a new report of the Business View
  13. Add few objects and refresh.
  14. Got the Error in Formula Error.

Cause

Resolution

  • Update the Product as per SAP Note: 2516492
  • Workaround: avoid having more than one filter per User or User Group in Data Foundation 

Keywords

BVM, CR, failed after upgrade , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016