Troubleshooting: Error 13 - Type Mismatch

Symptoms

There is a data type mismatch between either what is passed from the form to the report file, or from the report file to the stored procedure.

Possible solutions

This can occur if the form passes the parameters in the wrong order, or a parameter is not defaulted correctly. For example, a form might be passing in a blank for the Show Header check box.

If you get this error, try selecting the check box and running it again.

If this does not work, try selecting every check box and putting a value in every field.

Finally, try running the stored procedure through the SQL Server Management Studio with the same parameters as those in BGTaskHistory, replacing blank parameters with NULL, and putting single quotes around strings, dates, and guids.