When a data source is updated or changed, it is imperative for users who are working on reports dependent upon that data source to refresh the generated SQL.  Failing to do this may result in displaying outdated or incorrect information.

Refresh Generated SQL for a given report:

1. Open the Report: Navigate to and open the report that you wish to refresh the SQL for
2. Verify Permissions: Ensure you have the necessary permissions to view and interact with the report
3. Refresh Report SQL for Pagination: Manually initiate a refresh for the report’s generated SQL.  This can be done by placing the report in ‘EDIT’ mode and from the Extended Menu clicking ‘Refresh Generated SQL.’  Note that pagination will only be enabled if there are more than 500 records displayed in the grid

Check Updated Data:

1. Once the SQL is successfully refreshed, you should see the updated data in the report.  If you do not see the updated data, please verify the steps and consult your system administrator