Symptom
A Stored Procedure parameter report when trying to refresh popping for an error "Database Connector Error:’42000:[Microsoft][SQL Native Client][SQL Server]Procedure or function ‘Customer’ excepts parameter ‘@CustomerID’,which was not supplied.[Database Vendor Code:201]’ "
Reproducing the Issue
- Create a report using Xtreme sample database with a stored procedure parameter.
- Create a sub report, and the sub reports are linked using the parameter from the main report which was created at the stored procedure level to the sub report parameter.
- Modify the names of the stored procedure parameters.
- Set the "Verify Database" Option in Crystal Reports Designer.
- Close the reports and re-open it and try to refresh the report, it throws for an error: "Database Connector Error:’42000:[Microsoft][SQL Native Client][SQL Server]Procedure or function ‘Customer’ excepts parameter ‘@CustomerID’,which was not supplied.[Database Vendor Code:201]’ "
- Database: SQL Server 2000 / 2005
Resolution
This is a known issue and has been fixed in Service Pack 4 for Crystal reports XIR2
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem