Refreshing a Data Source for a Report

You can refresh the columns in a data source in the designer at any time. Be aware that refreshing a data source means that all live report objects that are connected to that data source will have their queries re-run.

Note: Refreshing a data source adds any new columns that have been added to the table metadata. The default formats and names of existing columns will be updated the next time you open the report.

To refresh a data source for a report, on the Data tab, select the data source, and then click refresh data icon

. When you refresh a data source for a report, columns that have been deleted from the table metadata will automatically be removed if they do not impact any objects in the report. If deleted columns do impact objects in the report, then the Repair Report window is displayed so that you can repair the objects that are impacted by the deleted columns.For more information, see Repairing Reports.