.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Rollup breaking on people/group field.

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :SharePoint
 

I've built a rollup of a list that works great up until include a field called "Project Resources" which is a People/Group field that allows multiple selections. When I add that FieldRef to my ViewFields list the output goes from 4 rolled up items (which is correct) to 0 items. Each list has at least one person in the resources field.

It doesn't matter what form the select command is in (&lt;FieldRef Name=&quot;Project_x0020_Resources&quot;/&gt; or <FieldRef Name='Project_x0020_Resources'/> ) that field seems to break the rollup.

Any ideas?


Chris G.


View Complete Post


More Related Resource Links

A customized EditForm.aspx page giving error because it has a "People and Group" field with a "Allow

  
My customized EditForm.aspx which has a "People and Group" column with the "Allow multiple selections" property as "Yes" was working fine until the Agusust cumulative update was applied into the MOSS server. Now it's giving me the error: "An unexpected error has occurred". Needless to say, when I change the "Allow multiple selections" property to "No", the customized EditForm.aspx page works fine.Forgetting whyMicrosoft introduced this error for now, is there a workaround that you are awre of?

How to set a string field with people picker control group

  
Hi Guys I have a problem with a form list, when I need to set a string field with de content of people picker control that have more than one "user". Is there any way to put in string a list of user like the people picker control shows in a form? The really problem is I don't know how to read an array of user in a formula rule. any example or idea should be appreciated. tnks.  

Pulling data from MyProfile page to People & group's list

  
Hi, Is it possible to pull the data from Profile page, like the email, contact number etc to be displayed in the People & Groups page. Please refer the screenshot for better understanding..

Link to the image: http://img694.imageshack.us/i/pplgrps.png/


What is the best way to create user account for big group of people?

  

I need to create individual account for a big group of people (around 200) from an Excel spreadsheet. What is the best practice? It will take too much time to create account using web form. I think there must be a way to do it. Please advice. I tried to use Stored procedures created by ASP.NET. NOT SURE whether it is a good idea.

Thanks 


Views for different group of people in form library

  
I have created a form library with many fields. And I have created 3 views say X,Y and Z for this form library. I have 3 set of User groups say A,B and C. When a person in group A visits this form library,  the view 'X' should appear. Similarly when a person in group 'B' visits this form library the view 'Y' should appear. How can we achieve this.. Any suggestions...

Activiate Email forwarding with Person Group Picker field

  
I have inserted 3 person group picker fiels.  I need to set them up so when a user selects a user, it shoots off an email.  I was told that I can set this up in SP designer via a workflow?  If so, can anyone let me know how to set this up properly? Thanks!  Bill KreuderIm a new MS CRM Consultant that is learing all things CRM. Im very excited about 4.0!!!!

SharePoint 2007 to Access 2007 - Issues grouping by "Person or Group" field type/column

  
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? 

Group Calendar looses People

  
Hi, can anyone confirm, that the Group Calendar in the Group Site Template does not remeber the people entered?you can add several people, but after changing to a diffrent list and then switching back only the owner of the site is still on the calendar.Regrads,Oliver Kuhl

hide links in quick launch bar for "People and Groups", "Group", "All People"

  
Can you tell me how to hide links in quick launch bar for "People and Groups", "Group", "All People"? If a site user click these links all users in site collection will be displayed. (I do want it happends. I only need people for one site only) If you can show me how to display people in one site only would be perfect.

Why can I not group by calculated field in Date format?

  
After migrating to SP2010 Foundation, I've discovered that for some reason I can't group a list by a calculated date field. Ex: Create a list with a date column A. Create another column B with a simple calculated date of [A]+1 and use the field format type 'date' Modify view to group the list by column B.  You're list will load, but when you attempt to expand one of the groups you'll be greated with an exception error. Why?? Am I doing something wrong? Note: You can group fine if the data type for column B is anything except 'date' format, but I really need to group items by a calulated date. Ultimately, what I'm trying to do is group my list items by week by calculating the end of the week using a simple formula =[Must ship by]+7-WEEKDAY([Must ship by])  then I want to gropu by the [Must Ship by] column like I always did in SP 2007, but now it errors out.  I also wanted to create my own timesheet template since the Fab 40 templates aren't available for 2010, but I can't really do that effectively without being able to group timesheet entries by week.  

Sum of Calulated field in a group error when containing a value $0

  
Hi, I have a group which sums the total of the calculated field with expression: =SUM(Fields!MTD_VAR_CY_v_LY_D.Value) If one of the value in the child row for Fields!MTD_VAR_CY_v_LY_D.Value is 0, the group will display #Error. Anyone knows why this is the case?

Make a list field ediable by a group of users or hidden to everyone else.

  

I understand how to hide a field, but this hides it for everyone. My team want to hide it for the users and show it for our team. The field we want hidden from other users are Assigned to, Due Date, and Due Date, but we want our team to be able to edit these fields; not the other users. Is it any way to do this? Thanks for the help.

Mike

 


InfoPath 2010, People Picker Control - problem with sharepoint group targeting

  

Hello!

I have developed InfoPath 2010 web form with People Picker Control. I want to set sharepoint group which would be used in People Picker Control to search people. Ok, I set sharpoint site url and aftet that - select sharepoint group 'Test InfoPath group' I need. Everything works fine - I can select only people inside sharepoint group 'Test InfoPath group'.

Now I deploy my solutions (wsp package) on different site collection and sharepoint server installations. In this case People Picker Control can't find right sharepoint group 'Test InfoPath group'. Sometimes People Picker Control select another group, not that I have select in InfoPath Designer and sometimes People Picker Control select all users.

What's wrong with it and can I configure People Picker Control to select sharepoint group?


InfoPath 2010, People Picker Control - problem with sharepoint group targeting

  

Hello!

I have developed InfoPath 2010 web form with People Picker Control. I want to set sharepoint group which would be used in People Picker Control to search people. Ok, I set sharpoint site url and aftet that - select sharepoint group 'Test InfoPath group' I need. Everything works fine - I can select only people inside sharepoint group 'Test InfoPath group'.

Now I deploy my solutions (wsp package) on different site collection and sharepoint server installations. In this case People Picker Control can't find right sharepoint group 'Test InfoPath group'. Sometimes People Picker Control select another group, not that I have select in InfoPath Designer and sometimes People Picker Control select all users.

What's wrong with it and can I configure People Picker Control to select sharepoint group?


Programmatically creating a Person or Group type field Textbox (similar to 'Assigned To' field in Ta

  

In our ASP.NET application created with SharePoint object model, we have a user interface with a Contact Person TextBox, we want this TextBox to be similar to the “Assigned To” filed in out-of-the-box Task List where you can search for a particular site user by typing in his/her name. How can we achieve this functionality programmatically?

Thanks in advance………


how to make start date,end date and people and group readonly using sharepoint designer

  

hi,

how to make start date,end date and people and group readonly using sharepoint designer(sharepoint 2007).

I have created calendar list in that i have people and group column .

In edit mode i want start date ,end date and people and group column read only.

 

very urgent


problem with datasheet view and people and group lookup

  

hi,

There seems to be a problem in my list datasheet view, when I try searching for a certain person's name from the lookup list, whereas when I click the new item, choose from the people and column list..I can view their names..Why is it so..


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend