We are on SharePoint 2007 and using Access 2007. The SharePoint list contains a column called
Assigned Person, column type: Person or Group, single selection, displaying only the name
1) When we Open with Access and Export a copy of the data, then create a report from that table, we do not have the option to group on Assigned Person.
2) When we Open with Access and Link to data on the SharePoint site, then create a report from that list, when we group by Assigned Person...
The same person has 2 groups - there are is no other grouping or sorts on the list, and i can't locate a correlation to another field to show why they would have to collections for the same person
The Person or Group column sorts "from smallest to largest" as though it is a number field.
The list is a task/activity tracking system we created custom for our needs. We want to pull a weekly report, grouped by Assigned Person, but cannot get access to work. We do not want to resort to anything more complex, as it takes a much longer
process to have reports pulled by Chrystal or one of those types of applications. And we cannot change out the field for something like a Choice column as the list already has a very large amount of content. Can anyone assist? Is there a setting
hiding somewhere that is causing the problem?
View Complete Post