A script-enabled browser is required for this page to function properly.

Database changes migration issues

Only changes in column datatypes result in migration issues. Adding a column to a database regardless of its type will not affect existing reports.

When a datatype has been changed, a REPT 0499 error will occur when the report is opened. This error occurs when the datatype of a field in the database does not match the datatype of the same field in the report. To resolve this error, use the following steps:

  1. Open the report in Reports Builder.

  2. In the Data Model view, click a query.

  3. Right-click, and choose Data Wizard from the menu.

  4. On the Data page of the wizard, add a space to the end of the query.

  5. Click Apply to reparse the query and update the datatypes in the report.

  6. Click Finish.

  7. Repeat steps 2 through 6 for each query in the Data Model.

Note: If the report uses external queries, they will also have to be updated.