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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Grouping by "multiple choices" column

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


This is for Sharepoint 2010

In a document library, I am trying to create a view that would group files by "projects". A file could be part of multiple projects.

file1.doc : projectA, projectB
file2.doc : projectB
file3.doc : projectB, projectC

I would like the view to show things this way :


By default Sharepoint does not allow grouping by "multiple choices" columns. However it seems that using sharepoint designer this could be done. I could only find articles on how to do this in MOSS 2007 but not MOSS 2010 (http://blog-sharepoint.blogspot.com/2009/09/solved-cant-group-by-choice-column-in.html).

Any suggestion on how I could achieve my goal with sharepoint designer 2010 ?


Thank you


View Complete Post

More Related Resource Links

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? 

Right most column grouping?

Hi All, i have a requirement.. Report values   Employee name       #worktype     #work%     totalwork% 1                             Typ1             100%         75%                                Typ2              20%           ---------------------------------------------------------------- 2                            Typ1                 10%        10% --------------------------------------------------------------- 3                       

Managed Metadata column not grouping correctly



I'm trying to group a list by a Managed Metadata column, it works fine with my farm admin/site collection admin user account however i can't get it to work for any other user account. I've tried giving one of the other user accounts term store admin but still no luck. With these user accounts all i get is one group which contains all items regardless of what term is selected for the item. The single group displays as an empty term e.g. it looks something like 'MetaData Column: (80)'. However if you look at individual columns you can see what term has been selected.

If it makes any difference I'm experiencing the issue while using an Enterprise Wiki site, I'm trying to group pages in the pages library by the 'Wiki Categories' column. I've set the field to point to a new term set and disabled multiple entries.

Any ideas?

Issue with row and column Grouping

In my report I have two row groups one below the other that belong to the same parent group. I also have a column group. What happens is until I have only one row group and one column group the report works fine. When I add a second row group below the first one the values are displayed correct for this second row grouping but the values for the first row group which were earlier correct are not shown. The display for those values is blank. Can anyone help with why this is happening? 

Grouping by taxonomy column



it is possible to group a view by a taxonomy column. Taxonomy columns are not listed in dropdown in the group by option (modify view).

I found that: http://www.sharepointanalysthq.com/2010/06/how-to-group-by-content-type-in-sharepoint-2010/
But this doesn't work for taxonomy columns !??!? ;(


Daniel Schmitz

How to display/calculate total of a custom column in dataview webpart's grouping header



I've created a dataview from a MOSS2007 form library. In the dataview, I've enabled grouping by a specific column and also was able to show the total (sum) of couple of columns like this, in the group heading:

<xsl:value-of select=”sum($nodeset/@Total_x0020_Cost)” />

So far, it's working fine. I've added couple more columns to this dataview. There's a piece of javascript code that is executed for each row. These 2 columns gets their value from this javascript. Now, is there anyway, I can get the total/sum of these columns in the group heading.

Have you done something like this? Please advise.




Matrix Column grouping - Total column incorrect when colum value is wrapped in a call to code


I have a column grouped matrix report that shows count, cost and duration.  Duration is time in seconds.  To format the time on the report as hh:mm:ss I send it through a code block that converts the int to a string. 

When the report is generated the total column is NOT code.convert(sum(Fields!Duration.Value)).  At first I thought it was taking the max value, then I thought it is was taking the first value.. not really sure how it is calculating the value.

I did trying wrapping the expression like this IIF(InScope("matrixgroup"), Code.Convert(Fields!Duration.Value), Code.Convert(Sum(Fields!Duration.Value))).  It didn't make a difference the column is still incorrect.

If I remove the Code.Convert from the column, the value is correct.

Does anyone have any suggestions?



Needing a Total based on a dynamic total in a column grouping


Hi, Please help

I am using RS2008
I have a Tablix with a row grouping by Location and a row field Totalling the current employee count for that state

I have three adjacent columns grouping by Month, based on what month is selected in the multivalue-parameter, one column returns back number of employees joined for those months. second column how many left for those month. The third column the total headcount for those months

FOR Example if the parameter selected was Jan, Feb, March, the below would be returned

                                 JOIN                   LEFT                  HEADCOUNT
     CURRENT      Jan  Feb March         Jan Feb March         Jan Feb March 
WA     15              2    3    4        &nbs

Playing with Linq grouping: GroupByMany?

One of its features is grouping. Many people understand grouping like it is defined in Sql. Linq is implementing grouping quite the same way. Let's discover this syntax and how to make consecutive groups easier.

Grouping Gridview with jquery

The requirement of the project is to show a table of data with the riskdetails(just for assumption) which have the corresponing values for every month and people used to compare the values for last months.

Building a grouping Grid with GridView and ASP.NET AJAX toolkit CollapsiblePanel

I've posted an update to this post to apply on demand loading of Details data using ASP.NET AJAX PageMethods. I'm demonstrating the usage if CollapsiblePanelExtender client events on the new post. Check it out.

I admit, Matt Berseth is really inspiring me! Few days ago I pass through 2 of his great posts:

.Surrounding your Data Table and Dialog Controls with ComponentArt Styled Panels
.Building a Grouping Grid with the ASP.NET 3.5 LinqDataSource and ListView Controls
The first one is pure design tips one which I used for making good presentation of my demo here. The 2nd post is actually the idea.

Grouping Gridview with jquery in asp.net

The requirement of the project is to show a table of data with the riskdetails(just for assumption) which have the corresponing values for every month and people used to compare the values for last months.

Tooltip for GridView Column Headers (ASP.Net)

I just wanted to add auto tooltips for my GridView headers. There are couple of ways but I don't want to use javascript and wanted to use simple 'title' attribute. It took couple of hours to get the working code supporting sortable columns. I thought it will be very useful for others. Here's the code and logic behind it.

Multiple Column Dropdownlist for the ASP.NET DataGrid

Based on my previous control "Multiple Column DropDownList for ASP.NET", I received many emails asking for the same control to be used in the DataGrid for web applications. Here we go.. This control can be used as the regular MS DropDownList in the DataGrid and also as a regular dropdownlist. It has all the properties, like DataTextField, DataValueField, DataSource, SelectedIndex etc. The download file contains the samples both in VB.NET and C#. In this sample, I have used the Northwind database of SQL Server.

Alternating row background for first column of a report


is there a way to make the first column of a report use the an alternating background color? 

I have the background color set for the entire row however it does not work for the first column if the color is set to an expression.  If I just set it to a color i.e. red it works just fine. If I insert a dummy column to the left it works just fine (but the dummy column does not work, presumably because it is first??).

In the file below only the textbox for part number does not show an alternating background.  All others work correctly.

                    <Textbox Name="PartNumber">

Use a column as parameter for a sds in another column; gridview


Hola, I have a gridview which is bound to a sds which returns 7 columns and I added two columns from the GUI.  What I want is to fill up the 9th column with DDLs and these  DDLS will get their data from a different sds which is using a stored procedure with a single parameter.  I created the 9th row, used template field, made the sds for 9th row, the stored_procedure, threw a DDL in Item template and all  I need now is to pass a parameter in the first column to the sds in the 9th column.  I can code this but i'm getting tired of aspx.cs :) and would like to do it from the GUI.

Pass a grid column value to a Modal


Hi, I have a requirement to hide a field called details on a gridview and show it in a jQuery modal dialog when users click on the Customer ID hyperlink. This grid is created programmatically. I will be hiding the details column via the CSS display:none property. Does some one know how can I pass the grid's selected hidden column value to the modal? Here is some of the code I started:

            GridView mygrid = new GridView();
            //.....................................More columns code for the grid

            //Here is where I need to pass the Details column value associated with the customer ID field selected to the Modal and open the Modal dialog.            
            HyperLinkField linkField = new HyperLinkField();
            string[] dataNavigateUrlFields = { "CustomerID" };
            linkField.DataTextField = "CustomerID";

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