Unable to update existing Crystal Reports after Munis upgrade

Unable to update some tables or views in existing crystal reports after a Munis upgrade

• Munis all versions

• Crystal Reports

• ODBC

• Tyler Reporting Services views

Some columns that are used in the report are changed from date to datetime datatype 

While updating the old views from existing ODBC connection to new ODBC connection Crystal reports application will show a pop-up window for columns that it could not automatically update. To update columns manually, follow the steps below:

1. In the pop-up window, un-check the option Match Type

2. Click once on the old column name from the left section and select the same column from the right section and click Update

3. Repeat steps 1 and 2 for all the columns in the left section.