I have a report using a SQL stored procedure joined with two tables and then two sub reports. One subreport uses another SQL stored procedure.
It seems that when I reach a certain record, I receive the message
"One or more fields could not be found in the result set. Use Verify Database to update the report."
I have verified the database and it returns "Databse is up to date"
All pages of the report prior to this particular record display fine.
I can execute the stored procedure with the same parameter value in SQL Query Analyzer and the result set has all necessary fields.
Solutions, ideas, guesses?
n8