We intend to allow our users to create reports using Report Builder 3.0 on SQL Server 2008 R2. However, we allow our customers to make table changes, and would require the Report Model for our database to be updated dynamically. This link suggests this functionality isn't available: http://connect.microsoft.com/SQLServer/feedback/details/467627/update-ssrs-report-model-dynamically This may have changed since the R2 release of SQL Server 2008, but I can't find any documentation for this. Has anyone done this, or is the only way of building/rebuilding the report model to create it in BIDS?

Hi Matt_McQueen, Currently, the only way to update report models are re-create them by using Business Intelligence Development Studio tool. If the functionality adds in the future release of SQL Server, I will let you know immediately. Thanks for your understanding. Regards, Bin Long Forum Support If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.comPlease remember to mark the replies as answers if they help and unmark them if they provide no help.