How can you update reports when Data Sources change?
When the data sources that drive reports change, the reports no longer list or load because the security layer assumes permissions have changed. It is recommended that items do not get removed or renamed form data sources once reports are created from them. If, however, it is necessary to rename fields the report XML must be updated as well.
WARNING: Improperly applying these techniques will result in damage to reports. Fully qualified names (i.e. [dbo].[Table].[Field]) MUST always be used. Please backup you reports before proceeding.
Database Mode
The following query will update all reports to use Field1 rather than FieldOne as the field name.
UPDATE IzendaAdHocReports SET Xml = REPLACE(CAST(Xml AS NVARCHAR),'[dbo].[Table][FieldOne]','[dbo].[Table].[Field1]')
Filesystem Mode
If reports are stored as files, simply use a search and replace tool to change all instances of once field with another.
Search: [dbo].[Table].[FieldOne]
Replace: [dbo].[Table].[Field1]