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
-
Start Business View Manager and login as Administrator.
-
Create a new Data Connection to Efashion ODBC DSN. Save it (TESTDC)
-
Create a new Data Foundation
-
Create a new static string formula in DF like "ABC"
-
Add a new Filter in the DF like @ABC="ABC" (the filter is always TRUE)
-
Apply the filter for Everyone
-
Apply Full Data Access filter to Everyone
-
Save the Data Foundation (TESTDF)
-
Create a new Business Element with some of the objects from the datasource. Save it (TESTBE)
-
Create a new Business View. Save it (TESTBV)
-
Start Crystal Reports Designer and login as Administrator
-
Create a new report of the Business View
-
Add few objects and refresh.
-
Got the Error in Formula Error.
Cause
-
This is documented Product Defect, see 2516492 - If apply Full Data Access filter to Everyone in BVM data foundation, reports based on this data source will return error.
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