How can I automatically update reports if I change my data sources or views?
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. Izenda recommends creating views to simplify the user experience and to provide for an easy way to maintain reports of the data structures change. If a report points to a view, only the view will need to be updated if the schema changes. 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]