Current Lesson
Course Content

"The rowset column could not be found."

This happens when the report is referencing a view or a database field that doesn't exist or doesn't match what is expected.

For example, this could occur if you update your version of HIFIS and the database structure changes. Or it could occur if you're trying to run a report that references a view you do not have installed.

One possible fix is to install the missing view, if that is the problem.

Another possible solution is to update the report definition in Crystal Reports.

    1. Open the report in Crystal Reports.
    2. Under the menu "Database", select "Verify Database"
    3. When it display the message: "The database file <Report Name> has changed. Proceeding to fix up the report.", click "OK"
    4. You may need to map some fields
    5. Once completed, it will display the message: "The database is now up to date"
    6. Save the new version and run it again, or re-upload it to HIFIS and run it again.