I am working on a SharePoint application where the data is kept in lists. For ease of reporting, we create views in SQL Server 2005 that link lists together, and our Reporting Services model is based on these views.
我正在开发一个SharePoint应用程序,其中数据保存在列表中。为了便于报告,我们在SQL Server 2005中创建了将列表链接在一起的视图,我们的Reporting Services模型基于这些视图。
As users add/modify/delete fields, our views become stale. When we recreate the views, some reports are no longer valid. What is the best way to allow users to modify fields and update the existing reports automatically (or notify an admin that a report has been broken by changing a field)?
当用户添加/修改/删除字段时,我们的视图将变得陈旧。当我们重新创建视图时,某些报告不再有效。允许用户自动修改字段和更新现有报告的最佳方法是什么(或通过更改字段通知管理员报告已被破坏)?
1 个解决方案
#1
Have you thought about reporting directly off the Lists, maybe using a product like http://www.enesyssoftware.com/ which is a reporting service data extension. This still won't help with your reports going stale when your users add/remove column.
您是否考虑直接从列表中报告,可能使用http://www.enesyssoftware.com/这样的报告服务数据扩展的产品。当您的用户添加/删除列时,这仍然无法帮助您的报表过时。
#1
Have you thought about reporting directly off the Lists, maybe using a product like http://www.enesyssoftware.com/ which is a reporting service data extension. This still won't help with your reports going stale when your users add/remove column.
您是否考虑直接从列表中报告,可能使用http://www.enesyssoftware.com/这样的报告服务数据扩展的产品。当您的用户添加/删除列时,这仍然无法帮助您的报表过时。