Symptom
- Error: One or more fields could not be found in the result set.
- When refreshing a report based on Salesforce.com, it fails with the above error.
- It was possible to successfully refresh the same report before.
- When refreshing a report based off a Salesforce.com Stored Procedure in Crystal Reports, it fails with the error:
"One or more fields could not be found in the result set.
Use Verify Database to update the report."
Environment
- SAP Crystal Reports 2013
- Salesforce.com
Reproducing the Issue
- In Crystal Reports, create a report off a Salesforce.com Stored Procedure.
- Notice the report can successfully refresh.
- Save the report
- Few days later, refresh the same report in Crystal Reports, and it fails with the error:
"One or more fields could not be found in the result set.
Use Verify Database to update the report."
Cause
- The report was created off a Salesforce.com Stored Procedure.
- The error occur because the Salesforce.com Stored Procedure was modified. Since it does not output all the same database fields, it generates the message to update the report definition.
- Note: A Salesforce.com Stored Procedure is actually a report created in Salesforce.com. In external application like Crystal Reports, it is displayed as a stored procedure.
Resolution
- The report definition needs to be updated in Crystal Reports designer using the "Verify Database" option.
- While the report is open in Crystal Reports, select under the menu "Database", select "Verify Database"
- When it display the message: "The database file <Report Name> has changed. Proceeding to fix up the report.", click "OK"
- If it is not possible to automatically mapped the database fields, it will then display the "Map Fields" window.
Manually map the database fields, and click "OK"
- Once completed, it will display the message: "The database is now up to date"
- Save the report.
Note: If some of the database fields that were removed from the Salesforce.com stored procedure were used in formula, group, chart,... You will need to modify the formula, group, chart,... before being able to successfully refresh the report.
Keywords
SForce, CR, SP, StoredProc , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2013