Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 column descriptions in report builder

Author  Topic 

hugh_mungo
Starting Member

10 Posts

Posted - 2008-02-12 : 06:28:56
Hi,

In my database application we allow users to change some of the field captions (column descriptions). They can do this at any time.

I want to allow users to use report builder in reporting services to create their own ad-hoc reports. I would like for them to be able to see the field captions they have entered in the report model instead of the field names. I know this is possible to do when the data view is created.

But what happens if the user changes the column description after the data view has been created? Can the model be re-created and will already existing ad-hoc reports still work?

What is the best way to manage such a scenario?

Thanks in advance for an help.
   

- Advertisement -