This is driving me crazy as I know I have done it before. Currently live on 10.2.200 and working on a test server running 10.2.500. I copied all the custom reports and forms to the new server but I am getting an error on the custom quote form. I added the OrderQty field to the original report quite a while ago.
In 10.2.500 I get an error that “execution failed for dataset ‘Quote’. —> System.Data.SqlClient.SqlException: Invalid column name ‘OrderQty’.” The standard form works fine.
How do I refresh the Dataset/Data Source to get past this error?
Is this a BAQ Report? Or does it use a standard data definition?
The error is just saying that there is a field referenced in the sql of the dataset in the report that is not in the data source (data definition or baq). After an upgrade we have had data definitions altered by the system, even ones that are copies of the original data definitions. You may have to double check your field exclusions in the data definition.