Is it possible to update an SSRS Model using code to account for DB changes?
Posted on 2011-03-22
We have a DB where users can create custom fields against a record. These are stored as rows in the database.
I want to be able to add these custom fields to the reporting model using code on a nightly basis and re-publish the SSRS model.
I know the model is essentially XML, and I have code which returns the record rows with the user defined fields as columns.
Any advice or pointers would be very useful.
This is using MSSQL 2008 R2, with SSRS.