使用Access和SharePoint列表创建报告 [英] Creating a Report with Access and SharePoint list

问题描述

将SharePoint列表表链接到Microsoft Access.我在SharePoint列表中的一列是人员或组".它是具有SharePoint用户多个属性的查找.这些属性包括ID，名称，电子邮件地址.我将电子邮件地址属性用于SharePoint中的工作流.现在，我想从SharePoint列表中创建一个报告，以打印出分配给每个记录/行的所有名称.而不是打印出名称，而是返回ID号.如何获取访问权限报告以返回从共享点列表链接的名称?

Linked SharePoint List table into Microsoft Access. One of my columns within the SharePoint list is "Person or Group" It is a lookup that has several attributes from SharePoint users. Those attributes include ID, Name, e-mail address. I use the e-mail address attribute for workflows within SharePoint. Now I want to create a report from the SharePoint List that print out all of the names that are assigned to each record/row. Instead of printing out the name it returns the ID number. How do I get the access report to return the name that is linked from the sharepoint list?

推荐答案

每次链接到SharePoint网站时，如果看起来很近，您总会看到一个名为UserInfo的表(列表).

Anytime you link to SharePoint site, if you look close, you will ALWAYS see a table (list) called UserInfo.

那么，要使用用户名代替ID?

So, to get the user name in place of ID?

首先设置指向此userInfo表的链接.

First setup a link to this userInfo table.

因此，在外部数据(导入和链接)上的功能区上，选择链接到SharePoint列表.选择您的站点，然后在表列表中选择一个UserInfo:

So on ribbon on External data (import and link), choose to link to a SharePoint list. Choose your site and then in the list of tables, choose the UserInfo one:

例如:

因此，将因此建立到UserInfo列表/表的链接.

Thus will thus setup a link to the UserInfo list/table.

然后，只需从用户的ID列构建查询(左联接)即可.

Then, simply build a query (left join) from the ID column of the user.

查询将如下所示:

构建一个查询，以保留UserInfo中的联接.

Build a query that left joins in UserInfo.

但是，请注意，如果您查看该表，则不会看到多余的列，但可以在查询构建器中看到.请注意，SharePoint编辑器已添加到每个表.因此请注意每个表的这些字段:

However, do note that if you look at the table, you don't see the extra columns, but you do in the query builder. Note that SharePoint editor is added to EVERY table. so note these fields for EVERY table:

因此，您甚至可能不需要使用连接到UserInfo表的查询，因为如上Access中所示，所有表都将SharePoint编辑器自动添加到每个链接表中.

So you well might not even require to use a query joined to the UserInfo table since as above shows in Access ALL tables have the SharePoint editor automatic added to every linked table.

但是，根据需要链接到基于"id"的UserInfo表应该可以在位置ID中显示名称".

However, linking to the UserInfo table based on the "id" as you have should allow you to display the "name" in place id.

这篇关于使用Access和SharePoint列表创建报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！