Reporting Services 与 SharePoint 的连接
我需要在 SQL Server Reporting Services 2005 (SSRS) 上根据来自 SharePoint 列表的数据创建报告，
我正在寻找实现此目的的方法，并且发现
- 连接到 SharePoint Web 服务 输出XML，问题就在这里 有时有效有时无效 而且我也无法进行内部连接 在不同的列表之间可能是 那里但是做起来会很麻烦 我认为（如果有简单的方法 请告诉我）
- 在 MS Access 中创建链接表 2007 链接到共享点列表， 然后连接到 MS ACCESS SSRS 2005 的链接表：这个 会起作用，但我有点害怕 我总是在中间有 ACCESS 想要避免使用
- 连接到中提供的视图的 访问 sharepoints 后端数据库 （有一个所有列表的视图和 所有列表项的另一个视图）： 这里的列名会很麻烦 创建查询 cloum 名称 像 （浮点1，浮点2，...，日期1，日期2，日期3，....） ，我也不确定这是否好 让 SSRS 直接对话的东西 sharepoints后端数据库视图
你能告诉我哪种方法最好（或者如果有更好的方法请告诉我）
我有点喜欢第三种方法，但不确定是否应该使用它
I need to create reports on SQL Server Reporting Services 2005 (SSRS) on data coming from SharePoint Lists,
i was searching for ways to do that and i found,
- connecting to SharePoint web service
out put XML, the problem here is it
sometimes work and sometimes don't,
and also i couldn't do inner join
between different lists may be it is
there but it will be trouble to do
it i think (if there is easy way
tell me please) - Creating a link table in MS Access
2007 that links to sharepoint lists,
and then connect to the MS ACCESS
link tables from SSRS 2005 : this
will work but i am kind of scared of
having ACCESS in the middle i always
want to avoid using access - connecting to the views provided in
the sharepoints backend database
(there is a view for all lists and
another view for all list items) :
here column names will be troublsome
to create the query the clounm names
are like
(float1,float2,...,date1,date2,date3,....)
, also i am not sure if it is good
thing to make SSRS talk directly to
sharepoints backend database views
can you tell me which of these ways is best (or if there is a better way plz tell me)
i kind of like the third way but not sure if i should use it
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我在我们的维基上总结了这个问题，但并不完整。
http://wiki. Threewill.com/display/企业/报告+on+列表+数据+in+SharePoint。
请注意，我们已经尝试了 CorasWorks DIT，它看起来是一种很有前途的方法。
I have summarized this problem on our wiki, but it is not complete.
http://wiki.threewill.com/display/enterprise/Reporting+on+List+Data+in+SharePoint.
Note that we have since tried out the CorasWorks DIT and it looks like a promising approach.
我们每晚都会将所有数据导出到 SQL 数据库（出于性能考虑，我们还开始将项目从 Sharepoint 移走）。 然后我们使用标准的 Reporting Services 创建报告...
We are exporting all the data to a SQL database everynight ( we have also started to move items away from Sharepoint because of performance). Then we use standard Reporting Services to create the reports....
查看 SharePoint 列表关联管理器、SLAM。
让您能够实时准确地完成您想做的事情，而且它是免费的并且得到很好的支持。
http://slam.codeplex.com
Check out SharePoint List Assocation Manager, SLAM.
Allows you to do exactly what you're looking to do in real time and it's free and very well supported.
http://slam.codeplex.com