I am struggling with a pesky error coming back from one of our Crystal Reports here.
“One or more fields could not be found in the result set”
The report itself references a SQL Server Stored Procedure which may have changed.
When I research the error to-date I have identified that there may be a difference in the number of columns, fields compared to the stored procedure but to be honest I cannot see any differences.
If you ‘Verify Database’ before running the report, what message, if any do you get?
Before you run the report, if you look at the field explorer, you should see all the fields that are being used in the report (check mark icon next to the field). Then it would be a matter of verifying (slight modification of the field name could cause an issue) each field exists in the new stored procedure.
Unfortunately, Verify Database doesn’t always work to fix issues with updated stored procedures. If it doesn’t work for you, you should use Set Location to point to the updated stored proc so that Crystal will get the updated field names and types.
(BOB member since 2010-06-23)