September 12, 2011 at 5:26 am
Hi,
I need to update an existing report model but there is a problem. There are a number of reports that have been created using the old version. If I delete the existing report model and replace it with the latest one, the dependent reports would fail. I don't know how to go about it.
Would someone have any idea on how to update the existing report model ?
Thanks,
Vishal
September 12, 2011 at 5:39 am
It depends on what changes you need to make to it - if you are going to drop columns that the existing reports depend on then they will fail as you note, so you are probably better off creating a new model.
If, on the other hand, you are adding columns or changing things in the model that will not cause the reports that reference it to fail then you can just regenerate the model and re-deploy it to the ReportServer and the existing reports will still function properly.
To do that you need to use the Report Model Project in Visual Studio that was used to generate the current model, make whatever changes you need to the Data Source View and then re-generate the model and re-deploy it - this maintains the same internal names for existing columns etc. so will not break reports that have already been written
As with any such changes, if have got a test environment to try them out in first, that is always preferable to making them directly to the production reporting environment
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply